PHI Loader.accdb
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
- Finding: 2 copies of CSV file, one OUTSIDE of the PHI_CSV_Archive, and the other copy is INSIDE the PHI_CSV_Archive.
- 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.
- observation: this occurred at peak time an lots of staff sending.
- and log occurrence under #Task error message: Run time error 7874 "Microsoft Access can't find the object "AppendNewRecords"
Missing, corrupted or stuck Phi Loader
We have had some problems with phi_loader over time.
When this sort of thing happens, restore a clean version of PHI_Loader.
Restoring PHI_Loader from backup
- Close error message, and Click End
- Navigate to X:\CCMDB\PHI\PHI Loader.accdb_Backup
- Before you restore the backup
- Try to log in to the PHI_Loader using the pw (located on a list in M shared drive). If this does not work then
- Go to Task Manger to check if there is any access program running in Application and Process Tab. If they are running select application or process and press: End. If this does not work then:
- reboot computer - this will disconnect any access programs that are still running in back round that you cannot see.
- make a copy of PHI Loader.accdb_Backup in the same folder
- removed the words COPY and Backup so the file name is as shown: PHI Loader.accdb
Problem log
Task error message: Run time error 58-File already exists
- 2019-03-12 HSC ICUA
- 2019-03-12 HSC D4
- 2019-03-12 HSC A4
- 2019-03-07
- 2019-02-26
- 2019-02-14
- 2019-01-30
Task error message: Run time error 3078 Microsoft Access can't find the input table or query tmp
- 2019-02-20
- 2019-01-15
- 2019-01-10
- 2018-12-20
- 2018-11-16
Task error message: Run time error 7874 "Microsoft Access can't find the object "AppendNewRecords"
- 2018-11-15
- 2018-10-31
- 2018-10-23
- 2018-08-23
Old miscellaneous errors
- 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"......
- 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-03-09 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
19:49, 2014 July 31 (CDT)
- added check for PHI.mdb to be present. Ttenbergen 19:49, 2014 July 31 (CDT)