System resource exceeded: Difference between revisions

Line 57:

== Interim work-around to have Pagasa send for a collector who gets this error ==

Pagasa and I had a look at Debbie’s data, and it seems to be a matter of there really being too many records. MS Access is reaching its limit. For testing I tried to send with the first half of your patients and with the second half, and each works. Of course that is not a solution, but it confirms that the volume is the issue. In the long term we need to find an alternative to MS access, and to bring down the backlog, but that won’t be quick.

currently being done by:

*STB_MedD - started Sept 2019

*STB_MEDB - started Nov 5.19

**Pagasa and I had a look at STB_MEDD (Debbie’s) data, and it seems to be a matter of there really being too many records. MS Access is reaching its limit. For testing I tried to send with the first half of your patients and with the second half, and each works. Of course that is not a solution, but it confirms that the volume is the issue. In the long term we need to find an alternative to MS access, and to bring down the backlog, but that won’t be quick.

In the meantime, and at least until Trish and Julie are back and have cleared their vacation backlog and have a chance to discuss, the following will have to be our work around:

In the meantime, and at least until Trish and Julie are back and have cleared their vacation backlog and have a chance to discuss, the following will have to be our '''work around''':

*~~Debbie~~, stop trying to send, this error will keep coming up.

*If you have this error, stop trying to send, this error will keep coming up.

*Once a week, coordinate with Pagasa for her to send your completed files. You will need to work very closely together on this so we don’t lose records. Here is how it will work:

*Once a week, Data Collector must coordinate with [[p:Pagasa Torres | Pagasa]] for her to send your completed files. You will need to work very closely together on this so we don’t lose records. Here is how it will work:

**~~Debbie,~~ finish going through all data entry for that day that would benefit from Patient Copier since you will need to delete records as part of this

**Data Collector: must finish going through all data entry for that day that would benefit from Patient Copier since you will need to delete records as part of this

**Pagasa and ~~Debbie,~~ establish a phone call between the two of you

**Pagasa and Data Collector: establish a phone call between the two of you

**~~Debbie,~~ close out of Access and do a news and backup and leave Access closed

**Data Collector: close out of Access and do a news and backup and leave Access closed

**Pagasa, download the newest backup file, delete the incompletes, and send the completes (3-5min)

**Pagasa: download the newest backup file, delete the incompletes, and send the completes (3-5min)

**If all goes well, Pagasa will tell ~~Debbie~~ to open Access and delete the completes

**If all goes well, Pagasa will tell Data Collector to open Access and delete the completes

**~~Debbie,~~ you would need to delete the completes because otherwise it will be impossible otherwise to distinguish between the completes that Pagasa sent, and the completes she has not yet sent

**Data Collector: you would need to delete the completes because otherwise it will be impossible otherwise to distinguish between the completes that Pagasa sent, and the completes she has not yet sent

**~~Debbie,~~ do one more News and Backup to move that to the newest status

**Data Collector: do one more News and Backup to move that to the newest status

This should allow files to keep being offloaded from Debbie’s laptop slowly, but it causes extra work for Debbie and Pagasa, so this is not a long term solution. We will need to discuss a longer term solution when Trish and Julie are back.

@@ Line 57: / Line 57: @@
 == Interim work-around to have Pagasa send for a collector who gets this error ==
-Pagasa and I had a look at Debbie’s data, and it seems to be a matter of there really being too many records. MS Access is reaching its limit. For testing I tried to send with the first half of your patients and with the second half, and each works. Of course that is not a solution, but it confirms that the volume is the issue. In the long term we need to find an alternative to MS access, and to bring down the backlog, but that won’t be quick.
+currently being done by:
+*STB_MedD - started Sept 2019
+*STB_MEDB - started Nov 5.19
+**Pagasa and I had a look at STB_MEDD (Debbie’s) data, and it seems to be a matter of there really being too many records. MS Access is reaching its limit. For testing I tried to send with the first half of your patients and with the second half, and each works. Of course that is not a solution, but it confirms that the volume is the issue. In the long term we need to find an alternative to MS access, and to bring down the backlog, but that won’t be quick.
-In the meantime, and at least until Trish and Julie are back and have cleared their vacation backlog and have a chance to discuss, the following will have to be our work around:
+In the meantime, and at least until Trish and Julie are back and have cleared their vacation backlog and have a chance to discuss, the following will have to be our '''work around''':
-*Debbie, stop trying to send, this error will keep coming up.
+*If you have this error, stop trying to send, this error will keep coming up.
-*Once a week, coordinate with Pagasa for her to send your completed files. You will need to work very closely together on this so we don’t lose records. Here is how it will work:
+*Once a week, Data Collector must coordinate with [[p:Pagasa Torres | Pagasa]] for her to send your completed files. You will need to work very closely together on this so we don’t lose records. Here is how it will work:
-**Debbie, finish going through all data entry for that day that would benefit from Patient Copier since you will need to delete records as part of this
+**Data Collector:  must finish going through all data entry for that day that would benefit from Patient Copier since you will need to delete records as part of this
-**Pagasa and Debbie, establish a phone call between the two of you
+**Pagasa and Data Collector: establish a phone call between the two of you
-**Debbie, close out of Access and do a news and backup and leave Access closed
+**Data Collector: close out of Access and do a news and backup and leave Access closed
-**Pagasa, download the newest backup file, delete the incompletes, and send the completes (3-5min)
+**Pagasa:  download the newest backup file, delete the incompletes, and send the completes (3-5min)
-**If all goes well, Pagasa will tell Debbie to open Access and delete the completes
+**If all goes well, Pagasa will tell Data Collector to open Access and delete the completes
-**Debbie, you would need to delete the completes because otherwise it will be impossible otherwise to distinguish between the completes that Pagasa sent, and the completes she has not yet sent
+**Data Collector: you would need to delete the completes because otherwise it will be impossible otherwise to distinguish between the completes that Pagasa sent, and the completes she has not yet sent
-**Debbie, do one more News and Backup to move that to the newest status
+**Data Collector: do one more News and Backup to move that to the newest status
 This should allow files to keep being offloaded from Debbie’s laptop slowly, but it causes extra work for Debbie and Pagasa, so this is not a long term solution. We will need to discuss a longer term solution when Trish and Julie are back.