PHI Loader.accdb: Difference between revisions
No edit summary |
|||
| Line 1: | Line 1: | ||
X:\CCMDB\PHI\PHI Loader.accdb is an Access program that processes data in [[PHI.mdb]] as part of [[PHI copy automation]]. | X:\CCMDB\PHI\PHI Loader.accdb is an Access program that processes data in [[PHI.mdb]] as part of [[PHI copy automation]]. | ||
== | == Troubleshooting tree == | ||
The command window "black blob" stays open | |||
* usually there will be an error message with this. | |||
If the msg is '''Run time error 58-File already exists''' then | |||
* | |||
**Finding: 2 copies of CSV file, one OUTSIDE of the PHI_CSV_Archive, and the other 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 | |||
* and log occurrence under [[#Task error message: Run time error 58-File already exists]] | |||
If the msg is '''Run time error 3078 Microsoft Access can't find the input table or query tmp''' then | |||
**Solution: Replaced PHI loader with backup copy | |||
**unable to unlock | |||
**Solution: Rebooted computer and lock removed and then replaced PHI loader with copy from backup | |||
* and log occurrence under [[#Task error message: Run time error 3078]] | |||
If the msg is '''Run time error 7874, "Microsoft Access can't find the object "AppendNewRecords"''' then | |||
** observation: this occurred at peak time an lots of staff sending. | |||
***Solution: Replaced PHI loader with backup copy. | |||
* and log occurrence under [[#Task error message: Run time error 7874 "Microsoft Access can't find the object "AppendNewRecords"]] | |||
see [[Lccmdb and ldb files]] | see [[Lccmdb and ldb files]] | ||
| Line 28: | Line 48: | ||
* 2019-02-14 | * 2019-02-14 | ||
* 2019-01-30 | * 2019-01-30 | ||
==== Task error message: Run time error 3078==== | ==== Task error message: Run time error 3078 Microsoft Access can't find the input table or query tmp ==== | ||
* 2019-02-20 | * 2019-02-20 | ||
* 2019-01-15 | * 2019-01-15 | ||
* 2019-01-10 | * 2019-01-10 | ||
* 2018-12-20 | * 2018-12-20 | ||
* 2018-11-16 | * 2018-11-16 | ||
==== Task error message: Run time error 7874 ==== | ==== Task error message: Run time error 7874 "Microsoft Access can't find the object "AppendNewRecords" ==== | ||
* 2018-11-15 | * 2018-11-15 | ||
* 2018-10-31 | * 2018-10-31 | ||
* 2018-10-23 | * 2018-10-23 | ||
* 2018-08-23 | * 2018-08-23 | ||
==== Old miscellaneous errors ==== | |||
* 2018-06-19 Problem on Pull script found out the PHI loader is gone. | * 2018-06-19 Problem on Pull script found out the PHI loader is gone. | ||
* 2018-05-28 Task error message Run time error 3874. vbs debug highlighted the following error; DoCmd.OpenQuery "DeleteALLTempData"...... | * 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# | ** 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 " | * 2018-02-28 " | ||
| Line 60: | Line 75: | ||
=== 19:49, 2014 July 31 (CDT) === | === 19:49, 2014 July 31 (CDT) === | ||
*added check for PHI.mdb to be present. Ttenbergen 19:49, 2014 July 31 (CDT) | *added check for PHI.mdb to be present. Ttenbergen 19:49, 2014 July 31 (CDT) | ||
[[Category: Development Documentation]] | [[Category: Development Documentation]] | ||
[[Category: PHI]] | [[Category: PHI]] | ||
[[Category: IT Instructions]] | |||