CCMDB Wiki

PHI Loader.accdb: Difference between revisions

← Older editNewer edit →
PTorres (talk | contribs)
CCMDB_legit, approved
1,608 edits
PTorres (talk | contribs)
CCMDB_legit, approved
1,608 edits
Line 20: Line 20:


=== Problem log ===
=== Problem log ===
* 2019-02-14  Task error message: Run time error 58
==== Task error message: Run time error 58 ====
* 2019-01-30  Task error message: Run time error 58.
* 2019-02-14 
* 2019-01-30   
**Finding: 2 copies of CSV file, one OUTSIDE of the PHI_CSV_Archive, and the other copy is INSIDE the PHI_CSV_Archive.   
**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
***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  Task error message: Run time error 3078
==== Task error message: Run time error 3078====
* 2019-01-10  Task error message: Run time error 3078
* 2019-02-20 
* 2018-12-20  Task error message: Run time error 3078
* 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-16 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
**Solution: Replaced PHI loader with backup copy
* 2018-11-15  Task error message: Run time error 7874
==== Task error message: Run time error 7874 ====
* 2018-10-31  Task error message: Run time error 7874
* 2018-11-15 
* 2018-10-23  Task error message: Run time error 7874
* 2018-10-31   
* 2018-10-23   
* 2018-08-23 Task error message: Run time error 7874, "Microsoft Access can't find the object "AppendNewRecords"
* 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.
** observation: this occurred at peak time an lots of staff sending.
***Solution: Replaced PHI loader with backup copy.   
***Solution: Replaced PHI loader with backup copy.  
    
* 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"......
Retrieved from "https://ccmdb.kuality.ca/index.php?title=PHI_Loader.accdb"