[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 VB Demo 32 and MS Access, except:
UnitOfMeasureSet, UnitOfMeasureSetRelatedUnit, UnitOfMeasureSetDefaultUnit
Any query of these tables hard crashes QuickBooks!
When I execute query:
Within 5 seconds of executing query QuickBooks crashed:
There is no entry in QODBC log.
Can find below entries in 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 QuickBooks SDK logs.
Please note 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 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 occurred in processing request. To resolve this error you need to get in touch with Intuit.
You can get in touch with Intuit using below links: