Troubleshooting - INTERNAL ERROR WHEN PROCESSING THE QBXML REQUEST
I have QuickBooks 2014 version & I am using QODBC latest version. I have a problem with querying customer table using QODBC.
QODBC driver consistently gets stuck on "Find Next Record" at record #9000. Have tried the following:
- Reset optimizer file
- Rebuild QuickBooks company file
- sp_optimizefullsync Customer: this crashes QuickBooks or does not complete properly. There are still records missing from the Customer table that appear in QuickBooks.
- Query customer table using UNOPTIMIZED keyword, unoptimized hangs at about record 9000 and does not return the Customer
On QuickBooks SDK logs, I noticed below error:
20140923.175608 E 3888 QBSDKProcessRequest *** INTERNAL ERROR WHEN PROCESSING THE QBXML REQUEST ***.
There might be some internal error occurred during processing request. To resolve this error you need to get in touch with Intuit.
Please restart QuickBooks & try again. As you are saying that query stuck on #9000. There might be some issue with company file. Please test the same on another company file or in sample company file to see if the issue is related to company file or not.
Also, try changing the Iterator value to 100 on QODBC Setup Screen--Advanced Tab
If you are still facing the same error there might be the issue with your company file and would require repairing the company file & you need to get in touch with Intuit.