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

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)