Reconnect CFE and initial error checks: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 5: | Line 5: | ||
* the reconnector will | * 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 | ** 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 [["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 | ** [[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 | |||
* Continue what you were doing, likely the next step of [[Centralized data Vetting Process]]: [[Pre-linking checks]] | * Continue what you were doing, likely the next step of [[Centralized data Vetting Process]]: [[Pre-linking checks]] | ||
Revision as of 20:46, 2022 March 24
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
- 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 "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_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
- Continue what you were doing, likely the next step of Centralized data Vetting Process: Pre-linking checks
Related articles
| Related articles: |