QODBC v8 |
Author |
Message |
|
Posted : 2007-11-13 03:38:31 |
I am trying to insert a linked invoice into QB and QB keeps dying on me. Two questions:
1 - Does the RefNumber field have to contain the "SOLink" and
2 - The logs and reports when QB dies state that there may be an internal QB problem. I just upgraded to version 8 from version 7 and just bought QODBC v8 this morning. Any ideas on what the problem might be and any way to fix it?
Thanks,
Deborah |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-11-13 07:40:45 |
The RefNumber is the invoice number and is alpha-numeric, so it can start with any letters but should always finish with numbers. It doesn't need to contain a "SOLInk" reference. To create a invoice from a Sales Order, see: How do I convert a Sales Order into an Invoice?
In order to fix anything, you need to state the SQL Statement you were executing and the actual error shown at the end of the QODBC and SDK Message logs. |
|
|
|
|
Posted : 2007-11-13 08:31:07 |
QODBC Messages:
2007-11-12 16:26:53 QODBC Ver: 8.00.00.237 ********************************************************************************************************************* IsAService: False Error Code: 26 SQLOptimize_OpenOptimizeDBHandle prepare: SELECT "type", "tbl_name" FROM "SQLite_MASTER" file is encrypted or is not a database
2007-11-12 16:26:58 QODBC Ver: 8.00.00.237 ********************************************************************************************************************* IsAService: False Error Code: 26 SQLOptimize_OpenOptimizeDBHandle prepare: SELECT "type", "tbl_name" FROM "SQLite_MASTER" file is encrypted or is not a database
2007-11-12 16:27:09 QODBC Ver: 8.00.00.237 ********************************************************************************************************************* IsAService: False Error Code: 26 SQLOptimize_OpenOptimizeDBHandle prepare: SELECT "type", "tbl_name" FROM "SQLite_MASTER" file is encrypted or is not a database
2007-11-12 16:27:30 QODBC Ver: 8.00.00.237 ********************************************************************************************************************* IsAService: False Error Code: 26 SQLOptimize_OpenOptimizeDBHandle prepare: SELECT "type", "tbl_name" FROM "SQLite_MASTER" file is encrypted or is not a database
SDK Messages: 20071112.162638 I 3940 CertVerifier The file does not contain an Authenticode signature.
20071112.162638 I 3940 RequestProcessor ========= Started Connection ========= 20071112.162638 I 3940 RequestProcessor Request Processor, QBXMLRP2 v7.0 20071112.162638 I 3940 RequestProcessor Connection opened by app named 'FLEXquarters QODBC' 20071112.162642 I 800 UI Subscription:Update No subscription updates detected 20071112.162646 I 3940 RequestProcessor Opening the file in the DoNotCare mode. 20071112.162651 I 800 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 3940). 20071112.162653 I 800 SpecVersion Current version of qbXML in use: 4.0 20071112.162653 I 800 QBSDKMsgSetHandler QUERY: Host 20071112.162653 I 800 QBSDKMsgSetHandler Request 1 completed successfully. 20071112.162653 I 800 QBSDKMsgSetHandler QUERY: Company 20071112.162653 I 800 QBSDKMsgSetHandler Request 2 completed successfully. 20071112.162653 I 800 QBSDKMsgSetHandler QUERY: DataExtension Definition 20071112.162653 I 800 QBSDKMsgSetHandler Request 3 completed successfully. 20071112.162653 I 800 MsgSetHandler Finished. 20071112.162653 I 800 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 3940), ret = 0. 20071112.162654 I 800 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 3940). 20071112.162654 I 800 SpecVersion Current version of qbXML in use: 7.0 20071112.162654 I 800 QBSDKMsgSetHandler QUERY: Class 20071112.162654 I 800 QBSDKMsgSetHandler Request 1 completed successfully. 20071112.162654 I 800 MsgSetHandler Finished. 20071112.162654 I 800 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 3940), ret = 0. 20071112.162656 I 800 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 3940). 20071112.162656 I 800 SpecVersion Current version of qbXML in use: 7.0 20071112.162656 I 800 QBSDKMsgSetHandler QUERY: Class 20071112.162656 I 800 QBSDKMsgSetHandler Request 1 completed successfully. 20071112.162656 I 800 MsgSetHandler Finished. 20071112.162656 I 800 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 3940), ret = 0. 20071112.162656 I 3940 CertVerifier The file does not contain an Authenticode signature.
20071112.162656 I 3940 RequestProcessor ========= Started Connection ========= 20071112.162656 I 3940 RequestProcessor Request Processor, QBXMLRP2 v7.0 20071112.162656 I 3940 RequestProcessor Connection opened by app named 'FLEXquarters QODBC' 20071112.162657 I 3940 RequestProcessor Opening the file in the DoNotCare mode. 20071112.162658 I 800 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 3940). 20071112.162658 I 800 SpecVersion Current version of qbXML in use: 4.0 20071112.162658 I 800 QBSDKMsgSetHandler QUERY: Host 20071112.162658 I 800 QBSDKMsgSetHandler Request 1 completed successfully. 20071112.162658 I 800 QBSDKMsgSetHandler QUERY: Company 20071112.162658 I 800 QBSDKMsgSetHandler Request 2 completed successfully. 20071112.162658 I 800 QBSDKMsgSetHandler QUERY: DataExtension Definition 20071112.162658 I 800 QBSDKMsgSetHandler Request 3 completed successfully. 20071112.162658 I 800 MsgSetHandler Finished. 20071112.162658 I 800 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 3940), ret = 0. 20071112.162700 I 800 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 3940). 20071112.162700 I 800 SpecVersion Current version of qbXML in use: 7.0 20071112.162700 I 800 QBSDKMsgSetHandler QUERY: Customer Job 20071112.162700 I 800 CustomerStorage::DoQuery Setting iterator chunk size to 00000500 20071112.162700 I 800 QBSDKMsgSetHandler Request 1 completed successfully. 20071112.162700 I 800 MsgSetHandler Finished. 20071112.162700 I 800 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 3940), ret = 0. 20071112.162707 I 800 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 3940). 20071112.162708 I 800 SpecVersion Current version of qbXML in use: 7.0 20071112.162708 I 800 QBSDKMsgSetHandler QUERY: Customer Job 20071112.162708 I 800 QBSDKMsgSetHandler Request 1 completed successfully. 20071112.162708 I 800 MsgSetHandler Finished. 20071112.162708 I 800 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 3940), ret = 0. 20071112.162708 I 3940 CertVerifier The file does not contain an Authenticode signature.
20071112.162708 I 3940 RequestProcessor ========= Started Connection ========= 20071112.162708 I 3940 RequestProcessor Request Processor, QBXMLRP2 v7.0 20071112.162708 I 3940 RequestProcessor Connection opened by app named 'FLEXquarters QODBC' 20071112.162709 I 3940 RequestProcessor Opening the file in the DoNotCare mode. 20071112.162709 I 800 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 3940). 20071112.162709 I 800 SpecVersion Current version of qbXML in use: 4.0 20071112.162709 I 800 QBSDKMsgSetHandler QUERY: Host 20071112.162709 I 800 QBSDKMsgSetHandler Request 1 completed successfully. 20071112.162709 I 800 QBSDKMsgSetHandler QUERY: Company 20071112.162709 I 800 QBSDKMsgSetHandler Request 2 completed successfully. 20071112.162709 I 800 QBSDKMsgSetHandler QUERY: DataExtension Definition 20071112.162709 I 800 QBSDKMsgSetHandler Request 3 completed successfully. 20071112.162709 I 800 MsgSetHandler Finished. 20071112.162709 I 800 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 3940), ret = 0. 20071112.162711 I 800 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 3940). 20071112.162711 I 800 SpecVersion Current version of qbXML in use: 7.0 20071112.162711 I 800 QBSDKMsgSetHandler QUERY: Invoice 20071112.162711 I 800 InvoiceStorage::DoQuery Setting iterator chunk size to 00000500 20071112.162711 I 800 QBSDKMsgSetHandler Request 1 completed successfully. 20071112.162711 I 800 MsgSetHandler Finished. 20071112.162711 I 800 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 3940), ret = 0. 20071112.162729 I 3940 CertVerifier The file does not contain an Authenticode signature.
20071112.162729 I 3940 RequestProcessor ========= Started Connection ========= 20071112.162729 I 3940 RequestProcessor Request Processor, QBXMLRP2 v7.0 20071112.162729 I 3940 RequestProcessor Connection opened by app named 'FLEXquarters QODBC' 20071112.162730 I 3940 RequestProcessor Opening the file in the DoNotCare mode. 20071112.162730 I 800 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 3940). 20071112.162730 I 800 SpecVersion Current version of qbXML in use: 4.0 20071112.162730 I 800 QBSDKMsgSetHandler QUERY: Host 20071112.162730 I 800 QBSDKMsgSetHandler Request 1 completed successfully. 20071112.162730 I 800 QBSDKMsgSetHandler QUERY: Company 20071112.162730 I 800 QBSDKMsgSetHandler Request 2 completed successfully. 20071112.162730 I 800 QBSDKMsgSetHandler QUERY: DataExtension Definition 20071112.162730 I 800 QBSDKMsgSetHandler Request 3 completed successfully. 20071112.162730 I 800 MsgSetHandler Finished. 20071112.162730 I 800 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 3940), ret = 0. 20071112.162733 I 800 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 3940). 20071112.162733 I 800 SpecVersion Current version of qbXML in use: 7.0 20071112.162733 I 800 QBSDKMsgSetHandler QUERY: Sales Order 20071112.162733 I 800 SalesOrderStorage::DoQuery Setting iterator chunk size to 00000500 20071112.162733 I 800 QBSDKMsgSetHandler Request 1 completed successfully. 20071112.162733 I 800 MsgSetHandler Finished. 20071112.162733 I 800 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 3940), ret = 0. 20071112.162736 I 800 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 3940). 20071112.162736 I 800 SpecVersion Current version of qbXML in use: 7.0 20071112.162736 I 800 QBSDKMsgSetHandler QUERY: Sales Order 20071112.162737 I 800 QBSDKMsgSetHandler Request 1 completed successfully. 20071112.162737 I 800 MsgSetHandler Finished. 20071112.162737 I 800 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 3940), ret = 0. 20071112.162737 I 800 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 3940). 20071112.162737 I 800 SpecVersion Current version of qbXML in use: 7.0 20071112.162737 I 800 QBSDKMsgSetHandler ADD: Invoice 20071112.162737 E 800 StorageInterface *** UNKNOWN EXCEPTION THROWN WHEN PROCESSING THE ADD REQUEST ***. This is an indication of a possible internal QuickBooks error. 20071112.162804 E 800 QBSDKProcessRequest *** INTERNAL ERROR WHEN PROCESSING THE QBXML REQUEST ***. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-11-13 10:21:04 |
The QODBC Message Log indicates that your optimized file has been corrupted, see: How do I switch OFF or RESET the QODBC optimizer? to rectify that. The SDK Message Log says the ADD Invoice operation failed with an internal error, but you haven't posted the insert statement that failed, so I can't guess the cause. |
|
|
|
|
Posted : 2007-11-14 01:28:19 |
Here's the program output and insert statement:
SALES ORDER ROWS FETCHED 1 FOUND SALES ORDER ORDER FIELDS: CUSTOMERREFLISTID 800000BD-1194293928 RefNumber SO207005005
INVOICELINELINKTOTXNTXNID 1D9-1194884460 InvoiceLineLinkToTxnTxnLineID 1DB-1194884460 UPDATE QUERY INSERT INTO "InvoiceLine" ("CustomerRefListID","RefNumber", "InvoiceLineLinkToTxnTxnID", "InvoiceLineLinkToTxnTxnLineID", "FQSaveToCache") VALUES ('800000BD-1194293928', 'SO207005005', '1D9-1194884460', '1DB-1194884460', 0) Warning: ODBC Success With Info, Optimizer is turned off State:S0000,Native:10080,Origin:[QODBC] |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-11-14 08:23:48 |
I can't see where the data is coming from but:
InvoiceLineLinkToTxnTxnID should be the SalesOrderLine.TxnID value for the sales order and:
InvoiceLineLinkToTxnTxnLineID should be the SalesOrderLine.SalesOrderLineTxnLineID value for the sales order line in the same sales order.
|
|
|
|
|
Posted : 2007-11-14 09:19:41 |
It is - I'm doing a query and setting up a newinvoice with the data from the sales order. Here's the relevant code for that portion: newinvoice.m_InvoiceLineLinkToTxnTxnID = sorder.m_TxnID; TRACE("\nINVOICELINELINKTOTXNTXNID %s\n",newinvoice.m_InvoiceLineLinkToTxnTxnID); newinvoice.m_InvoiceLineLinkToTxnTxnLineID = sorder.m_SalesOrderLineTxnLineID; TRACE("InvoiceLineLinkToTxnTxnLineID %s\n",newinvoice.m_InvoiceLineLinkToTxnTxnLineID); |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-11-14 10:02:04 |
Try executing the insert statement using VB Demo instead so you can see the real error. |
|
|
|
|
Posted : 2007-11-15 02:41:17 |
I have actually tried that but all it does is kill QuickBooks then VBDemo says the query completed but it didn't. I get a bunch of reports to send to QuickBooks and the sdk log within those reports says this: 20071114.102208 I 4776 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 5352). 20071114.102208 I 4776 SpecVersion Current version of qbXML in use: 7.0 20071114.102208 I 4776 QBSDKMsgSetHandler ADD: Invoice 20071114.102208 E 4776 StorageInterface *** UNKNOWN EXCEPTION THROWN WHEN PROCESSING THE ADD REQUEST ***. This is an indication of a possible internal QuickBooks error.
And I get this in the Trace Log: ISAMNextRecord 0x001805D0 [ISAM] 0x062B4940 [Invoice] Optimizer Passthrough: FALSE Optimized SQL 1: Optimized SQL 2: Elapsed Time: 00:00:00 Time Difference: 00:00:00.203 Building XML Request Elapsed Time: 00:00:00 Time Difference: 00:00:00.000 Waiting On QuickBooks QBXMLProcessXMLWithStringPointer5 Error: Error = 8004041c, An internal QuickBooks error occurred while trying to access the QuickBooks company data file.
2007-11-14 10:29:27 QODBC Ver: 8.00.00.237 ********************************************************************************************************************* IsAService: False SQL Statement: SELECT * FROM "Invoice" CALLDIRECT Error Getting XML in BuildAndLoadXMLForNextRecord Input XML: <?xml version="1.0" encoding="ISO-8859-1"?> <?qbxml version="7.0"?> <QBXML> <QBXMLMsgsRq onError="continueOnError"> <InvoiceQueryRq requestID="1" iterator="Start"> <MaxReturned>00000250</MaxReturned> <IncludeLineItems>1</IncludeLineItems> <IncludeLinkedTxns>1</IncludeLinkedTxns> </InvoiceQueryRq> </QBXMLMsgsRq> </QBXML> ISAM_ERROR S0000 S0000 [QODBC] Error ISAMNextRecordExit ISAMGetErrorMessage 0x001805D0 [ISAM] S0000 S0000 [QODBC] Error ISAMCloseTable 0x001805D0 [ISAM] 0x062B4940 [Invoice] NO_ISAM_ERR 00000 00000 OptimizeLoadEmptyTable: Invoice UpdateTime: 2007-11-14 10:29:27.000 (UpdateLastTimeModified) NO_ISAM_ERR 00000 00000 ISAMCloseTable 0x001805D0 [ISAM] 0x001BF130 [InvoiceLine] NO_ISAM_ERR 00000 00000 ISAMClose |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-11-15 08:43:23 |
Please advise what edition of QuickBooks you are using? From the log I see it's QuickBooks 2008. Could you please open one of the sample company files instead of your company file and run VB Demo and do:
Select * from customer and Select * from Invoice
and let me know whether that works? |
|
|
|
|
Posted : 2007-11-16 02:22:32 |
I am using Quickbooks Enterprise Solutions Version 8.0 Product Number 826-859. Both of the queries worked. They were very slow but they worked. |
|
|
|
|
Posted : 2007-12-08 05:02:36 |
I tried uninstalling QuickBooks and reinstalling it and I still get the same error. I also updated to the latest version of QODBC. I tried running the insert in VBDemo and it also still kills QuickBooks. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-12-09 21:20:07 |
|
|
|
|
Posted : 2008-01-09 08:31:34 |
I finally got it to work by totally uninstalling QuickBooks 8 and doing a clean install. I guess the QuickBooks program got corrupted when I upgraded to version 8. |
|
|
|