Reconnect CFE and initial error checks: Difference between revisions

Revision as of 09:46, 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 need to be resolved by Re-sending data because usually caused by a failed send.

	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 3: / Line 3: @@
 == Instructions ==
 * Click the "Re-connect Data" button
-* Screen prompt 'do you have recent TISS', answer '''YES'''
+* Screen prompt 'Could not find file ... DSM...', answer '''YES'''
-{{DT | remove msgbox, this is now copied by script so should be right. }}
+{{DT | Fix why it gives this error as part of fixing DSM process.  }}
-* The program will now resetthe connections from [[CFE]] to [[Centralized data.mdb]], [[PHI.mdb]] and [[TISS28 Data.mdb]]
+* 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]]
-{{Discuss | who = Pagasa | question =  need to say what we do... }}
+*** 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.
 {{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]]