PHI Loader.accdb: Difference between revisions
TOstryzniuk (talk | contribs) |
TOstryzniuk (talk | contribs) |
||
| Line 4: | Line 4: | ||
The command window "black blob" on the [[Data Processor]]'s computer stays open and there is an error msg. | The command window "black blob" on the [[Data Processor]]'s computer stays open and there is an error msg. | ||
If the msg is '''Run time error 58-File already exists''' then | If the msg is '''Run time error 58-File already exists''' then: | ||
* 2 copies of CSV file, one OUTSIDE of the PHI_CSV_Archive, and the other copy is INSIDE the PHI_CSV_Archive. | * 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 | ||
* and log occurrence under [[#Task error message: Run time error 58-File already exists]] | * 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 | If the msg is '''Run time error 3078 Microsoft Access can't find the input table or query tmp''' then: | ||
*Solution: | *'''Solution''': | ||
** which table is missing? If it is one you would see in [[Centralized data.mdb]] then check if that file is somehow not accessible; same for PHI | ** which table is missing? If it is one you would see in [[Centralized data.mdb]] then check if that file is somehow not accessible; same for PHI | ||
** if another table whose name means nothing to you is missing, then it's probably a table in PHI loader that got corrupted; Solution: Replace PHI loader with backup copy | ** if another table whose name means nothing to you is missing, then it's probably a table in PHI loader that got corrupted; Solution: Replace PHI loader with backup copy | ||
* and log occurrence under [[#Task error message: Run time error 3078]] | * 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 | 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. | * 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. | ||