System resource exceeded: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
No edit summary
Line 1: Line 1:
{{Bug}}
{{Bug}}


The STB_MedB laptop gets the following error when sending:  
The STB_MedB laptop gets the following error message when sending:  


:: Mirosoft Access - System resource exceeded
:: '''Microsoft Access - System resource exceeded'''


Internally this is also noted in the dbengine object as error number 3035.
Internally this is also noted in the dbengine object as error number 3035.
Line 9: Line 9:
The error occurs specifically when the send program runs [[Query send check centralized is owner]].  
The error occurs specifically when the send program runs [[Query send check centralized is owner]].  


{{Discussion}}
*main office needs documentation here in order to get better idea which laptop, how often and perhaps this would help us ID a pattern.[[User:TOstryzniuk|Trish Ostryzniuk]] 16:48, 2019 October 1 (CDT)
== Current status of this problem ==
== Current status of this problem ==
Please state if your laptop currently has this problem e.g.  
Please state if your laptop currently has this problem e.g.  

Revision as of 16:48, 2019 October 1


The STB_MedB laptop gets the following error message when sending:

Microsoft Access - System resource exceeded

Internally this is also noted in the dbengine object as error number 3035.

The error occurs specifically when the send program runs Query send check centralized is owner.

Template:Discussion

  • main office needs documentation here in order to get better idea which laptop, how often and perhaps this would help us ID a pattern.Trish Ostryzniuk 16:48, 2019 October 1 (CDT)

Current status of this problem

Please state if your laptop currently has this problem e.g.

  • HSC_A1 - has system resource problem-- Ttenbergen 11:00, 2019 September 19 (CDT)
  • HSC_B2 - doesn't have system resource problem-- Ttenbergen 11:00, 2019 September 19 (CDT)

List of locations:

GRA

  • GRA_ICU - worked when I was there Sept 30 for testing-- Ttenbergen 15:25, 2019 October 1 (CDT)
  • GRA_N3 - happened Sept 30- Tina fixed by splitting the sending-- Lisa Kaita 13:25, 2019 September 30 (CDT)
  • GRA_N5 - sent ok today --Malcudia 15:43, 2019 September 26 (CDT)

HSC

  • HSC_A4 - not yet reported
  • HSC_B3 - not yet reported
  • HSC_D4 - It worked!
  • HSC_H4 - Sent with no problems
  • HSC_ICUa - not yet reported
  • HSC_ICUb - not yet reported
  • HSC_ICUd - it worked. Sending was fine

STB

  • STB_MISI - not yet reported
  • STB_CCU - not yet reported
  • STB_CICU - not yet reported
  • STB_MedA - doesn't have system resource problem --Pamela Piche 12:06, 2019 September 19 (CDT)
  • STB_MedB - encountered error with send 9/24/19-- Pamela Piche 15:57, 2019 September 24 (CDT)
  • STB_MedD - no system resource exceeded window. Sending complete. Seemed a little slow, but o/w seems o.k.--DPageNewton 11:43, 2019 September 19 (CDT)

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

Will need to find out more details from Herman.

  • SMW


  • Cargo


  • Categories

Observation - Timing of this becoming a problem again

Pagasa observed that this became a problem again around the same time we changed the schedule of PHI Loader.accdb. We discussed possible connections but could not think of anything causal. Just putting this down here in case someone else can think of the connection. Ttenbergen 15:34, 2019 September 12 (CDT)

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.

  • 13:29, 2019 September 4 (CDT) - optimized the query further, seemed to eliminate error for now, but error has recurred since

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

Tried, doesn't solve the problem

MaxBuffer

Computer\HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Jet\4.0\Engines\Jet 2.x Computer\HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Jet\4.0\Engines\Jet 3.x Computer\HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Jet\4.0\Engines\Jet 4.0

Computer\HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\14.0\Access Connectivity Engine\Engines\ACE Computer\HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\14.0\Access Connectivity Engine\Engines\Jet 3.x

MaxLocksPerFile

Computer\HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\14.0\Access Connectivity Engine\Engines\ACE - conf 1000000 Computer\HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\14.0\Access Connectivity Engine\Engines\Jet 3.x

Solution approach: Microsoft Hotfixes

Noticed that we may not be getting Office updates installed (newest not present)

Status

As of 09:48, 2019 September 4 (CDT) this is still a problem, and recently more of a problem.

Next things I will try:

  • try to send from local to local - the query works fine when I run it while connected to a local version of CFE
  • updating ccmdb.mdb to .accdb; if that is the solution we will also need to update many scripts and VBS/VBA programs.

Related articles

Related articles:

Considerations