Microsoft JET Database Engine error

[HarveyL]

Hello,

I'm using TestStand 2.0 with Microsoft Access 2000 database. I have the "Open SQL Statement" in the "Setup" section of my sequence and the "Close SQL Statement" in the "Cleanup" section.  I only use the database to retrieve info.  I do not write any data to the database thru out my code.  Everything runs fine until after 18 hours of continuous execution, I received the following Run-time error:

Details:

Error executing substep "Post".
The following SQL command failed: 'SELECT * FROM
ATP_Test_Limits WHERE ModuleName = 'Channel B'...'
Native error code -2147467259 0x80004005
Microsoft JET Database Engine.

Error Code:

-10; User-defined error code.

At first, I thought this could be related to the system virtual memory settings.  So, I've changed the file size to the maximum of 768 MB  (System's RAM = 256 MB).  This enabled the code to run for a couple of hours longer but afterward I still received the same error.  Any help to this problem is greatly appreciated.  Many thanks in advanced.

Regards,

Harvey

[Matt M.]

Hi Harvey,

I have found two TestStand knowledge base articles that may help you understand your problem.

The first, TestStand Run-Time Error -10 When Opening Database Repeatedly, discusses error -10 when accessing a database repeatedly; however, I believe that the situation described in this knowledge base may be a little different from your problem because you only open and close your database once. That said, it may be worth investigating your version of MDAC and potentially downloading a later version (as described in the article).

The second knowledge base, Why Does the TestStand Memory Usage Increase Over Time when I Am Running Loops with Large Iteration ..., discusses problems when TestStand executes for long periods of time. There are two solutions in this document: 1) Disable result collection for the loop or 2) Generate your report on the fly. I believe this might be your problem because you said when you increased the virtual memory you were able to execute longer.

I would recommend that you take a look at these two knowledge bases and get back to us with your results.

Matt M.
National Instruments