I'm having trouble inserting a new customer.  Below is the SQL String and the XML from the log file.  This exact format has worked flawlessly for hundreds of customers but this one for some reason won't go in.

INSERT INTO Customer (Name,FirstName,LastName,BillAddressAddr1,BillAddressAddr2,BillAddressAddr3,BillAddressCity,BillAddressState,
BillAddressPostalCode,BillAddressCountry,ShipAddressAddr1,ShipAddressAddr2,ShipAddressAddr3,ShipAddressCity,ShipAddressState,
ShipAddressPostalCode,ShipAddressCountry,Phone,Email,SalesTaxCodeRefListID,CreditCardInfoCreditCardNumber,
CreditCardInfoExpirationMonth,CreditCardInfoExpirationYear,CreditCardInfoNameOnCard,CreditCardInfoCreditCardAddress,
CreditCardInfoCreditCardPostalCode) VALUES('Richman, Karen-2273526','Karen','Richman','202 Braddock St','','','Fairmont','WV','26554','US','202 Braddock St','','','Fairmont','WV','26554','US','3043668202','Krichman@ma.rr.com','20000-1039908035', '----------------',12,07,'Karen L. Richman','202 Braddock St','26554')

Error parsing complete XML return string (8)
Input XML:
<?xml version="1.0" encoding="ISO-8859-1"?>
<?qbxml version="5.0"?>
<QBXML>
    <QBXMLMsgsRq onError = "continueOnError" responseData = "includeAll">
        <CustomerAddRq requestID = "1">
            <CustomerAdd>
                <Name>Richman, Karen-2273526</Name>
                <FirstName>Karen</FirstName>
                <LastName>Richman</LastName>
                <BillAddress>
                    <Addr1>202 Braddock St</Addr1>
                    <Addr2>
                    </Addr2>
                    <Addr3>
                    </Addr3>
                    <City>Fairmont</City>
                    <State>WV</State>
                    <PostalCode>26554</PostalCode>
                    <Country>US</Country>
                </BillAddress>
                <ShipAddress>
                    <Addr1>202 Braddock St</Addr1>
                    <Addr2>
                    </Addr2>
                    <Addr3>
                    </Addr3>
                    <City>Fairmont</City>
                    <State>WV</State>
                    <PostalCode>26554</PostalCode>
                    <Country>US</Country>
                </ShipAddress>
                <Phone>3043668202</Phone>
                <Email>Krichman@ma.rr.com</Email>
                <SalesTaxCodeRef>
                    <ListID>20000-1039908035</ListID>
                </SalesTaxCodeRef>
                <CreditCardInfo>
                    <CreditCardNumber>----------------</CreditCardNumber>
                    <ExpirationMonth>12</ExpirationMonth>
                    <ExpirationYear>7</ExpirationYear>
                    <NameOnCard>Karen L. Richman</NameOnCard>
                    <CreditCardAddress>202 Braddock St</CreditCardAddress>
                    <CreditCardPostalCode>26554</CreditCardPostalCode>
                </CreditCardInfo>
            </CustomerAdd>
        </CustomerAddRq>

Thanks,

Josh

Sorry, I changed the SaleTaxCodeListID to match one of theTax Codes in my version of QuickBooks and your insert worked without error for me using QODBC v7.00.00.199:

INSERT INTO Customer (Name,FirstName,LastName,BillAddressAddr1,BillAddressAddr2,BillAddressAddr3,BillAddressCity,BillAddressState,
BillAddressPostalCode,BillAddressCountry,ShipAddressAddr1,ShipAddressAddr2,ShipAddressAddr3,ShipAddressCity,ShipAddressState,
ShipAddressPostalCode,ShipAddressCountry,Phone,Email,SalesTaxCodeRefListID,CreditCardInfoCreditCardNumber,
CreditCardInfoExpirationMonth,CreditCardInfoExpirationYear,CreditCardInfoNameOnCard,CreditCardInfoCreditCardAddress,
CreditCardInfoCreditCardPostalCode) VALUES('Richman, Karen-2273526','Karen','Richman','202 Braddock St','','','Fairmont','WV','26554','US','202 Braddock St','','','Fairmont','WV','26554','US','3043668202','Krichman@ma.rr.com','20000-999022286', '----------------',12,07,'Karen L. Richman','202 Braddock St','26554')

Tom,

It appears this is a bigger problem than originally thought.  Now we are also seeing the error "Error Getting XML in BuildAndLoadXMLForNextRecord".  I've upgraded the QODBC version to the latest one but still the same error.

Josh

"Error Getting XML in BuildAndLoadXMLForNextRecord" indicates that you need to increase the Iterator or Chunk Size value in the QODBC Setup Screen. This determines the size of the rowsets that are retrieved from QuickBooks. Set this value higher if you're not using the USA version of QuickBooks 2006 and 2007 to cover the maximum number of records the query will return.  The maximum Iterator or Chunk size that can be set is 100000 (higher than that and it resets itself back to the default of 500).

Hi Tom,

Thanks for the quick reply.  I tried different values for the Chunk Size but it still gives me the same error.  I even maxed it out just to make sure.

Josh

Tom,

We've identified the issue but we're a little confused as to the actual root cause.  The problem as it turns out is from the Remote QuickBooks machine running out of memory.  At least QuickBooks thinks so, the machine actually had plenty of free memory.  QuickBooks actually crashed out while I had my client checking some stuff, upon re-login everything started working again.

Thanks,

Josh