Troubleshooting - UNKNOWN EXCEPTION QODBC can't query specific table; crashes QuickBooks

Problem Description:

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:
select * from UnitOfMeasureSet

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).
20170730.171449 I 7784 SpecVersion Current version of qbXML in use: 13.0
20170730.171449 I 7784 QBSDKMsgSetHandler QUERY: Unit Of Measure
20170730.171450 E 7784 StorageInterface *** UNKNOWN EXCEPTION THROWN WHEN PROCESSING THE QUERY REQUEST ***. This is an indication of a possible internal QuickBooks error.

Solution:

When you face this type of error, Please refer QuickBooks SDK logs.

Please note error:

20170730.171449 I 7784 QBSDKMsgSetHandler QUERY: Unit Of Measure
20170730.171450 E 7784 StorageInterface *** UNKNOWN EXCEPTION THROWN WHEN PROCESSING THE QUERY REQUEST ***. This is an indication of a possible internal QuickBooks error.

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:

Enterprise Support

QuickBooks Customer Service & Support

Contact Us - Intuit