PHI Loader.accdb: Difference between revisions
Ttenbergen (talk | contribs) m Text replacement - "X:\" to "{{S:\MED\CCMED}}" |
|||
| (33 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
{{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 == | == Troubleshooting tree == | ||
The command window "black blob" on the [[Data Processor]] | The command window "black blob" on the [[Data Processor PC]] stays open and there is an error msg. | ||
If the | 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. | * 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 | === Run time error 3078 === | ||
If the msg: '''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 | ||
| Line 17: | Line 30: | ||
* 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 | === 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. | * 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. | ||
| Line 31: | Line 45: | ||
=== Restoring PHI_Loader from backup === | === Restoring PHI_Loader from backup === | ||
* Close error message, and Click '''End''' | * Close error message, and Click '''End''' | ||
* Navigate to | * Navigate to {{S:\MED\CCMED}}CCMDB\PHI\PHI Loader.accdb_'''Backup''' | ||
* Before you restore the 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 | **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 40: | Line 54: | ||
== Problem log == | == Problem log == | ||
==== Task error message: Run time error | ====Task error: no error message, but phi loader task window stuck open==== | ||
*2019-03-15 OAK MICU -collector error message | *''''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 ==== | ==== 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 ICUA | ||
* 2019-03-12 HSC D4 | * 2019-03-12 HSC D4 | ||
| Line 50: | Line 80: | ||
* 2019-02-26 | * 2019-02-26 | ||
* 2019-02-14 | * 2019-02-14 | ||
* 2019-01-30 | * 2019-01-30 | ||
==== 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 Microsoft Access can't find the input table or query tmp ==== | ||
* 2019-04-02 - STB ACCU reported sending problem "[[System resource exceeded]]" Debug show hang up at DeleteAllTempdata | |||
* 2019-02-20 | * 2019-02-20 | ||
* 2019-01-15 | * 2019-01-15 | ||
| Line 76: | Line 107: | ||
== change log == | == change log == | ||
* 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}} | |||