Reconnect CFE and initial error checks: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) m Text replacement - "[["Pull" Centralized_data.accdb]]" to ""Pull" Centralized_data.accdb" |
||
| (4 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
Once you [["Pull" | Once you [["Pull" Centralized_data.accdb]] you need to initialise the program and make sure that you have consistent initial data. | ||
== Instructions == | == Instructions == | ||
| Line 6: | Line 6: | ||
** '''no need to run them manually''' | ** '''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 | ** 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, | ||
*** [[Reconnect_check_Completes 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 | *** [[Reconnect_check_orphans query ]] - see [[Orphans in Centralized_data.accdb]]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_missing_L Tables_content query]] - Generally, errors in missing are the result of a failed send, so follow [[Re-sending data]] to fix | ||
Latest revision as of 15:42, 23 July 2025
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
- 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.accdbfor 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: |