System resource exceeded: Difference between revisions

Line 7:

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

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 occurs specifically when the send program runs [[Query send check centralized is owner]].

== Observation - Timing of this becoming a problem again ==

Line 15:

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, ~~seems~~ to eliminate error for now.

* 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 ==

Line 27:

**DbEngine.SetOption dbMaxLocksPerFile, 1000000

Tried, doesn't solve the problem

MaxBuffer

Line 58:

Line 57:

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

* sending again this morning to find out if wifi is still being turned off successfully - Wifi is still being disconnected successfully, and reconnected successfully

* updating ccmdb.mdb to .accdb; if that is the solution we will also need to update many scripts and VBS/VBA programs.

== Related articles ==

@@ Line 7: / Line 7: @@
 Internally this is also noted in the dbengine object as error number 3035.
-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 occurs specifically when the send program runs [[Query send check centralized is owner]].
 == Observation - Timing of this becoming a problem again ==
@@ Line 15: / Line 15: @@
 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, seems to eliminate error for now.
+* 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 ==
@@ Line 27: / Line 27: @@
 **DbEngine.SetOption dbMaxLocksPerFile, 1000000
 Tried, doesn't solve the problem
 MaxBuffer
@@ Line 58: / Line 57: @@
 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
-* sending again this morning to find out if wifi is still being turned off successfully - Wifi is still being disconnected successfully, and reconnected successfully
 * 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}}