Knowledgebase
[QODBC-Desktop] Troubleshooting - INTERNAL ERROR WHEN PROCESSING THE QBXML REQUEST
Posted by Jack - QODBC Support on 10 November 2014 02:46 PM

Troubleshooting - INTERNAL ERROR WHEN PROCESSING THE QBXML REQUEST

Problem Description:

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 ***.

Solutions:

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.

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).