PHI Loader.accdb: Difference between revisions

(46 intermediate revisions by 3 users not shown)

Line 1:

X:\CCMDB\PHI\PHI Loader.accdb is an Access program that processes data in [[PHI.mdb]] as part of [[PHI copy automation]].

{{S:\MED\CCMED}}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" on the [[Data Processor PC]] stays open and there is an error msg.

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

**VB script error: ''DoCmd.TransferText acImportDelim, , "tmp", directory & "\" & strFile, True''

***'''Solution'''

* Right now I don't get any email message that there was a sending error.

[[User:PTorres|PTorres]] 14:10, 2019 August 15 (CDT)

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

** What are you doing when this happens, then? And, is this still an issue? It seems it was happening and then it just stopped. }}

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

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

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

=== 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.

* and log occurrence under [[#Task error message: Run time error 7874 "Microsoft Access can't find the object "AppendNewRecords"]]

~~==Locked phi loader.lccmdb==~~

see [[Lccmdb and ldb files]]

Line 11:

Line 45:

=== Restoring PHI_Loader from backup ===

* Close error message, and Click '''End'''

* Navigate to X:\CCMDB\PHI\PHI Loader.accdb_'''Backup'''

* Navigate to {{S:\MED\CCMED}}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

Line 19:

Line 53:

* removed the words '''COPY''' and '''Backup''' so the file name is as shown: PHI Loader.accdb

=== Problem log ===

== Problem log ==

==== Task error message: Run time error 58 ====

====Task error: no error message, but phi loader task window stuck open====

*''''2019-May-21''''

*''''2019-Apr-04'''' - noted that only one of 4 CSV file were moved from output PHI folder on Regional server to X CCMD PHI folder. 3 other sent files remained stuck on Regional Server. No Error message, so not clear why this occurred.

==== Task error message: Run time error 3051 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.

*'''2019-04-08'''-Occurring during sending

*'''2019-03-22'''

*'''2019-03-21'''

*'''2019-03-18'''

**this is odd, there were 7 files backup waiting to be loaded into PHI. Ran debug and closed. Next task ran, moved 6 files in PHI and moved copy to back up. 1 files not moved. HSC_ICUd. Also noted that there was 2 folders created in the CCMDB PHI folder, "new Folder" and New folder 2. The folder date/ time is when task ran second time after debug. Makes no sense to me at the moment.

**Ran debug then closed closed out. Task scheduler ran and moved HSC_ICUd no problem. No one reported sending errors.

**third time this error occurred today, just ignored it and PHI loader unlocked itself.

*Not happening anymore.

[[User:PTorres|PTorres]] 14:18, 2019 August 15 (CDT)

*'''2019-03-15''' OAK MICU - collector sending error message '''[[System resource exceeded]]''' (Lisa spoke to Tina)

==== Task error message: Run time error 58-File already exists ====

* 2019-04-19 STB_MedD -locked when it ran April 19th. The STB MedD file was sent April 18th - file already exists in the PHI_CSV_archive

* 2019-11-08 STB MEDd (Pagasa splitting files and sent from backup for this laptop due to known [[System resource exceeded]] problem.

* 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

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

==== Task error message: Run time error 3078 Microsoft Access can't find the input table or query tmp ====

==== Task error message: Run time error 3078====

* 2019-04-02 - STB ACCU reported sending problem "[[System resource exceeded]]" Debug show hang up at DeleteAllTempdata

* 2019-02-20

**unable to unlock

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

* 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

**Solution: Replaced PHI loader with backup copy

==== Task error message: Run time error 7874 ====

==== 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 ~~Task error message: Run time error 7874, "Microsoft Access can't find the object "AppendNewRecords"~~

* 2018-08-23

** observation: this occurred at peak time an lots of staff sending.

***Solution: Replaced PHI loader with backup copy.

==== 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"......

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

Line 52:

Line 107:

== change log ==

~~=== 19~~:49, ~~2014 July 31~~ (CDT) ~~===~~

* version 2019-09-18 - changed [[CCMDB.accdb]] to [[CCMDB.accdb]] and centralized_data.mdb to centralized_data.accdb

*added check for PHI.mdb to be present. Ttenbergen 19:49, 2014 July 31 (CDT)

* 2019 Apr 10 - changed task schedule to only run once a day to see if this will stop sending errors.

* 2019 Mar 20 - decided to change schedule for this but did not have rights to; sent email to service desk Ttenbergen 16:25, 2019 March 20 (CDT)

* 2014 July 31 - added check for PHI.mdb to be present. Ttenbergen 19:49, 2014 July 31 (CDT)

== Related articles ==

[[Category: Development Documentation]]

[[Category: PHI]]

[[Category: IT Instructions]]

@@ Line 1: / Line 1: @@
-X:\CCMDB\PHI\PHI Loader.accdb is an Access program that processes data in [[PHI.mdb]] as part of [[PHI copy automation]].
+{{S:\MED\CCMED}}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" on the [[Data Processor PC]] stays open and there is an error msg.
+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 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]]
+**VB script error:  ''DoCmd.TransferText acImportDelim, , "tmp", directory & "\" & strFile, True''
+***'''Solution'''
+* Right now I don't get any email message that there was a sending error.
+[[User:PTorres|PTorres]] 14:10, 2019 August 15 (CDT)
+* Don't know what to solution is yet as Tina hot sure why to problem is occurring.
+** What are you doing when this happens, then? And, is this still an issue? It seems it was happening and then it just stopped. }}
+=== 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]]
+=== 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
+** 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]]
+=== 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.
+* and log occurrence under  [[#Task error message: Run time error 7874 "Microsoft Access can't find the object "AppendNewRecords"]]
-==Locked phi loader.lccmdb==
 see [[Lccmdb and ldb files]]
@@ Line 11: / Line 45: @@
 === Restoring PHI_Loader from backup ===
 * Close error message, and Click '''End'''
-* Navigate to X:\CCMDB\PHI\PHI Loader.accdb_'''Backup'''
+* Navigate to {{S:\MED\CCMED}}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
@@ Line 19: / Line 53: @@
 * removed the words  '''COPY''' and '''Backup'''  so the file name is as shown: PHI Loader.accdb
-=== Problem log ===
+== Problem log ==
-==== Task error message: Run time error 58 ====
+====Task error: no error message, but phi loader task window stuck open====
+*''''2019-May-21''''
+*''''2019-Apr-04'''' - noted that only one of 4 CSV file were moved from output PHI folder on Regional server to X CCMD PHI folder. 3 other sent files remained stuck on Regional Server.  No Error message, so not clear why this occurred.
+==== Task error message: Run time error 3051 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.
+*'''2019-04-08'''-Occurring during sending
+*'''2019-03-22'''
+*'''2019-03-21'''
+*'''2019-03-18'''
+**this is odd, there were 7 files backup waiting to be loaded into PHI.  Ran debug and closed.  Next task ran, moved 6 files in PHI and moved copy to back up.  1 files not moved.  HSC_ICUd.  Also noted that there was 2 folders created in the CCMDB PHI folder, "new Folder" and New folder 2.  The folder date/ time is when task ran second time after debug.  Makes no sense to me at the moment.
+**Ran debug then closed closed out.  Task scheduler ran and moved HSC_ICUd no problem. No one reported sending errors.
+**third time this error occurred today, just ignored it and PHI loader unlocked itself.
+*Not happening anymore.
+[[User:PTorres|PTorres]] 14:18, 2019 August 15 (CDT)
+*'''2019-03-15''' OAK MICU - collector sending error message '''[[System resource exceeded]]''' (Lisa spoke to Tina)
+==== Task error message: Run time error 58-File already exists ====
+* 2019-04-19 STB_MedD -locked when it ran April 19th.   The STB MedD file was sent April 18th - file already exists in the PHI_CSV_archive
+* 2019-11-08 STB MEDd  (Pagasa splitting files and sent from backup for this laptop due to known [[System resource exceeded]] problem.
+* 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
-**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
+==== Task error message:  Run time error 3078 Microsoft Access can't find the input table or query tmp ====
-==== Task error message:  Run time error 3078====
+* 2019-04-02 - STB ACCU reported sending problem "[[System resource exceeded]]" Debug show hang up at DeleteAllTempdata
 * 2019-02-20
-**unable to unlock
-**Solution:  Rebooted computer and lock removed and then replaced PHI loader with copy from backup
 * 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
-**Solution: Replaced PHI loader with backup copy
-==== Task error message: Run time error 7874 ====
+==== 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 Task error message: Run time error 7874, "Microsoft Access can't find the object "AppendNewRecords"
+* 2018-08-23
-** observation: this occurred at peak time an lots of staff sending.
-***Solution: Replaced PHI loader with backup copy.
+==== 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"......
+* 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-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 "
@@ Line 52: / Line 107: @@
 == change log ==
-=== 19:49, 2014 July 31 (CDT) ===
+* version 2019-09-18 - changed [[CCMDB.accdb]] to [[CCMDB.accdb]] and centralized_data.mdb to centralized_data.accdb
-*added check for PHI.mdb to be present. Ttenbergen 19:49, 2014 July 31 (CDT)
+* 2019 Apr 10 - changed task schedule to only run once a day to see if this will stop sending errors.
+* 2019 Mar 20 - decided to change schedule for this but did not have rights to; sent email to service desk Ttenbergen 16:25, 2019 March 20 (CDT)
+* 2014 July 31 - added check for PHI.mdb to be present. Ttenbergen 19:49, 2014 July 31 (CDT)
+== Related articles ==
+{{Related Articles}}
 [[Category: Development Documentation]]
 [[Category: PHI]]
+[[Category: IT Instructions]]