Reconnect CFE and initial error checks: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) m (→Instructions) |
||
| Line 3: | Line 3: | ||
== Instructions == | == Instructions == | ||
* click the [["Re-connect Data" button]] | * 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 | ** 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 | |||
* | *** [[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 | ||
** [[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]] | * If there were no errors, continue what you were doing, likely the next step of [[Centralized data Vetting Process]]: [[Pre-linking checks]] | ||
Latest revision as of 16:15, 2022 April 5
Once you "Pull" Centralized data.mdb you need to initialise the program and make sure that you have consistent initial data.
Instructions
- click the "Re-connect Data" button
- 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
- 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
Related articles
| Related articles: |