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
|
|
Error parsing complete XML return string - ItemReceiptItemLine |
Author |
Message |
|
Posted : 2007-03-02 03:36:32 |
I am having trouble inserting some rows into the ItemReceiptItemLine table. It seems OK for some inserts, but not for others.
QB Version: QuickBooks Enterprise Manufacturing & Wholesale Edition Version 7.0 QODBC Version: 7.00.00.207 The error: [QODBC] Error parsing complete XML return string.
The version of the query I am posting here has the ItemLineQuantity after the PurchaseOrderLineTxnLineID. After reading a few other posts on the "Error parsing" problem I tried the ItemLineQuantity after the RefNumber, but it made no difference.
What do you suggest?
Thanks, Glade Warner
My Query: INSERT INTO ItemReceiptItemLine (VendorRefListID, RefNumber, ItemLineLinkToTxnTxnID, ItemLineLinkToTxnTxnLineID, ItemLineQuantity, FQSaveToCache) Select VendorRefListID, {fn CONCAT({fn CONCAT(RefNumber, ' - ')}, {fn CONVERT(PurchaseOrderLineSeqNo, SQL_VARCHAR)})}, TxnID, PurchaseOrderLineTxnLineID,5000.0 as ItemLineQuantity, 0 as FQSaveToCache from PurchaseOrderLine where VendorRefFullName ='Metropak the Bag Source' and RefNumber='3970' and PurchaseOrderLineSeqNo=1
From QODBCLOG.TXT: 2007-03-01 08:23:39 QODBC Ver: 7.00.00.207 ********************************************************************************************************************* IsAService: False SQL Statement: INSERT INTO ItemReceiptItemLine (VendorRefListID, RefNumber, ItemLineLinkToTxnTxnID, ItemLineLinkToTxnTxnLineID, ItemLineQuantity, FQSaveToCache) Select VendorRefListID, {fn CONCAT({fn CONCAT(RefNumber, ' - ')}, {fn CONVERT(PurchaseOrderLineSeqNo, S QL_VARCHAR)})}, TxnID, PurchaseOrderLineTxnLineID,5000.0 as ItemLineQuantity, 0 as FQSaveToCache from PurchaseOrderLine where VendorRefFullName ='Metropak the Bag Source' and RefNumber='3970' and PurchaseOrderLineSeqNo=1 Optimizer Passthrough Disabled Unsupported scalar function CONCAT
2007-03-01 08:23:52 QODBC Ver: 7.00.00.207 ********************************************************************************************************************* IsAService: False SQL Statement: INSERT INTO ItemReceiptItemLine (VendorRefListID, RefNumber, ItemLineLinkToTxnTxnID, ItemLineLinkToTxnTxnLineID, ItemLineQuantity, FQSaveToCache) Select VendorRefListID, {fn CONCAT({fn CONCAT(RefNumber, ' - ')}, {fn CONVERT(PurchaseOrderLineSeqNo, S QL_VARCHAR)})}, TxnID, PurchaseOrderLineTxnLineID,5000.0 as ItemLineQuantity, 0 as FQSaveToCache from PurchaseOrderLine where VendorRefFullName ='Metropak the Bag Source' and RefNumber='3970' and PurchaseOrderLineSeqNo=1 Error parsing complete XML return string (8) Input XML: <?xml version="1.0" encoding="ISO-8859-1"?> <?qbxml version="6.0"?> <QBXML> <QBXMLMsgsRq onError = "continueOnError" responseData = "includeAll"> <ItemReceiptAddRq requestID = "1"> <ItemReceiptAdd defMacro = "TxnID:1C684953-24D7-40BE-AEB9-BBAB4ED0481A"> <VendorRef> <ListID>800002E5-1170883828</ListID> </VendorRef> <RefNumber>3970 - 1</RefNumber> <ItemLineAdd> <Quantity>5000.00000</Quantity> <LinkToTxn> <TxnID>21E48-1170884230</TxnID> <TxnLineID>21E4A-1170884230</TxnLineID> </LinkToTxn> </ItemLineAdd> </ItemReceiptAdd> </ItemReceiptAddRq> </QBXMLMsgsRq> </QBXML>
From qbsdklog.txt (includes multiple attempts): 20070301.080154 I 7300 RequestProcessor ========= Started Connection ========= 20070301.080154 I 7300 RequestProcessor Request Processor, QBXMLRP2 v6.0 20070301.080154 I 7300 RequestProcessor Connection opened by app named 'FLEXquarters QODBC' 20070301.080154 I 7300 CertVerifier The Authenticode signature validated OK. 20070301.080154 I 7300 RequestProcessor Opening the file in the DoNotCare mode. 20070301.080154 I 10200 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 7300). 20070301.080154 I 10200 SpecVersion Current version of qbXML in use: 6.0 20070301.080154 I 10200 QBSDKMsgSetHandler QUERY: Host 20070301.080154 I 10200 QBSDKMsgSetHandler Request 1 completed successfully. 20070301.080154 I 10200 QBSDKMsgSetHandler QUERY: Company 20070301.080154 I 10200 QBSDKMsgSetHandler Request 2 completed successfully. 20070301.080154 I 10200 QBSDKMsgSetHandler QUERY: DataExtension Definition 20070301.080154 I 10200 QBSDKMsgSetHandler Request 3 completed successfully. 20070301.080154 I 10200 MsgSetHandler Finished. 20070301.080154 I 10200 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 7300), ret = 0. 20070301.080202 I 10200 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 7300). 20070301.080202 I 10200 SpecVersion Current version of qbXML in use: 6.0 20070301.080202 I 10200 QBSDKMsgSetHandler QUERY: PO 20070301.080202 I 10200 PurchaseOrderStorage::DoQuery Setting iterator chunk size to 00000500 20070301.080202 I 10200 QBSDKMsgSetHandler Request 1 completed successfully. 20070301.080202 I 10200 MsgSetHandler Finished. 20070301.080202 I 10200 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 7300), ret = 0. 20070301.080202 I 10200 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 7300). 20070301.080202 I 10200 SpecVersion Current version of qbXML in use: 6.0 20070301.080203 I 10200 QBSDKMsgSetHandler QUERY: Transaction Delete 20070301.080203 I 10200 QBSDKMsgSetHandler Request 1 completed successfully. 20070301.080203 I 10200 MsgSetHandler Finished. 20070301.080203 I 10200 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 7300), ret = 0. 20070301.080203 I 10200 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 7300). 20070301.080203 I 10200 SpecVersion Current version of qbXML in use: 6.0 20070301.080203 I 10200 QBSDKMsgSetHandler ADD: Item Receipt 20070301.080203 E 10200 StorageInterface *** UNKNOWN EXCEPTION THROWN WHEN PROCESSING THE ADD REQUEST ***. This is an indication of a possible internal QuickBooks error. 20070301.080226 E 7300 RequestProcessor Process Request error = 80010105 20070301.080438 I 7300 RequestProcessor Connection closed. 20070301.080438 I 7300 RequestProcessor ========== Ended Connection ==========
20070301.080507 I 8140 RequestProcessor ========= Started Connection ========= 20070301.080507 I 8140 RequestProcessor Request Processor, QBXMLRP2 v6.0 20070301.080507 I 8140 RequestProcessor Connection opened by app named 'FLEXquarters QODBC' 20070301.080508 I 8140 CertVerifier The Authenticode signature validated OK. 20070301.080508 I 8140 RequestProcessor Opening the file in the DoNotCare mode. 20070301.080508 I 10200 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 8140). 20070301.080508 I 10200 SpecVersion Current version of qbXML in use: 6.0 20070301.080508 I 10200 QBSDKMsgSetHandler QUERY: Host 20070301.080508 I 10200 QBSDKMsgSetHandler Request 1 completed successfully. 20070301.080508 I 10200 QBSDKMsgSetHandler QUERY: Company 20070301.080508 I 10200 QBSDKMsgSetHandler Request 2 completed successfully. 20070301.080508 I 10200 QBSDKMsgSetHandler QUERY: DataExtension Definition 20070301.080508 I 10200 QBSDKMsgSetHandler Request 3 completed successfully. 20070301.080508 I 10200 MsgSetHandler Finished. 20070301.080508 I 10200 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 8140), ret = 0. 20070301.080511 I 10200 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 8140). 20070301.080511 I 10200 SpecVersion Current version of qbXML in use: 6.0 20070301.080511 I 10200 QBSDKMsgSetHandler QUERY: PO 20070301.080511 I 10200 PurchaseOrderStorage::DoQuery Setting iterator chunk size to 00000500 20070301.080511 I 10200 QBSDKMsgSetHandler Request 1 completed successfully. 20070301.080511 I 10200 MsgSetHandler Finished. 20070301.080511 I 10200 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 8140), ret = 0. 20070301.080511 I 10200 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 8140). 20070301.080511 I 10200 SpecVersion Current version of qbXML in use: 6.0 20070301.080511 I 10200 QBSDKMsgSetHandler QUERY: Transaction Delete 20070301.080512 I 10200 QBSDKMsgSetHandler Request 1 completed successfully. 20070301.080512 I 10200 MsgSetHandler Finished. 20070301.080512 I 10200 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 8140), ret = 0. 20070301.080512 I 10200 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 8140). 20070301.080512 I 10200 SpecVersion Current version of qbXML in use: 6.0 20070301.080512 I 10200 QBSDKMsgSetHandler ADD: Item Receipt 20070301.080512 E 10200 StorageInterface *** UNKNOWN EXCEPTION THROWN WHEN PROCESSING THE ADD REQUEST ***. This is an indication of a possible internal QuickBooks error. 20070301.080520 E 8140 RequestProcessor Process Request error = 80010105 20070301.080702 I 8140 RequestProcessor Connection closed. 20070301.080702 I 8140 RequestProcessor ========== Ended Connection ==========
20070301.082033 I 8448 RequestProcessor ========= Started Connection ========= 20070301.082033 I 8448 RequestProcessor Request Processor, QBXMLRP2 v6.0 20070301.082033 I 8448 RequestProcessor Connection opened by app named 'FLEXquarters QODBC' 20070301.082033 I 8448 CertVerifier The Authenticode signature validated OK. 20070301.082033 I 8448 RequestProcessor Opening the file in the DoNotCare mode. 20070301.082033 I 10200 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 8448). 20070301.082033 I 10200 SpecVersion Current version of qbXML in use: 6.0 20070301.082033 I 10200 QBSDKMsgSetHandler QUERY: Host 20070301.082033 I 10200 QBSDKMsgSetHandler Request 1 completed successfully. 20070301.082033 I 10200 QBSDKMsgSetHandler QUERY: Company 20070301.082033 I 10200 QBSDKMsgSetHandler Request 2 completed successfully. 20070301.082033 I 10200 QBSDKMsgSetHandler QUERY: DataExtension Definition 20070301.082033 I 10200 QBSDKMsgSetHandler Request 3 completed successfully. 20070301.082033 I 10200 MsgSetHandler Finished. 20070301.082033 I 10200 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 8448), ret = 0. 20070301.082056 I 10200 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 8448). 20070301.082056 I 10200 SpecVersion Current version of qbXML in use: 6.0 20070301.082056 I 10200 QBSDKMsgSetHandler QUERY: PO 20070301.082056 I 10200 PurchaseOrderStorage::DoQuery Setting iterator chunk size to 00000500 20070301.082056 I 10200 QBSDKMsgSetHandler Request 1 completed successfully. 20070301.082056 I 10200 MsgSetHandler Finished. 20070301.082056 I 10200 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 8448), ret = 0. 20070301.082056 I 10200 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 8448). 20070301.082057 I 10200 SpecVersion Current version of qbXML in use: 6.0 20070301.082057 I 10200 QBSDKMsgSetHandler QUERY: Transaction Delete 20070301.082057 I 10200 QBSDKMsgSetHandler Request 1 completed successfully. 20070301.082057 I 10200 MsgSetHandler Finished. 20070301.082057 I 10200 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 8448), ret = 0. 20070301.082057 I 10200 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 8448). 20070301.082057 I 10200 SpecVersion Current version of qbXML in use: 6.0 20070301.082057 I 10200 QBSDKMsgSetHandler ADD: Item Receipt 20070301.082057 E 10200 StorageInterface *** UNKNOWN EXCEPTION THROWN WHEN PROCESSING THE ADD REQUEST ***. This is an indication of a possible internal QuickBooks error. 20070301.082111 E 8448 RequestProcessor Process Request error = 80010105 20070301.082152 I 8448 RequestProcessor Connection closed. 20070301.082152 I 8448 RequestProcessor ========== Ended Connection ==========
20070301.082157 I 9204 RequestProcessor ========= Started Connection ========= 20070301.082157 I 9204 RequestProcessor Request Processor, QBXMLRP2 v6.0 20070301.082157 I 9204 RequestProcessor Connection opened by app named 'FLEXquarters QODBC' 20070301.082157 I 9204 CertVerifier The Authenticode signature validated OK. 20070301.082158 I 9204 RequestProcessor Opening the file in the DoNotCare mode. 20070301.082158 I 10200 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 9204). 20070301.082158 I 10200 SpecVersion Current version of qbXML in use: 6.0 20070301.082158 I 10200 QBSDKMsgSetHandler QUERY: Host 20070301.082158 I 10200 QBSDKMsgSetHandler Request 1 completed successfully. 20070301.082158 I 10200 QBSDKMsgSetHandler QUERY: Company 20070301.082158 I 10200 QBSDKMsgSetHandler Request 2 completed successfully. 20070301.082158 I 10200 QBSDKMsgSetHandler QUERY: DataExtension Definition 20070301.082158 I 10200 QBSDKMsgSetHandler Request 3 completed successfully. 20070301.082158 I 10200 MsgSetHandler Finished. 20070301.082158 I 10200 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 9204), ret = 0. 20070301.082204 I 10200 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 9204). 20070301.082204 I 10200 SpecVersion Current version of qbXML in use: 6.0 20070301.082204 I 10200 QBSDKMsgSetHandler QUERY: PO 20070301.082204 I 10200 PurchaseOrderStorage::DoQuery Setting iterator chunk size to 00000500 20070301.082204 I 10200 QBSDKMsgSetHandler Request 1 completed successfully. 20070301.082204 I 10200 MsgSetHandler Finished. 20070301.082204 I 10200 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 9204), ret = 0. 20070301.082204 I 10200 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 9204). 20070301.082204 I 10200 SpecVersion Current version of qbXML in use: 6.0 20070301.082204 I 10200 QBSDKMsgSetHandler QUERY: Transaction Delete 20070301.082204 I 10200 QBSDKMsgSetHandler Request 1 completed successfully. 20070301.082204 I 10200 MsgSetHandler Finished. 20070301.082204 I 10200 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 9204), ret = 0. 20070301.082204 I 10200 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 9204). 20070301.082204 I 10200 SpecVersion Current version of qbXML in use: 6.0 20070301.082204 I 10200 QBSDKMsgSetHandler ADD: Item Receipt 20070301.082204 E 10200 StorageInterface *** UNKNOWN EXCEPTION THROWN WHEN PROCESSING THE ADD REQUEST ***. This is an indication of a possible internal QuickBooks error. 20070301.082211 E 10200 QBSDKProcessRequest *** INTERNAL ERROR WHEN PROCESSING THE QBXML REQUEST ***. 20070301.082215 E 9204 RequestProcessor Process Request error = 80010105 20070301.082300 I 9204 RequestProcessor Connection closed. 20070301.082300 I 9204 RequestProcessor ========== Ended Connection ==========
20070301.082334 I 6372 RequestProcessor ========= Started Connection ========= 20070301.082334 I 6372 RequestProcessor Request Processor, QBXMLRP2 v6.0 20070301.082334 I 6372 RequestProcessor Connection opened by app named 'FLEXquarters QODBC' 20070301.082334 I 6372 CertVerifier The Authenticode signature validated OK. 20070301.082334 I 6372 RequestProcessor Opening the file in the DoNotCare mode. 20070301.082334 I 7616 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 6372). 20070301.082334 I 7616 SpecVersion Current version of qbXML in use: 6.0 20070301.082334 I 7616 QBSDKMsgSetHandler QUERY: Host 20070301.082334 I 7616 QBSDKMsgSetHandler Request 1 completed successfully. 20070301.082334 I 7616 QBSDKMsgSetHandler QUERY: Company 20070301.082334 I 7616 QBSDKMsgSetHandler Request 2 completed successfully. 20070301.082334 I 7616 QBSDKMsgSetHandler QUERY: DataExtension Definition 20070301.082334 I 7616 QBSDKMsgSetHandler Request 3 completed successfully. 20070301.082334 I 7616 MsgSetHandler Finished. 20070301.082334 I 7616 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 6372), ret = 0. 20070301.082339 I 7616 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 6372). 20070301.082339 I 7616 SpecVersion Current version of qbXML in use: 6.0 20070301.082339 I 7616 QBSDKMsgSetHandler QUERY: PO 20070301.082339 I 7616 PurchaseOrderStorage::DoQuery Setting iterator chunk size to 00000500 20070301.082339 I 7616 QBSDKMsgSetHandler Request 1 completed successfully. 20070301.082339 I 7616 MsgSetHandler Finished. 20070301.082339 I 7616 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 6372), ret = 0. 20070301.082339 I 7616 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 6372). 20070301.082339 I 7616 SpecVersion Current version of qbXML in use: 6.0 20070301.082339 I 7616 QBSDKMsgSetHandler QUERY: Transaction Delete 20070301.082339 I 7616 QBSDKMsgSetHandler Request 1 completed successfully. 20070301.082339 I 7616 MsgSetHandler Finished. 20070301.082339 I 7616 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 6372), ret = 0. 20070301.082339 I 7616 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 6372). 20070301.082339 I 7616 SpecVersion Current version of qbXML in use: 6.0 20070301.082339 I 7616 QBSDKMsgSetHandler ADD: Item Receipt 20070301.082339 E 7616 StorageInterface *** UNKNOWN EXCEPTION THROWN WHEN PROCESSING THE ADD REQUEST ***. This is an indication of a possible internal QuickBooks error. 20070301.082348 E 7616 QBSDKProcessRequest *** INTERNAL ERROR WHEN PROCESSING THE QBXML REQUEST ***. 20070301.082352 E 6372 RequestProcessor Process Request error = 80010105
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-03-02 08:48:49 |
You cannot play with the ItemLineQuantity, each line must be receipted in full. Linked Item Receipts must be done like this:
INSERT INTO "ItemReceiptItemLine" ("VendorRefListID", "RefNumber", "ItemLineLinkToTxnTxnID", "ItemLineLinkToTxnTxnLineID", "FQSaveToCache") Select "VendorRefListID", {fn CONCAT('POLink', "RefNumber")}, "TxnID", "PurchaseOrderLineTxnLineID", 0 as "FQSaveToCache" from PurchaseOrderLine where "VendorRefFullName" ='Perry Windows & Doors' and "RefNumber"='401' and "PurchaseOrderLineSeqNo"=1
If the quantity needs to be varied, update the purchase order line first.
See: How do I receive Items against a Purchase Order? Receive Inventory without Bill? ItemReceipts for more information. |
|
|
|
|
Posted : 2007-03-02 12:16:17 |
Tom, my customers receive things in stages, not all at once. I want to send the partial receipts to QuickBooks as they are performed by the receiving clerks. My insert queries work most of the time. I get an occasional problem, and captured one of the SQL that causes the trouble (posted in this thread).
Are you sure that I can't set the ItemLineQuantity in this query? If not, then how would I receive less than expected on the PO?
Thanks, Glade Warner |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-03-02 13:11:23 |
I bearly got linked receipts going in the first place. What you need to do is to change the purchase order first. For example, if 30 were ordered and 10 were received, change (UPDATE) the quantity on the purchase order line from 30 to 20 and then add (INSERT) a new purchase order line for 10 and fully receipt that line, leaving 20 still to be received on the original purchase order line. Ok?
The error "*** UNKNOWN EXCEPTION THROWN WHEN PROCESSING THE ADD REQUEST ***. This is an indication of a possible internal QuickBooks error." should also be read as meaning you can corrupt the company file if you keep on doing this.
|
|
|
|
|
Posted : 2007-03-03 05:57:49 |
Thanks for the information. That is helpful. Unfortunately POs are created by another department and are a business document that are sent out to the customers. It is not appropriate that I modify any PO, other than recording receipts.
I'll modify my code so that if the receipt is exactly a full receipt (not over and not under) then I'll follow your advice and not use the ItemLineQuantity so a full receipt gets recorded in QuickBooks. Otherwise, I'll continue to use the ItemLineQuantity and capture any exceptions thrown. For those with exceptions, I'll post an error message telling the receiving people that they will need to complete recording the receipt directly in QB. I'll also hope that the company file is not corrupted.
I don't see that I can do anything else.
Thanks for your quick replies. You always do a great job!
-- Glade Warner |
|
|
|
|