Reconnect CFE and initial error checks: Difference between revisions

Line 3:

== Instructions ==

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

* the reconnector will

* the reconnector will do the following

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

** 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 checks, but only shows them if errors are found. If there are errors, correct them before proceeding to the next step,

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

* ~~the [["Re-connect Data" button]] automatically~~ runs the initial cross checks, but only shows them if errors are found. If there are errors, correct them before proceeding to the next step,

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

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

*** [[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

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

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

** [[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

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

@@ Line 3: / Line 3: @@
 == Instructions ==
 * click the [["Re-connect Data" button]]
-* the reconnector will
+* the reconnector will do the following
+** '''no need to run them manually'''
 ** 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 checks, but only shows them if errors are found. If there are errors, correct them before proceeding to the next step,
+*** [[Reconnect_check_Completes query]] - Generally, errors in missing are the result of a failed send, so follow [[Re-sending data]] to fix
-* the [["Re-connect Data" button]] automatically runs the initial cross checks, but only shows them if errors are found. If there are errors, correct them before proceeding to the next step,
+*** [[Reconnect_check_orphans query ]] - see [[Orphans in Centralized data.mdb]] for what to do about these
-* '''no need to run them manually'''
+*** [[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
-** [[Reconnect_check_Completes query]] - Generally, errors in missing are the result of a failed send, so follow [[Re-sending data]] to fix
-** [[Reconnect_check_orphans query ]] - see [[Orphans in Centralized data.mdb]] for what to do about these
-** [[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
 * If there were no errors, continue what you were doing, likely the next step of [[Centralized data Vetting Process]]:  [[Pre-linking checks]]