Knowledgebase: QODBC
[QODBC-Desktop] Troubleshooting - Unable to load all customer records due to CustomerShippingAddress
Posted by Jack - QODBC Support on 24 November 2016 09:00 AM

Troubleshooting - Unable to load all customer records due to CustomerShippingAddress

Problem Description:

I am unable to load all customer records through QODBC.

I have a large number of ship-to addresses customers.

I have tried to execute the query using the UNOPTIMIZED keyword. But still didn't get records.

I have noticed the below error in QODBC logs.

SELECT * FROM Customer UNOPTIMIZED

Error Getting XML in BuildAndLoadXMLForNextRecord
 

Solution:

Please follow the below steps & test again.

1. Open QODBC Setup Screen from the Advanced tab. Set the iterator size to 10.

Start >> All Programs >> QODBC Driver for use with QuickBooks >> Configure QODBC Data Source >> Go To "User DSN" or "System DSN" Tab (i.e., Whatever DSN you are using)>> select your DSN >> click "configure" >> switch to Advanced tab >> Set Iterator or Chunk Size to 10 & apply changes.

 

2. Execute the below query in the Customer table.

Select * from Customer UNOPTIMIZED

OR

Query the table Customer with filter ListID or FullName.

For Example:

Select * from Customer UNOPTIMIZED where fullname='ABC.'

OR

Attempt to optimize the customer table through QODBC Test Tool using the below query & check again. (Retry if fail).

SP_OPTIMIZEFULLSYNC Customer

 

(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).