System resource exceeded: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
(As of Wednesday Apr 17 is this still a problem?)
Line 14: Line 14:


During additional tests at HSC Tina found out that sending is faster with wifi disabled, so she added some lines to the sending code that disconnect wifi at the start of sending.
During additional tests at HSC Tina found out that sending is faster with wifi disabled, so she added some lines to the sending code that disconnect wifi at the start of sending.
== Solution approach: Maxlock setting ==
*https://access-programmers.co.uk/forums/showthread.php?t=285553
**search maxlock
We have not tried this yet.


==Status==  
==Status==  
{{DT | Query tweaked and wifi disabled; let's see if this does it. Ttenbergen 13:20, 2019 March 13 (CDT)  }}
{{DT | Query tweaked and wifi disabled; let's see if this does it. Ttenbergen 13:20, 2019 March 13 (CDT)  }}
{{Discuss | As of Wednesday Apr 17 is this still a problem? Ttenbergen }}


Darryl from eHealth re-imaged that laptop.
Darryl from eHealth re-imaged that laptop.

Revision as of 13:33, 2019 April 17


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.

During additional tests at HSC Tina found out that sending is faster with wifi disabled, so she added some lines to the sending code that disconnect wifi at the start of sending.

Solution approach: Maxlock setting

We have not tried this yet.

Status

Query tweaked and wifi disabled; let's see if this does it. Ttenbergen 13:20, 2019 March 13 (CDT)

  • SMW


  • Cargo


  • Categories
As of Wednesday Apr 17 is this still a problem? Ttenbergen 
  • SMW


  • Cargo


  • Categories

Darryl from eHealth re-imaged that laptop.

Related articles

Related articles: