System resource exceeded: Difference between revisions
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 5: | Line 5: | ||
:: Mirosoft Access - System resource exceeded | :: Mirosoft Access - System resource exceeded | ||
The laptop has a larger than usual number of records on it, but it is possible to send the data from Tina's laptop at HSC. | The laptop has a larger than usual number of records on it, but it is possible to send the data from Tina's laptop at HSC; although it turns out there are intermittent errors there as well. | ||
The error happens when trying to run | == Solution approach: Query size limiting == | ||
The error happens when trying to run [[Query send check centralized is owner]]. That query actually ties into the [[Centralized data.mdb]]'s L_Log. This makes for a very large record set, and have a max size of 1GB rather than the general Access limit of 2GB. | |||
== Solution approach: disconnecting wifi == | |||
Darryl from STB desktop had suggested that turning off wifi might fix this problem. Since they don't actually have wifi in their area this is easy to try. This worked during his tests, but they have had additional problems sending after that. | Darryl from STB desktop had suggested that turning off wifi might fix this problem. Since they don't actually have wifi in their area this is easy to try. This worked during his tests, but they have had additional problems sending after that. | ||
| Line 16: | Line 17: | ||
Darryl from eHealth re-imaged that laptop. | Darryl from eHealth re-imaged that laptop. | ||
== Related articles == | |||
{{Related Articles}} | |||
Revision as of 11:41, 2019 March 13
The STB_MedB laptop gets the following error when sending:
- Mirosoft Access - System resource exceeded
The laptop has a larger than usual number of records on it, but it is possible to send the data from Tina's laptop at HSC; although it turns out there are intermittent errors there as well.
Solution approach: Query size limiting
The error happens when trying to run Query send check centralized is owner. That query actually ties into the Centralized data.mdb's L_Log. This makes for a very large record set, and have a max size of 1GB rather than the general Access limit of 2GB.
Solution approach: disconnecting wifi
Darryl from STB desktop had suggested that turning off wifi might fix this problem. Since they don't actually have wifi in their area this is easy to try. This worked during his tests, but they have had additional problems sending after that.
Status
|
1 Tina worked on the problem some more on her own PC and got the same error, so this likely is a system issue after all. Will need to tweak query to resolve. |
Darryl from eHealth re-imaged that laptop.
Related articles
| Related articles: |