[QODBC-Desktop] Troubleshooting - UNKNOWN EXCEPTION QODBC can't query specific table; crashes QuickBooks
Posted by Jack - QODBC Support on 03 August 2017 12:47 PM
Troubleshooting - UNKNOWN EXCEPTION QODBC can't query-specific table; crashes QuickBooks
QB Desktop Enterprise 2017 Manufacturing & Wholesale R5_88 Successfully installed QODBC using Optimizer. Can query every table with QODBC Test Tool and MS Access, except:
UnitOfMeasureSet, UnitOfMeasureSetRelatedUnit, UnitOfMeasureSetDefaultUnit
Any query of these tables hard crashes QuickBooks!
When I execute query:
Within 5 seconds of executing the query, QuickBooks crashed:
There is no entry in the QODBC log.
Can find below entries in the QuickBooks SDK log:
20170730.171449 I 7784 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 7196).
When you face this type of error, Please refer to QuickBooks SDK logs.
Please note the error:
20170730.171449 I 7784 QBSDKMsgSetHandler QUERY: Unit Of Measure
When you see error *** UNKNOWN EXCEPTION THROWN WHEN PROCESSING THE QUERY REQUEST *** in QuickBooks SDK logs. You should test the same on another company file to see if the issue is related to the company file or not.
If you are still getting the same error in QuickBooks SDK logs with other company files, then There might be some internal error that occurred in processing request. To resolve this error, you need to get in touch with Intuit.
You can get in touch with Intuit using the below links: