QDeveloper Forum

Member Login

Username

Password

Forget Password

New Sign Up

Search Forum

Buy Support
Incidents

If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:

Click Here

If you can't login and post questions or you are having trouble viewing forum posts:
Click Here

Callback
Support

If you live in USA, UK, Canada, Australia or New Zealand, you can leave us details on your question and request us to call you back and discuss them with you personally (charges apply).

Click Here

Buy Support
Incidents

If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:

Click Here

Forum : Error Creating Header XML -- posting Bills with Access Search Forum

Forum Home > QODBC - ODBC Driver for QuickBooks > QODBC v7 Forum

New Topic

Post Reply

[1]

Error Creating Header XML -- posting Bills with Access

Author Message

  chrisk



Group : Members

Posts : 9

Joined : 2007-01-21

Profile

Posted : 2007-02-18 23:00:02

We are using QODBC v.7.00.00.207 with Quickbooks Pro 2005 to post Bills with an Access 2000 Database, using the "INSERT INTO" method.

The procedure we use is as follow:
1- check if the company is linked with Quickbooks (by opening the Company table)
2- check if VendorName exists
3- post Bills to Quickbooks

It will work fine for a few posts and then QODBC will throw a "Error Creating Header XML"

Here's the QODBCLOG :

2007-02-17 16:31:21 QODBC Ver: 7.00.00.207 *********************************************************************************************************************
IsAService: Unknown
LOADXML Problem
Parsing Error: 0 - ÄA

2007-02-17 16:31:21 QODBC Ver: 7.00.00.207 *********************************************************************************************************************
IsAService: False
SQL Statement: INSERT INTO BillItemLine (VendorRefFullName,TxnDate,DueDate,RefNumber,ItemLineItemRefFullName,ItemLineDesc,ItemLineAmount,FQSaveToCache) VALUES ('E*****e',{d'2007-02-14'},{d'2007-03-16'},'5-P061214087','Subcontractors','100 TERRACE - Unit ',275,0)
Error Creating Header XML on this table in BuildXMLHeader
Input XML:
<?xml version="1.0" encoding="ISO-8859-1"?>
<QBXML>
    <QBXMLMsgsRq responseData="includeAll" onError="continueOnError">
        <BillAddRq requestID="1">
            <BillAdd defMacro="TxnID:69FED70B-F260-4480-A2A6-C5DBFFA7576A">
            </BillAdd>
        </BillAddRq>
    </QBXMLMsgsRq>
</QBXML>

Any idea on what's going wrong here ?

Top

  Tom



Group : Administrator

Posts : 5510

Joined : 2006-02-17

Profile

Posted : 2007-02-19 08:25:22

I would say it's related to the LOADXML Problem. Please review the SDK Message Log for the error details and advise.

Top

  chrisk



Group : Members

Posts : 9

Joined : 2007-01-21

Profile

Posted : 2007-02-19 22:26:17

Here's the sdk :
20070217.163109    I    3308    CertVerifier    The Authenticode signature validated OK.

20070217.163109    I    3308    RequestProcessor    ========= Started Connection =========
20070217.163109    I    3308    RequestProcessor    Request Processor, QBXMLRP2 v4.0
20070217.163109    I    3308    RequestProcessor    Connection opened by app named 'FLEXquarters QODBC'
20070217.163114    I    3308    RequestProcessor    Opening the file in the DoNotCare mode.
20070217.163121    I    3932    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' starting requests (process 3308).
20070217.163121    I    3932    SpecVersion    Current version of qbXML in use: 4.0
20070217.163121    I    3932    QBSDKMsgSetHandler    QUERY: Host
20070217.163121    I    3932    QBSDKMsgSetHandler    Request 1 completed successfully.
20070217.163121    I    3932    QBSDKMsgSetHandler    QUERY: Company
20070217.163121    I    3932    QBSDKMsgSetHandler    Request 2 completed successfully.
20070217.163121    I    3932    QBSDKMsgSetHandler    QUERY: DataExtension Definition
20070217.163121    I    3932    QBSDKMsgSetHandler    Request 3 completed successfully.
20070217.163121    I    3932    MsgSetHandler    Finished.
20070217.163121    I    3932    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' finishing requests (process 3308), ret = 0.

Not sure what I should be looking for though...

Top

  Tom



Group : Administrator

Posts : 5510

Joined : 2006-02-17

Profile

Posted : 2007-02-20 08:28:59

Sorry, you mean't to run your application and when you get the error again go to the bottom of both logs to see what the problem is. Often the SDK log will explain the QuickBooks error.

Top

  chrisk



Group : Members

Posts : 9

Joined : 2007-01-21

Profile

Posted : 2007-02-20 13:01:12

After several error-free posts, the same error came up again. In this batch, I posted 3 invoices: the first one gave an error while the 2 others posted normally. I am sending you the whole sdk log since I wasn't able to see anything resembling an error message. May be you'll see something I've missed... Here are the logs

QODBC

2007-02-19 20:38:23 QODBC Ver: 7.00.00.207 *********************************************************************************************************************
IsAService: Unknown
LOADXML Problem
Parsing Error: 0 - Ä+f

2007-02-19 20:38:23 QODBC Ver: 7.00.00.207 *********************************************************************************************************************
IsAService: False
SQL Statement: INSERT INTO BillItemLine (VendorRefFullName,TxnDate,DueDate,RefNumber,ItemLineItemRefFullName,ItemLineDesc,ItemLineAmount,FQSaveToCache) VALUES ('R*****r',{d'2007-02-02'},{d'2007-03-04'},'3-C070114228','Outside Appraisers Fees','OSA File C070
11 - 60 AVENUE - Unit 6L',187,0)
Error Creating Header XML on this table in BuildXMLHeader
Input XML:
<?xml version="1.0" encoding="ISO-8859-1"?>
<QBXML>
    <QBXMLMsgsRq responseData="includeAll" onError="continueOnError">
        <BillAddRq requestID="1">
            <BillAdd defMacro="TxnID:13C4A282-BD56-4975-B450-42A0990E64AF">
            </BillAdd>
        </BillAddRq>
    </QBXMLMsgsRq>
</QBXML>

SDK Log
20070219.203816    I    2992    CertVerifier    The Authenticode signature validated OK.

20070219.203816    I    2992    RequestProcessor    ========= Started Connection =========
20070219.203816    I    2992    RequestProcessor    Request Processor, QBXMLRP2 v4.0
20070219.203816    I    2992    RequestProcessor    Connection opened by app named 'FLEXquarters QODBC'
20070219.203816    I    2992    RequestProcessor    Opening the file in the DoNotCare mode.
20070219.203817    I    1676    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' starting requests (process 2992).
20070219.203817    I    1676    SpecVersion    Current version of qbXML in use: 4.0
20070219.203817    I    1676    QBSDKMsgSetHandler    QUERY: Host
20070219.203817    I    1676    QBSDKMsgSetHandler    Request 1 completed successfully.
20070219.203817    I    1676    QBSDKMsgSetHandler    QUERY: Company
20070219.203817    I    1676    QBSDKMsgSetHandler    Request 2 completed successfully.
20070219.203817    I    1676    QBSDKMsgSetHandler    QUERY: DataExtension Definition
20070219.203817    I    1676    QBSDKMsgSetHandler    Request 3 completed successfully.
20070219.203817    I    1676    MsgSetHandler    Finished.
20070219.203817    I    1676    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' finishing requests (process 2992), ret = 0.
20070219.203817    I    1676    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' starting requests (process 2992).
20070219.203817    I    1676    SpecVersion    Current version of qbXML in use: 4.1
20070219.203817    I    1676    QBSDKMsgSetHandler    QUERY: Company
20070219.203817    I    1676    QBSDKMsgSetHandler    Request 1 completed successfully.
20070219.203817    I    1676    MsgSetHandler    Finished.
20070219.203817    I    1676    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' finishing requests (process 2992), ret = 0.
20070219.203818    I    2992    RequestProcessor    Connection closed by app named 'FLEXquarters QODBC'
20070219.203818    I    2992    RequestProcessor    ========== Ended Connection ==========
20070219.203819    I    2992    CertVerifier    The Authenticode signature validated OK.

20070219.203819    I    2992    RequestProcessor    ========= Started Connection =========
20070219.203819    I    2992    RequestProcessor    Request Processor, QBXMLRP2 v4.0
20070219.203819    I    2992    RequestProcessor    Connection opened by app named 'FLEXquarters QODBC'
20070219.203819    I    2992    RequestProcessor    Opening the file in the DoNotCare mode.
20070219.203820    I    1676    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' starting requests (process 2992).
20070219.203820    I    1676    SpecVersion    Current version of qbXML in use: 4.0
20070219.203820    I    1676    QBSDKMsgSetHandler    QUERY: Host
20070219.203820    I    1676    QBSDKMsgSetHandler    Request 1 completed successfully.
20070219.203820    I    1676    QBSDKMsgSetHandler    QUERY: Company
20070219.203820    I    1676    QBSDKMsgSetHandler    Request 2 completed successfully.
20070219.203820    I    1676    QBSDKMsgSetHandler    QUERY: DataExtension Definition
20070219.203820    I    1676    QBSDKMsgSetHandler    Request 3 completed successfully.
20070219.203820    I    1676    MsgSetHandler    Finished.
20070219.203820    I    1676    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' finishing requests (process 2992), ret = 0.
20070219.203820    I    1676    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' starting requests (process 2992).
20070219.203821    I    1676    SpecVersion    Current version of qbXML in use: 4.1
20070219.203821    I    1676    QBSDKMsgSetHandler    QUERY: Bill
20070219.203821    I    1676    BillStorage::DoQuery    Returning no more than 00000500 bills
20070219.203821    I    1676    QBSDKMsgSetHandler    Request 1 completed successfully.
20070219.203821    I    1676    MsgSetHandler    Finished.
20070219.203821    I    1676    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' finishing requests (process 2992), ret = 0.
20070219.203821    I    2992    RequestProcessor    Connection closed by app named 'FLEXquarters QODBC'
20070219.203821    I    2992    RequestProcessor    ========== Ended Connection ==========
20070219.203821    I    2992    RequestProcessor    Connection closed by app named 'FLEXquarters QODBC'
20070219.203821    I    2992    RequestProcessor    ========== Ended Connection ==========
20070219.203822    I    2992    CertVerifier    The Authenticode signature validated OK.

20070219.203822    I    2992    RequestProcessor    ========= Started Connection =========
20070219.203822    I    2992    RequestProcessor    Request Processor, QBXMLRP2 v4.0
20070219.203822    I    2992    RequestProcessor    Connection opened by app named 'FLEXquarters QODBC'
20070219.203822    I    2992    RequestProcessor    Opening the file in the DoNotCare mode.
20070219.203823    I    1676    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' starting requests (process 2992).
20070219.203823    I    1676    SpecVersion    Current version of qbXML in use: 4.0
20070219.203823    I    1676    QBSDKMsgSetHandler    QUERY: Host
20070219.203823    I    1676    QBSDKMsgSetHandler    Request 1 completed successfully.
20070219.203823    I    1676    QBSDKMsgSetHandler    QUERY: Company
20070219.203823    I    1676    QBSDKMsgSetHandler    Request 2 completed successfully.
20070219.203823    I    1676    QBSDKMsgSetHandler    QUERY: DataExtension Definition
20070219.203823    I    1676    QBSDKMsgSetHandler    Request 3 completed successfully.
20070219.203823    I    1676    MsgSetHandler    Finished.
20070219.203823    I    1676    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' finishing requests (process 2992), ret = 0.
20070219.203840    I    2992    CertVerifier    The Authenticode signature validated OK.

20070219.203840    I    2992    RequestProcessor    ========= Started Connection =========
20070219.203840    I    2992    RequestProcessor    Request Processor, QBXMLRP2 v4.0
20070219.203840    I    2992    RequestProcessor    Connection opened by app named 'FLEXquarters QODBC'
20070219.203840    I    2992    RequestProcessor    Opening the file in the DoNotCare mode.
20070219.203841    I    1676    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' starting requests (process 2992).
20070219.203841    I    1676    SpecVersion    Current version of qbXML in use: 4.0
20070219.203841    I    1676    QBSDKMsgSetHandler    QUERY: Host
20070219.203841    I    1676    QBSDKMsgSetHandler    Request 1 completed successfully.
20070219.203841    I    1676    QBSDKMsgSetHandler    QUERY: Company
20070219.203841    I    1676    QBSDKMsgSetHandler    Request 2 completed successfully.
20070219.203841    I    1676    QBSDKMsgSetHandler    QUERY: DataExtension Definition
20070219.203841    I    1676    QBSDKMsgSetHandler    Request 3 completed successfully.
20070219.203841    I    1676    MsgSetHandler    Finished.
20070219.203841    I    1676    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' finishing requests (process 2992), ret = 0.
20070219.203841    I    1676    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' starting requests (process 2992).
20070219.203841    I    1676    SpecVersion    Current version of qbXML in use: 4.1
20070219.203841    I    1676    QBSDKMsgSetHandler    QUERY: Bill
20070219.203841    I    1676    BillStorage::DoQuery    Returning no more than 00000500 bills
20070219.203841    I    1676    QBSDKMsgSetHandler    Request 1 completed successfully.
20070219.203841    I    1676    MsgSetHandler    Finished.
20070219.203841    I    1676    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' finishing requests (process 2992), ret = 0.
20070219.203842    I    2992    RequestProcessor    Connection closed by app named 'FLEXquarters QODBC'
20070219.203842    I    2992    RequestProcessor    ========== Ended Connection ==========
20070219.203842    I    2992    RequestProcessor    Connection closed by app named 'FLEXquarters QODBC'
20070219.203842    I    2992    RequestProcessor    ========== Ended Connection ==========
20070219.203842    I    2992    CertVerifier    The Authenticode signature validated OK.

20070219.203842    I    2992    RequestProcessor    ========= Started Connection =========
20070219.203842    I    2992    RequestProcessor    Request Processor, QBXMLRP2 v4.0
20070219.203842    I    2992    RequestProcessor    Connection opened by app named 'FLEXquarters QODBC'
20070219.203843    I    2992    RequestProcessor    Opening the file in the DoNotCare mode.
20070219.203843    I    1676    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' starting requests (process 2992).
20070219.203844    I    1676    SpecVersion    Current version of qbXML in use: 4.0
20070219.203844    I    1676    QBSDKMsgSetHandler    QUERY: Host
20070219.203844    I    1676    QBSDKMsgSetHandler    Request 1 completed successfully.
20070219.203844    I    1676    QBSDKMsgSetHandler    QUERY: Company
20070219.203844    I    1676    QBSDKMsgSetHandler    Request 2 completed successfully.
20070219.203844    I    1676    QBSDKMsgSetHandler    QUERY: DataExtension Definition
20070219.203844    I    1676    QBSDKMsgSetHandler    Request 3 completed successfully.
20070219.203844    I    1676    MsgSetHandler    Finished.
20070219.203844    I    1676    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' finishing requests (process 2992), ret = 0.
20070219.203844    I    1676    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' starting requests (process 2992).
20070219.203844    I    1676    SpecVersion    Current version of qbXML in use: 4.1
20070219.203844    I    1676    QBSDKMsgSetHandler    ADD: Bill
20070219.203845    I    1676    QBSDKMsgSetHandler    Request 1 completed successfully.
20070219.203845    I    1676    MsgSetHandler    Finished.
20070219.203845    I    1676    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' finishing requests (process 2992), ret = 0.
20070219.203845    I    2992    CertVerifier    The Authenticode signature validated OK.

20070219.203845    I    2992    RequestProcessor    ========= Started Connection =========
20070219.203845    I    2992    RequestProcessor    Request Processor, QBXMLRP2 v4.0
20070219.203845    I    2992    RequestProcessor    Connection opened by app named 'FLEXquarters QODBC'
20070219.203846    I    2992    RequestProcessor    Opening the file in the DoNotCare mode.
20070219.203846    I    1676    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' starting requests (process 2992).
20070219.203847    I    1676    SpecVersion    Current version of qbXML in use: 4.0
20070219.203847    I    1676    QBSDKMsgSetHandler    QUERY: Host
20070219.203847    I    1676    QBSDKMsgSetHandler    Request 1 completed successfully.
20070219.203847    I    1676    QBSDKMsgSetHandler    QUERY: Company
20070219.203847    I    1676    QBSDKMsgSetHandler    Request 2 completed successfully.
20070219.203847    I    1676    QBSDKMsgSetHandler    QUERY: DataExtension Definition
20070219.203847    I    1676    QBSDKMsgSetHandler    Request 3 completed successfully.
20070219.203847    I    1676    MsgSetHandler    Finished.
20070219.203847    I    1676    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' finishing requests (process 2992), ret = 0.
20070219.203847    I    1676    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' starting requests (process 2992).
20070219.203847    I    1676    SpecVersion    Current version of qbXML in use: 4.1
20070219.203847    I    1676    QBSDKMsgSetHandler    QUERY: Bill
20070219.203847    I    1676    BillStorage::DoQuery    Returning no more than 00000500 bills
20070219.203847    I    1676    QBSDKMsgSetHandler    Request 1 completed successfully.
20070219.203847    I    1676    MsgSetHandler    Finished.
20070219.203847    I    1676    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' finishing requests (process 2992), ret = 0.
20070219.203847    I    2992    RequestProcessor    Connection closed by app named 'FLEXquarters QODBC'
20070219.203847    I    2992    RequestProcessor    ========== Ended Connection ==========
20070219.203847    I    2992    RequestProcessor    Connection closed by app named 'FLEXquarters QODBC'
20070219.203847    I    2992    RequestProcessor    ========== Ended Connection ==========
20070219.203848    I    2992    CertVerifier    The Authenticode signature validated OK.

20070219.203848    I    2992    RequestProcessor    ========= Started Connection =========
20070219.203848    I    2992    RequestProcessor    Request Processor, QBXMLRP2 v4.0
20070219.203848    I    2992    RequestProcessor    Connection opened by app named 'FLEXquarters QODBC'
20070219.203848    I    2992    RequestProcessor    Opening the file in the DoNotCare mode.
20070219.203849    I    1676    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' starting requests (process 2992).
20070219.203849    I    1676    SpecVersion    Current version of qbXML in use: 4.0
20070219.203849    I    1676    QBSDKMsgSetHandler    QUERY: Host
20070219.203849    I    1676    QBSDKMsgSetHandler    Request 1 completed successfully.
20070219.203849    I    1676    QBSDKMsgSetHandler    QUERY: Company
20070219.203849    I    1676    QBSDKMsgSetHandler    Request 2 completed successfully.
20070219.203849    I    1676    QBSDKMsgSetHandler    QUERY: DataExtension Definition
20070219.203849    I    1676    QBSDKMsgSetHandler    Request 3 completed successfully.
20070219.203849    I    1676    MsgSetHandler    Finished.
20070219.203849    I    1676    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' finishing requests (process 2992), ret = 0.
20070219.203849    I    1676    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' starting requests (process 2992).
20070219.203850    I    1676    SpecVersion    Current version of qbXML in use: 4.1
20070219.203850    I    1676    QBSDKMsgSetHandler    ADD: Bill
20070219.203850    I    1676    QBSDKMsgSetHandler    Request 1 completed successfully.
20070219.203850    I    1676    MsgSetHandler    Finished.
20070219.203850    I    1676    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' finishing requests (process 2992), ret = 0.
20070219.203851    I    2992    CertVerifier    The Authenticode signature validated OK.

20070219.203851    I    2992    RequestProcessor    ========= Started Connection =========
20070219.203851    I    2992    RequestProcessor    Request Processor, QBXMLRP2 v4.0
20070219.203851    I    2992    RequestProcessor    Connection opened by app named 'FLEXquarters QODBC'
20070219.203851    I    2992    RequestProcessor    Opening the file in the DoNotCare mode.
20070219.203852    I    1676    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' starting requests (process 2992).
20070219.203852    I    1676    SpecVersion    Current version of qbXML in use: 4.0
20070219.203852    I    1676    QBSDKMsgSetHandler    QUERY: Host
20070219.203852    I    1676    QBSDKMsgSetHandler    Request 1 completed successfully.
20070219.203852    I    1676    QBSDKMsgSetHandler    QUERY: Company
20070219.203852    I    1676    QBSDKMsgSetHandler    Request 2 completed successfully.
20070219.203852    I    1676    QBSDKMsgSetHandler    QUERY: DataExtension Definition
20070219.203852    I    1676    QBSDKMsgSetHandler    Request 3 completed successfully.
20070219.203852    I    1676    MsgSetHandler    Finished.
20070219.203852    I    1676    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' finishing requests (process 2992), ret = 0.
20070219.203852    I    1676    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' starting requests (process 2992).
20070219.203853    I    1676    SpecVersion    Current version of qbXML in use: 4.1
20070219.203853    I    1676    QBSDKMsgSetHandler    QUERY: Bill
20070219.203853    I    1676    QBSDKMsgSetHandler    Request 1 completed successfully.
20070219.203853    I    1676    MsgSetHandler    Finished.
20070219.203853    I    1676    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' finishing requests (process 2992), ret = 0.
20070219.203853    I    1676    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' starting requests (process 2992).
20070219.203854    I    1676    SpecVersion    Current version of qbXML in use: 4.1
20070219.203854    I    1676    QBSDKMsgSetHandler    QUERY: Transaction Delete
20070219.203854    I    1676    QBSDKMsgSetHandler    Request 1 completed successfully.
20070219.203854    I    1676    MsgSetHandler    Finished.
20070219.203854    I    1676    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' finishing requests (process 2992), ret = 0.
20070219.203855    I    2992    RequestProcessor    Connection closed by app named 'FLEXquarters QODBC'
20070219.203855    I    2992    RequestProcessor    ========== Ended Connection ==========

Top

  Tom



Group : Administrator

Posts : 5510

Joined : 2006-02-17

Profile

Posted : 2007-02-20 14:12:54

The SDK log doesn't point to anything untoward apart from the opening and closing of the connection over and over again. Try leaving the connection open until the whole routine is finished.

Top

  chrisk



Group : Members

Posts : 9

Joined : 2007-01-21

Profile

Posted : 2007-02-21 12:16:04

I've cleaned the code so that there is only one connection per post. The same error appeared at the first try. In this batcth, I posted 2 bills. The error occured on the first one, the second one was posted successfully. Here are the logs :

QODBCLOG

2007-02-20 19:59:27 QODBC Ver: 7.00.00.207 *********************************************************************************************************************
IsAService: Unknown
LOADXML Problem
Parsing Error: 0 - ¼¡h

2007-02-20 19:59:27 QODBC Ver: 7.00.00.207 *********************************************************************************************************************
IsAService: False
SQL Statement: INSERT INTO BillItemLine (VendorRefFullName,TxnDate,DueDate,RefNumber,ItemLineItemRefFullName,ItemLineDesc,ItemLineAmount,FQSaveToCache) VALUES ('M****d',{d'2007-02-02'},{d'2007-03-04'},'8-C070114','Outside Fees','OSA File C07011
4224 - 184 STREET - Unit 6P',185,0)
Error Creating Header XML on this table in BuildXMLHeader
Input XML:
<?xml version="1.0" encoding="ISO-8859-1"?>
<QBXML>
    <QBXMLMsgsRq responseData="includeAll" onError="continueOnError">
        <BillAddRq requestID="1">
            <BillAdd defMacro="TxnID:C11B5D08-154E-4EAA-B11E-F55EEA504105">
            </BillAdd>
        </BillAddRq>
    </QBXMLMsgsRq>
</QBXML>

SDK LOG

20070220.195910    I    1236    CertVerifier    The Authenticode signature validated OK.

20070220.195910    I    1236    RequestProcessor    ========= Started Connection =========
20070220.195910    I    1236    RequestProcessor    Request Processor, QBXMLRP2 v4.0
20070220.195910    I    1236    RequestProcessor    Connection opened by app named 'FLEXquarters

QODBC'
20070220.195912    I    1236    RequestProcessor    Opening the file in the DoNotCare mode.
20070220.195919    I    3392    QBSDKProcessRequest    Application named 'FLEXquarters QODBC'

starting requests (process 1236).
20070220.195920    I    3392    SpecVersion    Current version of qbXML in use: 4.0
20070220.195921    I    3392    QBSDKMsgSetHandler    QUERY: Host
20070220.195921    I    3392    QBSDKMsgSetHandler    Request 1 completed successfully.
20070220.195921    I    3392    QBSDKMsgSetHandler    QUERY: Company
20070220.195921    I    3392    QBSDKMsgSetHandler    Request 2 completed successfully.
20070220.195921    I    3392    QBSDKMsgSetHandler    QUERY: DataExtension Definition
20070220.195921    I    3392    QBSDKMsgSetHandler    Request 3 completed successfully.
20070220.195921    I    3392    MsgSetHandler    Finished.
20070220.195921    I    3392    QBSDKProcessRequest    Application named 'FLEXquarters QODBC'

finishing requests (process 1236), ret = 0.
20070220.195922    I    3392    QBSDKProcessRequest    Application named 'FLEXquarters QODBC'

starting requests (process 1236).
20070220.195923    I    3392    SpecVersion    Current version of qbXML in use: 4.1
20070220.195923    I    3392    QBSDKMsgSetHandler    QUERY: Host
20070220.195923    I    3392    QBSDKMsgSetHandler    Request 1 completed successfully.
20070220.195923    I    3392    MsgSetHandler    Finished.
20070220.195923    I    3392    QBSDKProcessRequest    Application named 'FLEXquarters QODBC'

finishing requests (process 1236), ret = 0.
20070220.195923    I    3392    QBSDKProcessRequest    Application named 'FLEXquarters QODBC'

starting requests (process 1236).
20070220.195924    I    3392    SpecVersion    Current version of qbXML in use: 4.1
20070220.195924    I    3392    QBSDKMsgSetHandler    QUERY: Bill
20070220.195924    I    3392    BillStorage::DoQuery    Returning no more than 00000500 bills
20070220.195927    I    3392    QBSDKMsgSetHandler    Request 1 completed successfully.
20070220.195927    I    3392    MsgSetHandler    Finished.
20070220.195927    I    3392    QBSDKProcessRequest    Application named 'FLEXquarters QODBC'

finishing requests (process 1236), ret = 0.
20070220.195937    I    3392    QBSDKProcessRequest    Application named 'FLEXquarters QODBC'

starting requests (process 1236).
20070220.195937    I    3392    SpecVersion    Current version of qbXML in use: 4.1
20070220.195937    I    3392    QBSDKMsgSetHandler    QUERY: Bill
20070220.195937    I    3392    BillStorage::DoQuery    Returning no more than 00000500 bills
20070220.195937    I    3392    QBSDKMsgSetHandler    Request 1 completed successfully.
20070220.195937    I    3392    MsgSetHandler    Finished.
20070220.195937    I    3392    QBSDKProcessRequest    Application named 'FLEXquarters QODBC'

finishing requests (process 1236), ret = 0.
20070220.195937    I    3392    QBSDKProcessRequest    Application named 'FLEXquarters QODBC'

starting requests (process 1236).
20070220.195938    I    3392    SpecVersion    Current version of qbXML in use: 4.1
20070220.195938    I    3392    QBSDKMsgSetHandler    ADD: Bill
20070220.195939    I    3392    QBSDKMsgSetHandler    Request 1 completed successfully.
20070220.195939    I    3392    MsgSetHandler    Finished.
20070220.195939    I    3392    QBSDKProcessRequest    Application named 'FLEXquarters QODBC'

finishing requests (process 1236), ret = 0.
20070220.195939    I    3392    QBSDKProcessRequest    Application named 'FLEXquarters QODBC'

starting requests (process 1236).
20070220.195940    I    3392    SpecVersion    Current version of qbXML in use: 4.1
20070220.195940    I    3392    QBSDKMsgSetHandler    QUERY: Bill
20070220.195940    I    3392    QBSDKMsgSetHandler    Request 1 completed successfully.
20070220.195940    I    3392    MsgSetHandler    Finished.
20070220.195940    I    3392    QBSDKProcessRequest    Application named 'FLEXquarters QODBC'

finishing requests (process 1236), ret = 0.
20070220.195940    I    3392    QBSDKProcessRequest    Application named 'FLEXquarters QODBC'

starting requests (process 1236).
20070220.195941    I    3392    SpecVersion    Current version of qbXML in use: 4.1
20070220.195941    I    3392    QBSDKMsgSetHandler    QUERY: Transaction Delete
20070220.195941    I    3392    QBSDKMsgSetHandler    Request 1 completed successfully.
20070220.195941    I    3392    MsgSetHandler    Finished.
20070220.195941    I    3392    QBSDKProcessRequest    Application named 'FLEXquarters QODBC'

finishing requests (process 1236), ret = 0.
20070220.195942    I    1236    RequestProcessor    Connection closed by app named 'FLEXquarters

QODBC'
20070220.195942    I    1236    RequestProcessor    ========== Ended Connection ==========

Top

  Tom



Group : Administrator

Posts : 5510

Joined : 2006-02-17

Profile

Posted : 2007-02-21 12:38:38

The logs are of no value here. Please provide the series of SQL Statements that are executed to produce the error. It might be easier to start a trace log. See: How do I turn on the trace log?

Top

  chrisk



Group : Members

Posts : 9

Joined : 2007-01-21

Profile

Posted : 2007-02-21 13:52:33

Here are the SQL statements in the TRACE log in the order they appear

1- First, check if the proper company is opened
SELECT * FROM Host WHERE 1=1

2- For each invoice, I first check if the invoice number already exists in QB

SELECT * FROM BillItemLine WHERE VendorRefFullName = 'Real *** LLC' AND RefNumber = '3-P070114220'

If it does not exists, I create the invoice

    INSERT INTO BillItemLine (VendorRefFullName,TxnDate,DueDate,RefNumber,ItemLineItemRefFullName,ItemLineDesc,ItemLineAmount,FQSaveToCache) VALUES ('Real *** LLC',{d'2007-02-02'},{d'2007-03-04'},'3-P070114220','Outside Appraisers Fees','OSA File P07011 - 200 SOUTH - Unit 19J',277.2,0)
    312
    0x00000000 [ISAMStatement]

This is where the error occured
ISAMInsertRecord
    0x084E4A80 [ISAM]
    0x085F9A30 [BillItemLine]

2007-02-20 21:17:59 QODBC Ver: 7.00.00.207

*********************************************************************************

************************************
IsAService: Unknown
LOADXML Problem
Parsing Error: 0 - ôÌT
Parsing Error: 0 - ôÌT

2007-02-20 21:17:59 QODBC Ver: 7.00.00.207

*********************************************************************************

************************************
IsAService: False
SQL Statement: INSERT INTO BillItemLine

(VendorRefFullName,TxnDate,DueDate,RefNumber,ItemLineItemRefFullName,ItemLineDesc

,ItemLineAmount,FQSaveToCache) VALUES ('Real *** LLC',{d'2007-02-02'},{d'2007-03-04'},'3-P070114220','Outside Fees','OSA
File P07011- 200 SOUTH - Unit 19J',277.2,0)
Error Creating Header XML on this table in BuildXMLHeader
Input XML:
<?xml version="1.0" encoding="ISO-8859-1"?>
<QBXML>
    <QBXMLMsgsRq responseData="includeAll" onError="continueOnError">
        <BillAddRq requestID="1">
            <BillAdd defMacro="TxnID:8F8A902D-5482-4F7D-A886-2E78F1FCB06A">
            </BillAdd>
        </BillAddRq>
    </QBXMLMsgsRq>
</QBXML>

And then continued error-free with the other invoices

SELECT * FROM BillItemLine WHERE VendorRefFullName = 'Real *** LLC' AND RefNumber = '4-FI070114246'

    INSERT INTO BillItemLine

(VendorRefFullName,TxnDate,DueDate,RefNumber,ItemLineItemRefFullName,ItemLineDesc

,ItemLineAmount,FQSaveToCache) VALUES ('Real *** LLC',{d'2007-02-02'},{d'2007-03-04'},'4-FI070114246','Outside Fees','
    OSA File FI0701 - 225 AVENUE - Unit 5P',57.38,0)

SELECT * FROM BillItemLine WHERE VendorRefFullName = 'Real *** LLC' AND RefNumber = '5-P061214087'

    INSERT INTO BillItemLine
(VendorRefFullName,TxnDate,DueDate,RefNumber,ItemLineItemRefFullName,ItemLineDesc,ItemLineAmount,FQSaveToCache) VALUES ('Real *** LLC',{d'2007-02-14'},{d'2007-03-16'},'5-P061214087','Subcontractors','100 TERRACE - Unit ',275,0)

Finally, selecting only those invoices that were sucessfully created, I retreive the TxnNumber

SELECT TOP 2 TxnNumber,VendorRefFullName,RefNumber FROM BillItemLine WHERE 1=1 ORDER BY TIMECREATED desc

This time I also got an error saying "QODBC requires API ver 1.1 or 2", but only once.

Top

  Tom



Group : Administrator

Posts : 5510

Joined : 2006-02-17

Profile

Posted : 2007-02-21 14:18:34

Please remove all use of WHERE 1=1 as it isn't valid. Vendors are found in the Vendor table and must exist before creating a Bill and are found by doing:

Select ListID, Name from Vendor WHERE Name = 'Real *** LLC'

Top

  chrisk



Group : Members

Posts : 9

Joined : 2007-01-21

Profile

Posted : 2007-02-21 14:31:31

Ok. I will remove the "where 1=1" in the first statement.

Vendors do exist in QB, and QODBC sees that as the2nd and 3rd invoice are from the same vendor and they were inserted successfully. The 2nd validation is to ensure that no RefNumber from a Vendor is already in QB, the line was broken by notepad, but it really is :
SELECT * FROM BillItemLine WHERE VendorRefFullName = 'Real *** LLC' AND RefNumber = '3-P070114220'

Still, this does not solve my problem since no errors are found in these statements, but in the following one when INSERTing INTO BillItemLine... What could be the cause of that problem ?

Top

  Tom



Group : Administrator

Posts : 5510

Joined : 2006-02-17

Profile

Posted : 2007-02-21 15:00:46

Seeing that you now have a sequence of SQL Statements to use, try running the statement sequence in VB Demo instead and advise the outcome.

Top

  chrisk



Group : Members

Posts : 9

Joined : 2007-01-21

Profile

Posted : 2007-02-22 00:05:03

It tried each and everyone and they all worked, error free.

Top

  Tom



Group : Administrator

Posts : 5510

Joined : 2006-02-17

Profile

Posted : 2007-02-22 12:40:35

Ok, then you need to look at your actual VBA code to see what the issues are. Something is breaking the ADO connection or posting invalid data to QODBC.

Top

  chrisk



Group : Members

Posts : 9

Joined : 2007-01-21

Profile

Posted : 2007-02-22 13:07:22

I'm not sure about that as tonight I had the same error on an access by the optimizer.
Here's the log :

2007-02-21 20:07:38 QODBC Ver: 7.00.00.207 *********************************************************************************************************************
IsAService: Unknown
LOADXML Problem
Parsing Error: 0 - <•G

2007-02-21 20:07:38 QODBC Ver: 7.00.00.207
******************************************************************************************
IsAService: False
SQL Statement: SELECT * FROM "Host" CALLDIRECT
Error In LoadXML in BuildAndLoadXMLForNextRecord
Input XML:
<?xml version="1.0" ?>
<QBXML>
    <QBXMLMsgsRs>
        <HostQueryRs requestID="1" statusCode="0" statusSeverity="Info" statusMessage="Status OK">
            <HostRet>
                <ProductName>QuickBooks Pro 2005</ProductName>
                <MajorVersion>15</MajorVersion>
                <MinorVersion>0</MinorVersion>
                <Country>US</Country>
                <IsAutomaticLogin>true</IsAutomaticLogin>
                <QBFileMode>MultiUser</QBFileMode>
            </HostRet>
        </HostQueryRs>
    </QBXMLMsgsRs>
</QBXML>

Top

  chrisk



Group : Members

Posts : 9

Joined : 2007-01-21

Profile

Posted : 2007-02-23 13:32:36

Any new thoughts on how to resolve the problem ?

Top

New Topic

Post Reply

[1]

Jump to