Reconnect CFE and initial error checks: Difference between revisions

Revision as of 09:59, 7 February 2019

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

	Fix why it gives this error as part of fixing DSM process.

The program will now reset the connections from CFE to Centralized data.mdb, PHI.mdb and TISS28 Data.mdb
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
Run initial cross checks:
- PL_1orphans- see Orphans in Centralized data.mdb for what to do about these.
- PL missing L Tables content
  - for now there are some CCIs on this list. Tina will fix Query check CCI must have entry so those are caught going forward.
  - Generally, errors in missing are the result of a failed send, so follow Cleaning up a failed send to fix.

	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

@@ Line 11: / Line 11: @@
 ** [[PL missing L Tables content]]
 *** for now there are some CCIs on this list. Tina will fix [[Query check CCI must have entry]] so those are caught going forward.
-*** Generally, errors in missing need to be resolved by [[Re-sending data]] because usually caused by a failed send.
+*** 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]]