Database Handicapping Software- JCapper

JCapper Message Board

          JCapper 101
                      -- SQL Timeout

Home Register
Log In
By SQL Timeout
endearus
3/26/2019
11:58:36 AM
In the data window when I run some SQL expressions, results come back in a blink of an eye. But all too often they run and run and run and after about 9 minutes, I get the error expression, 'System Resource Exceeded.' The expressions that hang up this way look simple. Data Window on the top says (not responding) and in Windows Taskmaster the same and using 0% CPU. Running Windows 10.

Thanks for any help.

Reply
jeff
3/27/2019
10:54:41 AM
JCapper was written in Visual Basic 6.0 (meaning that the JCapper Data Window is a 32 bit app.)

Windows 10 on most of the newer machines is geared towards running 64 bit apps.

When queries are executed in the Data Window, the Data Window is relying on the connection created by the database driver (JET) between the Data Window itself and the tables in the J2 .mdb file. (Fyi, the JET db driver is also a 32 bit app.)

What you are describing (good sometimes and error-ing out after several minutes at other times depending on how many other open program windows are running and how much total free ram there is) can be caused by Windows 10 treating the Data Window and/or the JET db driver as 64 bit apps (instead of 32 bit apps.)

There is a workaround called "setting affinity" where you can force Windows to run an app on a single core processor only (as opposed to the default for 64 bit apps where everything is run on all 4 or all 8 processors.)

Here's a link to a an older thread where I posted some comprehensive background info along with specific instructions for setting affinity for the Data Window:
http://www.jcapper.com/messageboard/TopicReader.asp?topic=1428&forum=JCapper%20101

You might try manually setting affinity for the Data Window to run on a single processor first --

And if that works, take things a step further.

In my own case, on my newer machines I launch the Data Window from a desktop shortcut where the launch commands embedded in the shortcut force Windows to run the target .exe file (in this case the .exe file for the Data Window) on a single processor only.

In my own case, when launched in that manner, the Data Window almost never times out.



-jp

.





Reply
jeff
3/27/2019
11:57:22 AM
Fyi, below is a cut and paste from the target box of the desktop shortcut (described above) that forces Windows to run the Data Window on processor 01 only:

C:\Windows\System32\cmd.exe /C start "" /affinity 01 "C:\JCapper\exe\VBTally2004.exe"

Note: In order for the above command to work, your machine must have a cmd.exe file on the C:\Windows\System32\ folder and it must have a core processor named 01.


-jp

.

Reply
endearus
3/27/2019
7:49:01 PM
Perfect. Thank you so much.

Eric

Reply
Reply

Copyright 2018 JCapper Software              back to the JCapper Message Board              www.JCapper.com