Reconnect check missing L Tables content query: Difference between revisions

m 2021 -11- 04: linked to ongoing error page on wiki.
m Text replacement - "|DIC_LProblem=no" to "|DIC_LProblem=No"
 
(One intermediate revision by the same user not shown)
Line 11: Line 11:
|DIC_implementation_date=2016-01-21
|DIC_implementation_date=2016-01-21
|DIC_status=implemented
|DIC_status=implemented
|DIC_LProblem=no
|DIC_LProblem=No
|DIC_app=Centralized data front end.accdb
|DIC_app=Centralized data front end.accdb
|DIC_backlogged=No
|DIC_backlogged=No
Line 29: Line 29:
== Log ==
== Log ==
=== 2021 -11-04 ===
=== 2021 -11-04 ===
''There may be some problems, or missing items, in this log entry. Sending with a previously sent file still on the laptop would not usually cause this problem, so something else was going on in addition. Discovered the inconsistency in the write-up only 4 months after the issue, so impossible to track down now what went wrong, so just leaving this note instead of trying to correct. ''
* Problem found that  no ICD10 code in [[Reconnect_check_missing_L Tables_content query]] from S5 laptop, problem fixed. [[User:PTorres|PTorres]] 16:55, 2021 November 24 (CST)
* Problem found that  no ICD10 code in [[Reconnect_check_missing_L Tables_content query]] from S5 laptop, problem fixed. [[User:PTorres|PTorres]] 16:55, 2021 November 24 (CST)
* Started when Pam cannot send  with [[Error "Invalid SQL statment..." when sending]]
* Started when Pam cannot send  with [[Error "Invalid SQL statment..." when sending]]
* Then found out that their are Record Status "Complete" after I clicked the Reconnect button it saying Complete Record Status.
* Then found out that there are records with [[RecordStatus]] "Complete" after I clicked the Reconnect button it saying Complete Record Status.
* We trouble shoot S5 laptop, found out that she still have some Record Status "Sent " but sent with older date but not deleted yet on her the laptop.
* We trouble shoot S5 laptop, found out that she still have some Record Status "Sent" but sent with older send date in CFE but not deleted yet on the laptop.
* Because of those old Sent but not deleted on the laptop, CFE  Record Status Vetted became Sent again even though it was Vetted before.  
* Because of those old Sent but not deleted on the laptop, CFE  Record Status Vetted became Sent again even though it was Vetted before.  
* Before if we have Record Status Complete means sending did not go through completely the sending, and need to be re send, but with this problem not true data sent completely the problem is in the Record Status in CFE already Vetted it became Sent again because their was Sent in the laptop which is not deleted.[[User:PTorres|PTorres]] 16:16, 2021 November 29 (CST)
* Before if we have Record Status Complete means sending did not go through completely the sending, and need to be re send, but with this problem not true data sent completely the problem is in the Record Status in CFE already Vetted it became Sent again because their was Sent in the laptop which is not deleted.[[User:PTorres|PTorres]] 16:16, 2021 November 29 (CST)