PHI Loader.accdb: Difference between revisions
TOstryzniuk (talk | contribs) m →Task error message: Run time error 58-File already exists: PHI Loader error - April 19.19 _STB MedD |
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
||
| (16 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
{{S:\MED\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 == | ||
| Line 6: | Line 6: | ||
If task window is stuck open and there is '''no error message''': | 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. | *'''Solution''': close Task window. Next time it runs, files will get moved without an issue. | ||
=== Run time Error 3051 === | |||
If | 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''' | It is already opened exclusively by another user,or you need permission to view and write its data''' | ||
*sender had error message: | *sender had error message: [[System resource exceeded]] | ||
**VB script error: ''DoCmd.TransferText acImportDelim, , "tmp", directory & "\" & strFile, True'' | **VB script error: ''DoCmd.TransferText acImportDelim, , "tmp", directory & "\" & strFile, True'' | ||
***'''Solution''' | ***'''Solution''' | ||
* Don't know what to solution is yet as Tina hot sure why to problem is occurring. | * 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 [[ | ** which table is missing? If it is one you would see in [[Centralized_data.accdb]] 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 | === 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 39: | 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\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 49: | Line 55: | ||
== Problem log == | == Problem log == | ||
====Task error: no error message, but phi loader task window stuck open==== | ====Task error: no error message, but phi loader task window stuck open==== | ||
*''''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. | *''''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. ==== | ==== 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. | '''It is already opened exclusively by another user,or you need permission to view and write its data. | ||
| Line 60: | Line 67: | ||
**Ran debug then closed closed out. Task scheduler ran and moved HSC_ICUd no problem. No one reported sending errors. | **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. | **third time this error occurred today, just ignored it and PHI loader unlocked itself. | ||
* | *Not happening anymore. | ||
*'''2019-03-15''' OAK MICU - collector sending error message ''' | [[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-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 74: | Line 83: | ||
==== 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 " | * 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 98: | Line 107: | ||
== change log == | == change log == | ||
* version 2019-09-18 - changed [[CCMDB.accdb]] to [[CCMDB.accdb]] and centralized_data.mdb to centralized_data.accdb | |||
* 2019 Apr 10 - changed task schedule to only run once a day to see if this will stop sending errors. | * 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) | * 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) | ||
| Line 106: | Line 116: | ||
[[Category: Development Documentation]] | [[Category:Development Documentation]] | ||
[[Category: PHI]] | [[Category:PHI]] | ||
[[Category: IT Instructions]] | [[Category:IT Instructions]] | ||