Hi,

There is a serious bug with QODBC v 7.10.00.231.

Even using the sample VBDemo app. doing a Select * from Customer

No error is displayed (unless I do it Access) but in the trace log:

     SUPPORTED: TRUE
        NAME:      VARCHAR
        TYPE:      12
ISAMNextRecord
    0x0017FD18 [ISAM]
    0x001B3450 [Customer]
    Optimizer Passthrough: FALSE
    Optimized SQL 1:
    Optimized SQL 2:
    Elapsed Time: 00:00:00 Time Difference: 00:00:00.360 Building XML Request
    Elapsed Time: 00:00:00 Time Difference: 00:00:00.000 Waiting On QuickBooks
    Elapsed Time: 00:00:03 Time Difference: 00:00:03.094 Initial XML Parse
    Elapsed Time: 00:00:03 Time Difference: 00:00:00.000 Initial XML Parse - LoadXML Start
    Elapsed Time: 00:00:03 Time Difference: 00:00:00.171 Initial XML Parse - LoadXML End
    Elapsed Time: 00:00:03 Time Difference: 00:00:00.000 Find First Record
    ISAM_FIND_ERR S0000 00000 [QODBC] Error: %s
    ISAMNextRecordExit
ISAMGetErrorMessage
    0x0017FD18 [ISAM]
    S0000 00000 [QODBC] Error: 1000 - There has been an internal error when processing the request.

Sorry, there are more that 1,500 users on this forum alone that can run:

Select * from Customer

without any problems. I suggest you install QODBC v8 and also try another company file.

Hi,

Yes I installed v 8 - I guess the QODBC installation had some corruption.

The problem has recocurred - when I first ran the select * from Customers it only returned 500 rows (which is the Iterator chunck size) - I increased it to 2000 and also toggled the optimizer.

It is still not working.

Help!!!

I did some more testing - I uninstalled then re-installed QODBC v8, when I set the Iterator chunck size 1000 rows it would bring back 1000 customer rows then completed. I know from there should be around 2400 rows in the tables. When I set the chuck size to 1001 the internal error happened. It appears to be working fine on other tables.

As Requested from the Trace:

20071023.115748 I 4400 RequestProcessor ========= Started Connection =========
20071023.115748 I 4400 RequestProcessor Connection opened by app named 'FLEXquarters QODBC'
20071023.115748 I 4400 CertVerifier The file does not contain an Authenticode signature.
20071023.115748 I 4400 RequestProcessor Opening the file in the DoNotCare mode.
20071023.115749 I 6324 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 4400).
20071023.115749 I 6324 SpecVersion Current version of qbXML in use: AU3.0
20071023.115749 I 6324 QBSDKMsgSetHandler QUERY: Host
20071023.115749 I 6324 QBSDKMsgSetHandler Request 1 completed successfully.
20071023.115749 I 6324 QBSDKMsgSetHandler QUERY: Company
20071023.115749 I 6324 QBSDKMsgSetHandler Request 2 completed successfully.
20071023.115749 I 6324 QBSDKMsgSetHandler QUERY: DataExtension Definition
20071023.115749 I 6324 QBSDKMsgSetHandler Request 3 completed successfully.
20071023.115749 I 6324 MsgSetHandler Finished.
20071023.115749 I 6324 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 4400), ret = 0.
20071023.115807 I 6324 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 4400).
20071023.115807 I 6324 SpecVersion Current version of qbXML in use: AU3.0
20071023.115807 I 6324 QBSDKMsgSetHandler QUERY: Customer Job
20071023.115807 I 6324 CustomerStorage::DoQuery Returning no more than 00000100 customers
20071023.115807 E 6324 CustomerStorage::DoQuery The FromModified and ToModified filter date range is invalid
20071023.115807 I 6324 QBSDKMsgSetHandler Request 1 failed.
20071023.115807 I 6324 MsgSetHandler Finished.
20071023.115807 I 6324 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 4400), ret = 0.
20071023.115808 I 6324 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 4400).
20071023.115808 I 6324 SpecVersion Current version of qbXML in use: AU3.0
20071023.115808 I 6324 QBSDKMsgSetHandler QUERY: Customer Job
20071023.115808 I 6324 CustomerStorage::DoQuery Returning no more than 00000100 customers
20071023.115808 I 6324 QBSDKMsgSetHandler Request 1 completed successfully.
20071023.115808 I 6324 MsgSetHandler Finished.
20071023.115808 I 6324 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 4400), ret = 0.
20071023.115810 I 6324 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 4400).
20071023.115811 I 6324 SpecVersion Current version of qbXML in use: AU3.0
20071023.115811 I 6324 QBSDKMsgSetHandler QUERY: Customer Job
20071023.115811 I 6324 CustomerStorage::DoQuery Returning no more than 00000100 customers
20071023.115811 E 6324 StorageInterface *** UNKNOWN EXCEPTION THROWN WHEN PROCESSING THE QUERY REQUEST ***. This is an indication of a possible internal QBXML error.
20071023.115811 I 6324 QBSDKMsgSetHandler Request 1 failed.
20071023.115811 I 6324 MsgSetHandler Finished.
20071023.115811 I 6324 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 4400), ret = 0.
20071023.120104 I 6324 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 4400).
20071023.120104 I 6324 SpecVersion Current version of qbXML in use: AU3.0
20071023.120104 I 6324 QBSDKMsgSetHandler QUERY: Customer Job
20071023.120104 I 6324 CustomerStorage::DoQuery Returning no more than 00000100 customers
20071023.120104 E 6324 CustomerStorage::DoQuery The FromModified and ToModified filter date range is invalid
20071023.120104 I 6324 QBSDKMsgSetHandler Request 1 failed.
20071023.120104 I 6324 MsgSetHandler Finished.
20071023.120104 I 6324 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 4400), ret = 0.
20071023.120104 I 6324 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 4400).
20071023.120104 I 6324 SpecVersion Current version of qbXML in use: AU3.0
20071023.120104 I 6324 QBSDKMsgSetHandler QUERY: Customer Job
20071023.120104 I 6324 CustomerStorage::DoQuery Returning no more than 00000100 customers
20071023.120105 I 6324 QBSDKMsgSetHandler Request 1 completed successfully.
20071023.120105 I 6324 MsgSetHandler Finished.
20071023.120105 I 6324 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 4400), ret = 0.
20071023.120107 I 6324 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 4400).
20071023.120107 I 6324 SpecVersion Current version of qbXML in use: AU3.0
20071023.120107 I 6324 QBSDKMsgSetHandler QUERY: Customer Job
20071023.120107 I 6324 CustomerStorage::DoQuery Returning no more than 00000100 customers
20071023.120107 E 6324 StorageInterface *** UNKNOWN EXCEPTION THROWN WHEN PROCESSING THE QUERY REQUEST ***. This is an indication of a possible internal QBXML error.
20071023.120107 I 6324 QBSDKMsgSetHandler Request 1 failed.
20071023.120107 I 6324 MsgSetHandler Finished.
20071023.120107 I 6324 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 4400), ret = 0.
20071023.120356 I 4400 RequestProcessor Connection closed by app named 'FLEXquarters QODBC'
20071023.120356 I 4400 RequestProcessor ========== Ended Connection ==========

20071023.121027 I 4400 RequestProcessor ========= Started Connection =========
20071023.121027 I 4400 RequestProcessor Connection opened by app named 'FLEXquarters QODBC'
20071023.121027 I 4400 CertVerifier The file does not contain an Authenticode signature.
20071023.121028 I 4400 RequestProcessor Opening the file in the DoNotCare mode.
20071023.121029 I 6324 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 4400).
20071023.121029 I 6324 SpecVersion Current version of qbXML in use: AU3.0
20071023.121029 I 6324 QBSDKMsgSetHandler QUERY: Host
20071023.121030 I 6324 QBSDKMsgSetHandler Request 1 completed successfully.
20071023.121030 I 6324 QBSDKMsgSetHandler QUERY: Company
20071023.121030 I 6324 QBSDKMsgSetHandler Request 2 completed successfully.
20071023.121030 I 6324 QBSDKMsgSetHandler QUERY: DataExtension Definition
20071023.121030 I 6324 QBSDKMsgSetHandler Request 3 completed successfully.
20071023.121030 I 6324 MsgSetHandler Finished.
20071023.121030 I 6324 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 4400), ret = 0.
20071023.121032 I 6324 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 4400).
20071023.121032 I 6324 SpecVersion Current version of qbXML in use: AU3.0
20071023.121032 I 6324 QBSDKMsgSetHandler QUERY: Customer Job
20071023.121032 I 6324 CustomerStorage::DoQuery Returning no more than 00000100 customers
20071023.121032 E 6324 CustomerStorage::DoQuery The FromModified and ToModified filter date range is invalid
20071023.121032 I 6324 QBSDKMsgSetHandler Request 1 failed.
20071023.121032 I 6324 MsgSetHandler Finished.
20071023.121032 I 6324 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 4400), ret = 0.
20071023.121032 I 6324 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 4400).
20071023.121032 I 6324 SpecVersion Current version of qbXML in use: AU3.0
20071023.121032 I 6324 QBSDKMsgSetHandler QUERY: Customer Job
20071023.121032 I 6324 CustomerStorage::DoQuery Returning no more than 00000100 customers
20071023.121033 I 6324 QBSDKMsgSetHandler Request 1 completed successfully.
20071023.121033 I 6324 MsgSetHandler Finished.
20071023.121033 I 6324 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 4400), ret = 0.
20071023.121035 I 6324 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 4400).
20071023.121035 I 6324 SpecVersion Current version of qbXML in use: AU3.0
20071023.121035 I 6324 QBSDKMsgSetHandler QUERY: Customer Job
20071023.121035 I 6324 CustomerStorage::DoQuery Returning no more than 00000100 customers
20071023.121036 E 6324 StorageInterface *** UNKNOWN EXCEPTION THROWN WHEN PROCESSING THE QUERY REQUEST ***. This is an indication of a possible internal QBXML error.
20071023.121036 I 6324 QBSDKMsgSetHandler Request 1 failed.
20071023.121036 I 6324 MsgSetHandler Finished.
20071023.121036 I 6324 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 4400), ret = 0.

Sorry that wont help - if I set the chunk size to more than 1000 it crashes (internal Error) so I cant get the data I want.

This is a serious problem for our business as it means we cant invoice customers....

Shall we revert to an older version or won't this help ?

Tom,

As you suggested we restored a backup of our company file and performed a repair. UNfortunately the problems persisted (unable to pull more than a chunk of 1000 records).

I was wondering if the problem could be data related ? As understand it the data is retrieved via XML - could it be that the XML is not welformed if the data contains some unescaped invalid characters ?

Anyway, I will try and install the older versions of the QODBC and see if we have any luck.

Tim

Tom, some more info.

I installed v6 of QODBC - and the problems were the same - which is telling me it is not QODBC but somehting else as it used to work on this version. The SDK log is referring to "This is an indication of a possible internal QBXML error."

I looked in the common folder in "C:\Program Files\Common Files\Intuit\QuickBooks" - this contained the file "QBXMLRP2.DLL" which was version 3.0.4.4

I got hold of another file QBXMLRP2.DLL which was version 6.0.17.4005 - and replaced ir with this. When I used VBdemo I was then able to select back all the customers!!!

BUT, - when I tried to do the inserts into the Customers Table I got an Internal Error!!

Anyway - I have put back the 3.0.4.4 DLL and Re registeterd it,

Obvioulsy there is some issue with the SDK. But I am still a little confused as this problem still occurs on other mchines... could this be a problem with the current SDK ?

Thanks

Tim

Hi

Yes that US DLL was from another PC where I installed the SDK some time ago. But it was not installed on our production server. So the problem still exists.

Hi,

I installed a fresh version of Quickbooks 2007/2008 and the latest 8.00.00.237 build on a new machine.

I still get the same problems : see the log

20071031.114557 I 240 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 3652), ret = 0.
20071031.114605 I 240 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 3652).
20071031.114605 I 240 SpecVersion Current version of qbXML in use: AU3.0
20071031.114605 I 240 QBSDKMsgSetHandler QUERY: Customer Job
20071031.114605 I 240 CustomerStorage::DoQuery Returning no more than 00000500 customers
20071031.114611 I 240 QBSDKMsgSetHandler Request 1 completed successfully.
20071031.114611 I 240 MsgSetHandler Finished.
20071031.114611 I 240 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 3652), ret = 0.
20071031.114635 I 240 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 3652).
20071031.114635 I 240 SpecVersion Current version of qbXML in use: AU3.0
20071031.114635 I 240 QBSDKMsgSetHandler QUERY: Customer Job
20071031.114635 I 240 CustomerStorage::DoQuery Returning no more than 00000500 customers
20071031.114648 E 240 StorageInterface *** UNKNOWN EXCEPTION THROWN WHEN PROCESSING THE QUERY REQUEST ***. This is an indication of a possible internal QBXML error.
20071031.114648 I 240 QBSDKMsgSetHandler Request 1 failed.
20071031.114648 I 240 MsgSetHandler Finished.

Shall I send you a copy of our company file, so you can see the error first hand ?

Thanks

Tim

After dealing with Intuit for over a week - they could not find any problems with the data

- However, I have found a solution that works . I downloaded the SDK from Intuit and copied the QBXMLRP2.DLL (v6.0.17.4005)  to "C:\Program Files\Intuit\Quickbooks" which now allows me to read data from Quickbooks - but this will not allow me to write to Quickbooks, so I will perform the writing operations on another PC using the v3 QBXMLRP2.DLL (installed with the Australian version of Quickbooks).

I dont know where the problem is, I will have to make do with this workaround.