Reconnect CFE and initial error checks: Difference between revisions

(21 intermediate revisions by 2 users not shown)

Line 1:

Once you [["Pull" ~~Centralized data~~.~~mdb~~]] you need to initialise the program and make sure that you have consistent initial data.

Once you [["Pull" Centralized_data.accdb]] you need to initialise the program and make sure that you have consistent initial data.

== Instructions ==

* ~~Click~~ the "Re-connect Data" button

* click the [["Re-connect Data" button]]

* ~~Screen prompt~~ '~~Could not find file ... DSM...~~'~~, answer~~ '''~~YES~~'''

* the reconnector will do the following

~~{{DT | Fix why it gives this error as part of fixing DSM process. }}~~

** '''no need to run them manually'''

* ~~The program will now reset the connections from [[CFE]] to [[Centralized data.mdb]], [[PHI.mdb]] and [[TISS28 Data.mdb]]~~

** confirm if [[L_Log table]] and [[L_PHI table]] have the same records in them. If they don't there will be an error; see [[Procedure when there are differences between L Log and L PHI]] for how to proceed

* ~~the reconnector will~~ confirm if [[L_Log table]] and [[L_PHI table]] have the same records in them. If they don't there will be an error; see [[Procedure when there are differences between L Log and L PHI]] for how to proceed

** runs the initial [[cross check]]s, but only shows them if errors are found. If there are errors, correct them before proceeding to the next step,

* ~~Run~~ initial cross ~~checks:~~

*** [[Reconnect_check_Completes query]] - Generally, errors in missing are the result of a failed send, so follow [[Re-sending data]] to fix

** [[~~PL_1orphans~~]]- see [[Orphans in ~~Centralized data~~.~~mdb~~]] for what to do about these.

*** [[Reconnect_check_orphans query ]] - see [[Orphans in Centralized_data.accdb]]for what to do about these

** [[PL missing L Tables content]]

*** [[Reconnect_check_missing_L Tables_content query]] - Generally, errors in missing are the result of a failed send, so follow [[Re-sending data]] to fix

*** ~~for now there are some CCIs on this list.~~

~~{{DT |Tina will fix~~ [[~~Query check CCI must have entry~~]] ~~so those are caught going forward. }}~~

* If there were no errors, continue what you were doing, likely the next step of [[Centralized data Vetting Process]]: [[Pre-linking checks]]

~~***~~ Generally, errors in missing are the result of a failed send, so follow [[~~Cleaning up a failed send~~]] to fix.

~~{{DT | re-name these so not PL any more }}~~

* ~~Continue~~ what you were doing, likely the next step of [[Centralized data Vetting Process]]: [[Pre-linking checks]]

== Related articles ==

@@ Line 1: / Line 1: @@
-Once you [["Pull" Centralized data.mdb]] you need to initialise the program and make sure that you have consistent initial data.
+Once you [["Pull" Centralized_data.accdb]] you need to initialise the program and make sure that you have consistent initial data.
 == Instructions ==
-* Click the "Re-connect Data" button
+* click the [["Re-connect Data" button]]
-* Screen prompt 'Could not find file ... DSM...', answer '''YES'''
+* the reconnector will do the following
-{{DT | Fix why it gives this error as part of fixing DSM process.  }}
+** '''no need to run them manually'''
-* The program will now reset the connections from [[CFE]] to [[Centralized data.mdb]], [[PHI.mdb]] and [[TISS28 Data.mdb]]
+** confirm if [[L_Log table]] and [[L_PHI table]] have the same records in them. If they don't there will be an error; see [[Procedure when there are differences between L Log and L PHI]] for how to proceed
-* the reconnector will confirm if [[L_Log table]] and [[L_PHI table]] have the same records in them. If they don't there will be an error; see [[Procedure when there are differences between L Log and L PHI]] for how to proceed
+** runs the initial [[cross check]]s, but only shows them if errors are found. If there are errors, correct them before proceeding to the next step,
-* Run initial cross checks:
+*** [[Reconnect_check_Completes query]] - Generally, errors in missing are the result of a failed send, so follow [[Re-sending data]] to fix
-** [[PL_1orphans]]- see [[Orphans in Centralized data.mdb]] for what to do about these.
+*** [[Reconnect_check_orphans query ]] - see [[Orphans in Centralized_data.accdb]]for what to do about these
-** [[PL missing L Tables content]]
+*** [[Reconnect_check_missing_L Tables_content query]] - Generally, errors in missing are the result of a failed send, so follow [[Re-sending data]] to fix
-*** for now there are some CCIs on this list.
-{{DT |Tina will fix [[Query check CCI must have entry]] so those are caught going forward. }}
+* If there were no errors, continue what you were doing, likely the next step of [[Centralized data Vetting Process]]:  [[Pre-linking checks]]
-*** Generally, errors in missing are the result of a failed send, so follow [[Cleaning up a failed send]] to fix.
-{{DT | re-name these so not PL any more }}
-* Continue what you were doing, likely the next step of [[Centralized data Vetting Process]]:  [[Pre-linking checks]]
 == Related articles ==