PHI Loader.accdb: Difference between revisions

Line 2:

== Troubleshooting tree ==

The command window "black blob" stays open

The command window "black blob" stays open and there is an error msg.

* usually there ~~will be~~ an error ~~message with this~~.

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.

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

* 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~~

*Solution:

**~~unable to unlock~~

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

**Solution: ~~Rebooted computer and lock removed and then replaced~~ PHI loader with copy ~~from backup~~

** 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]]

@@ Line 2: / Line 2: @@
 == Troubleshooting tree ==
-The command window "black blob" stays open
+The command window "black blob" stays open and there is an error msg.
-* usually there will be an error message with this.
 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.
-**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
 * 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
+*Solution:
-**unable to unlock
+** 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
-**Solution:  Rebooted computer and lock removed and then replaced PHI loader with copy from backup
+** 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]]