PHI Loader.accdb: Difference between revisions

Line 47:

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

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

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

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

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

@@ Line 47: / Line 47: @@
 ==== 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-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.
+*'''2019-03-18'''
-*2019-03-15 OAK MICU - collector sending error message '''system resource exceeded''' (Lisa spoke to Tina)
+**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.
+*'''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 ====