08-01-2013 09:32 AM
I periodically get the TestStand 2010 SP1 SQL error below when performing a database query in TestStand through an Oracle ODBC connection. It typically happens the first time the query has been ran in a while so I suspect that it has something to do with the SQL query timing out when it is initially caching data upon first database connection and taking longer to complete. If you run the query multiple times in a row it will typically complete without error.
Is there some setting in TestStand or ODBC drivers where I can experiment with different query timeout settings?
Error, The following SQL command failed: 'SELECT XXVOC_BLUETOOTH_ASSIGNMENT.BLUETOOTH_ID, XXVOC_BLUETOOTH_ASSIGNMENT.CATEGORY, XXVOC_BLUETOOTH_ASSIGNMENT.SERIAL_NUMBER FROM XXVOC.XXVOC_BLUETOOTH_ASSIGNMENT XXVOC_BLUETOOTH_ASSIGNMENT WHERE (XXVOC_BLUETOOTH_ASSIGNMENT.SERIAL_NUMBER='12345678')...' Native error code -2147217871 0x80040e31 Microsoft OLE DB Provider for ODBC Drivers: [Oracle][ODBC][Ora]ORA-01013: user requested cancel of current operation [Error Code: -10, User-defined error code.]
08-02-2013 02:43 PM
Sometimes a simple TestStand repair can fix the problem. Contorl Panel>>Uninstall a Program>>National Instruments Software>>Uninstall/change>>TestStand >>repair.
Also make sure you don't have any variables missing in TS.
08-02-2013 02:46 PM
Edna - so you're saying that this is not a timeout issue with waiting on the SQL query to complete but rather a TestStand corruption issue?
08-05-2013 12:11 PM
It could be. You can also try and see if the same behaviour happens without using testStand.
08-29-2013 02:31 AM
Aaron -
I have never personally seen this error; however doing a search it does suggest that this error indicates that Oracle (or your database server) returned a query timeout because the current query was taking too long.
The suggested fix is to do th following:
Hope this helps.
09-04-2013 10:28 AM
Thanks for the reply Scott,
Unfortunately everytime I click on the "Application" tab within the Config window I get the error "An unsupported operation was attempted". It will not let me get to the tab that has that setting. I have tried this on numerous PCs and I get the same error message. Any idea what is causing that?
Regards,
Aaron
09-05-2013 09:36 AM
Are you sure that you have all the latest patches installed regarding Oracle Database on your computer? It looks like patch 5699495 would fix the issue.
This link talks about a workaround solution: http://www.idevelopment.info/data/Oracle/DBA_tips/Microsoft_Windows/WINDOWS_7.shtml
https://forums.oracle.com/message/9324776
09-07-2013 09:38 AM
Aaron -
The error you are receiving in the ODBC administrator does appear to be an Oracle client bug of some sort. Can you let us know if you can obtain the patch from Oracle and see if that fixes the issue?
If you are creating a User DSN, I believe the settings for the DSN are stored in the Windows registery in a location similar to the following:
Key Path: HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\<Name of your User DSN>\
Key Name: QueryTimeout
Key Value: T or F
One option might be to see if the value is T and change it manually in the registry to F.