Reconnect CFE and initial error checks: Difference between revisions

(16 intermediate revisions by 2 users not shown)

Line 1:

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

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

* click the [["Re-connect Data" button]]

* ~~Screen prompt~~ '~~Could not find file ... DSM...~~'~~, answer~~ ''~~'YES~~'''

* the reconnector will do the following

* ~~Not asking anymore about~~ the ~~DSM~~ only the ~~Tiss.~~[[~~User:PTorres|PTorres~~]] ~~16:29~~, ~~2021 November 24 (CST)~~

** '''no need to run them manually'''

~~{{TT |~~

** 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

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

** 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,

** ~~I think this error is fixed. Emailed Pagasa to confirm.~~ [[~~User:Ttenbergen|Ttenbergen~~]] ~~14:29~~, ~~2021 November 18 (CST) }}~~

*** [[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.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

* ~~The program will now reset the connections from [[CFE]] to [[Centralized data.mdb]], [[PHI.mdb]] and [[TISS28 Data.mdb]]~~

* If there were no errors, continue what you were doing, likely the next step of [[Centralized data Vetting Process]]: [[Pre-linking checks]]

* No more connections on[[TISS28 Data.mdb]] in CFE .[[User:PTorres|PTorres]] 16:33, 2021 November 24 (CST)

* 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.~~

~~{{TT |~~

* Tina will fix [[Query check CCI must have entry]] so those are caught going forward.

** Are these still showing up? Emailed Pagasa...[[User:Ttenbergen|Ttenbergen]] 14:30, 2021 November 18 (CST)

}}

*** Generally, errors ~~in missing are the result of a failed send~~, ~~so follow [[Cleaning up a failed send]] to fix.~~

~~{{TT | 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]]

== Related articles ==

@@ Line 1: / Line 1: @@
-Once you [["Pull" Centralized data.mdb]] you need to initialise the program and make sure that you have consistent initial data.
+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
+* click the [["Re-connect Data" button]]
-* Screen prompt 'Could not find file ... DSM...', answer '''YES'''
+* the reconnector will do the following
-* Not asking anymore about the DSM only the Tiss.[[User:PTorres|PTorres]] 16:29, 2021 November 24 (CST)
+** '''no need to run them manually'''
-{{TT |
+** 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
-* Fix why it gives this error as part of fixing DSM process.
+** 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,
-** I think this error is fixed. Emailed Pagasa to confirm. [[User:Ttenbergen|Ttenbergen]] 14:29, 2021 November 18 (CST)  }}
+*** [[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.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
-* The program will now reset the connections from [[CFE]] to [[Centralized data.mdb]], [[PHI.mdb]] and [[TISS28 Data.mdb]]
+* If there were no errors, continue what you were doing, likely the next step of [[Centralized data Vetting Process]]:  [[Pre-linking checks]]
-* No more  connections on[[TISS28 Data.mdb]] in CFE .[[User:PTorres|PTorres]] 16:33, 2021 November 24 (CST)
-* 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.
-{{TT |
-* Tina will fix [[Query check CCI must have entry]] so those are caught going forward.
-** Are these still showing up? Emailed Pagasa...[[User:Ttenbergen|Ttenbergen]] 14:30, 2021 November 18 (CST)
-}}
-*** Generally, errors in missing are the result of a failed send, so follow [[Cleaning up a failed send]] to fix.
-{{TT | 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]]
 == Related articles ==