System resource exceeded: Difference between revisions

TOstryzniuk (talk | contribs)
System resource exceeded - work around for STB_Med B & D laptops
TOstryzniuk (talk | contribs)
Line 60: Line 60:
*STB_MedD - started Sept 2019
*STB_MedD - started Sept 2019
*STB_MEDB - started Nov 5.19
*STB_MEDB - started Nov 5.19
*HSC_A4-started Nov 7.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.  
**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.  


Line 72: Line 73:
**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
**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
**Data Collector: 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.  
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.


== Observation - A new build of Windows10 was deployed at around the same time this became more common again ==
== Observation - A new build of Windows10 was deployed at around the same time this became more common again ==