PHI Loader.accdb: Difference between revisions

Line 6:

If task window is stuck open and there is '''no error message''':

*'''Solution''': close Task window. Next time it runs, files will get moved without an issue.

=== Run time Error 3051 ===

If ~~the~~ msg. '''~~Run time error 3051~~ The Microsoft access database engine cannot open or write to the file

If error msg: '''The Microsoft access database engine cannot open or write to the file.

It is already opened exclusively by another user,or you need permission to view and write its data'''

*sender had error message: system resource exceeded

Line 14:

* Don't know what to solution is yet as Tina hot sure why to problem is occurring.>}}

~~If the msg is '''~~Run time error 58-File already exists''' then:

=== Run time error 58 ===

If error msg:-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.

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

=== Run time error 3078 ===

If the msg: '''Microsoft Access can't find the input table or query tmp''' then:

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

Line 25:

Line 27:

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

=== Run time error 7874 ===

If the msg: '''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.

@@ Line 6: / Line 6: @@
 If task window is stuck open and there is '''no error message''':
 *'''Solution''':  close Task window. Next time it runs, files will get moved without an issue.
+=== Run time Error 3051 ===
-If the msg. '''Run time error 3051 The Microsoft access database engine cannot open or write to the file
+If error msg:   '''The Microsoft access database engine cannot open or write to the file.
 It is already opened exclusively by another user,or you need permission to view and write its data'''
 *sender had error message: system resource exceeded
@@ Line 14: / Line 14: @@
 * Don't know what to solution is yet as Tina hot sure why to problem is occurring.>}}
-If the msg is '''Run time error 58-File already exists''' then:
+=== Run time error 58 ===
+If error msg:-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.
 ** '''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:
+=== Run time error 3078 ===
+If the msg:  '''Microsoft Access can't find the input table or query tmp''' then:
 *'''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
@@ Line 25: / Line 27: @@
 * 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:
+=== Run time error 7874 ===
+If the msg: '''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.