PHI Loader.accdb: Difference between revisions
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
|||
| (11 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 9: | Line 9: | ||
If error msg: '''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''' | 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''' | ||
| Line 26: | Line 26: | ||
If the msg: '''Microsoft Access can't find the input table or query tmp''' then: | 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]] | ||
| Line 45: | 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 67: | 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 81: | 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 105: | 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 113: | Line 116: | ||
[[Category: Development Documentation]] | [[Category:Development Documentation]] | ||
[[Category: PHI]] | [[Category:PHI]] | ||
[[Category: IT Instructions]] | [[Category:IT Instructions]] | ||