PHI Loader.accdb: Difference between revisions

Line 4:

see [[Lccmdb and ldb files]]

== Missing or ~~corrupted~~ Phi Loader ==

== Missing, corrupted or stuck Phi Loader ==

We have had some problems with phi_loader over time.

Line 20:

=== Problem log ===

* 2019-01-30 Task error message: Run time error 58.

**Finding: 2 copies of CSV file, one OUTSIDE of the PHI_CSV_Archive, and there copy is INSIDE the PHI_CSV_Archive.

***Solution: relabeled the copy INSIDE the PHI_CSV_Archive and put extension _Twin on the end. Ran the phi loader task scheduler. Problem solved

* 2019-01-15 "

* 2019-01-10 "

* 2018-12-20 "

* 2018-11-16 Task error message: Run time error 3078, "Microsoft Access can't find the input table or query tmp.

* 2018-11-15 ~~Task error message: Run time error 3078,~~ "~~Microsoft Access can't find the input table or query tmp.~~

**Solution: Replaced PHI loader with backup copy

* 2018-10-31 ~~Task error message: Run time error 3078,~~ "~~Microsoft Access can't find the input table or query tmp.~~

* 2018-11-15 "

* 2018-10-23 ~~Task error message: Run time error 3078,~~ "~~Microsoft Access can't find the input table or query tmp.~~

* 2018-10-31 "

**Solution: Replaced PHI loader with backup copy.

* 2018-10-23 "

* 2018-08-23 Task error message: Run time error 7874, "Microsoft Access can't find the object "AppendNewRecords"

** observation: this occurred at peak time an lots of staff sending.

Line 31:

Line 37:

* 2018-05-28 Task error message Run time error 3874. vbs debug highlighted the following error; DoCmd.OpenQuery "DeleteALLTempData"......

** E6 last csv sent when error message came up. E6 sent an email to fix a serial#

* 2018-04-20 - Task error message: Directory name, or volume label syntax is incorrect. Microsoft VB error message: Run-Time error 3078: The MS Access database engine cannot find the input table or query L_PHI. Make sure it exists and that its name is spelled correctly.

* 2018-04-20 Task error message: Directory name, or volume label syntax is incorrect. Microsoft VB error message: Run-Time error 3078: The MS Access database engine cannot find the input table or query L_PHI. Make sure it exists and that its name is spelled correctly.

* 2018-03-09 - there was an error "Microsoft Access can't find the object "AppendNewRecords"

* 2018-03-09 there was an error "Microsoft Access can't find the object "AppendNewRecords"

* 2018-02-28 ~~- there was an error "Microsoft Access can't find the object "AppendNewRecords~~"

* 2018-02-28 "

* the whole file was missing at some point

== change log ==

@@ Line 4: / Line 4: @@
 see [[Lccmdb and ldb files]]
-== Missing or corrupted Phi Loader ==
+== Missing, corrupted or stuck Phi Loader ==
 We have had some problems with phi_loader over time.
@@ Line 20: / Line 20: @@
 === Problem log ===
+* 2019-01-30  Task error message: Run time error 58.
+**Finding: 2 copies of CSV file, one OUTSIDE of the PHI_CSV_Archive, and there copy is INSIDE the PHI_CSV_Archive.
+***Solution: relabeled the copy INSIDE the PHI_CSV_Archive and put extension _Twin on the end.  Ran the phi loader task scheduler.  Problem solved
+* 2019-01-15 "
+* 2019-01-10 "
+* 2018-12-20 "
 * 2018-11-16 Task error message: Run time error 3078, "Microsoft Access can't find the input table or query tmp.
-* 2018-11-15 Task error message: Run time error 3078, "Microsoft Access can't find the input table or query tmp.
+**Solution: Replaced PHI loader with backup copy
-* 2018-10-31 Task error message: Run time error 3078, "Microsoft Access can't find the input table or query tmp.
+* 2018-11-15 "
-* 2018-10-23 Task error message: Run time error 3078, "Microsoft Access can't find the input table or query tmp.
+* 2018-10-31 "
-**Solution: Replaced PHI loader with backup copy.
+* 2018-10-23 "
 * 2018-08-23 Task error message: Run time error 7874, "Microsoft Access can't find the object "AppendNewRecords"
 ** observation: this occurred at peak time an lots of staff sending.
@@ Line 31: / Line 37: @@
 * 2018-05-28 Task error message Run time error 3874. vbs debug highlighted the following error; DoCmd.OpenQuery "DeleteALLTempData"......
 ** E6 last csv sent when error message came up.  E6 sent an email to fix a serial#
-* 2018-04-20 - Task error message: Directory name, or volume label syntax is incorrect. Microsoft VB error message: Run-Time error 3078: The MS Access database engine cannot find the input table or query L_PHI.  Make sure it exists and that its name is spelled correctly.
+* 2018-04-20 Task error message: Directory name, or volume label syntax is incorrect. Microsoft VB error message: Run-Time error 3078: The MS Access database engine cannot find the input table or query L_PHI.  Make sure it exists and that its name is spelled correctly.
-* 2018-03-09 - there was an error "Microsoft Access can't find the object "AppendNewRecords"
+* 2018-03-09 there was an error "Microsoft Access can't find the object "AppendNewRecords"
-* 2018-02-28 - there was an error "Microsoft Access can't find the object "AppendNewRecords"
+* 2018-02-28 "
 * the whole file was missing at some point
 == change log ==