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 on updating an invoice in version 7 |
Author |
Message |
KofK |
|
Group | : Members |
Posts | : 43 |
Joined | : 2006-04-04 |
|
Profile |
|
Posted : 2006-11-02 02:07:08 |
I used the following SQL statements in QODBC v6 and it worked fine now in v7 I get a "[QODBC] Error parsing complete XML string" error. (The TxnIDs are from the Sample Rock Castle Construction Company Invoice RefNumber 74)
INSERT INTO InvoiceLine (TxnID, TxnDate, InvoiceLineDesc, FQSaveToCache) VALUES ('4346-1071520492', {d'2006-10-31'}, 'Test', 0 )
INSERT INTO InvoiceLine (TxnID, TermsRefFullName, InvoiceLineDesc, FQSaveToCache) VALUES ('4346-1071520492', 'Due on receipt', 'Test', 0 )
If I remove TxnDate and TermsRefFullName so that the SQL statement reads: INSERT INTO InvoiceLine (TxnID, InvoiceLineDesc, FQSaveToCache) VALUES ('4346-1071520492', 'Test', 0 ) It works fine.
Here are the error logs:
Error: (Worked in version 6) INSERT INTO InvoiceLine (TxnID, TxnDate, InvoiceLineDesc, FQSaveToCache) VALUES ('4346-1071520492', {d'2006-10-31'}, 'Test', 0 )
2006-11-01 09:42:42 QODBC Ver: 7.00.00.194 ********************************************************************************************************************* IsAService: False SQL Statement: INSERT INTO InvoiceLine (TxnID, TxnDate, InvoiceLineDesc, FQSaveToCache) VALUES ('4346-1071520492', {d'2006-10-31'}, 'Test', 0 )
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 = "includeNone"> <InvoiceModRq requestID = "1"> <InvoiceMod> <TxnID>4346-1071520492</TxnID> <EditSequence>1197729745</EditSequence> <InvoiceLineMod> <TxnLineID>4348-1071520492</TxnLineID> </InvoiceLineMod> <InvoiceLineMod> <TxnLineID>4349-1071520492</TxnLineID> </InvoiceLineMod> <InvoiceLineMod> <TxnLineID>434A-1071520492</TxnLineID> </InvoiceLineMod> <InvoiceLineMod> <TxnLineID>5BEC-1071520492</TxnLineID> </InvoiceLineMod> <InvoiceLineMod> <TxnLineID>5BED-1071520492</TxnLineID> </InvoiceLineMod> <InvoiceLineMod> <TxnLineID>5BEE-1071520492</TxnLineID> </InvoiceLineMod> <InvoiceLineMod> <TxnLineID>5BEF-1071520492</TxnLineID> </InvoiceLineMod> <TxnDate>2006-10-31</TxnDate> <InvoiceLineMod> <TxnLineID>-1</TxnLineID> <Desc>Test</Desc> </InvoiceLineMod> </InvoiceMod> </InvoiceModRq> </QBXMLMsgsRq> </QBXML>
20061101.094224 I 644 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 3892). 20061101.094224 I 644 SpecVersion Current version of qbXML in use: 5.0 20061101.094224 I 644 QBSDKMsgSetHandler QUERY: Invoice 20061101.094224 I 644 QBSDKMsgSetHandler Request 1 completed successfully. 20061101.094224 I 644 MsgSetHandler Finished. 20061101.094224 I 644 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 3892), ret = 0. 20061101.094224 I 644 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 3892). 20061101.094225 I 644 SpecVersion Current version of qbXML in use: 5.0 20061101.094225 I 644 QBSDKMsgSetHandler MODIFY: Invoice 20061101.094225 E 644 CListsNotify::OnNotify(const CNotifyDataEdListElement*) invalid CNotify msg enum 20061101.094225 E 644 CListsNotify::OnNotify(const CNotifyDataEdListElement*) invalid CNotify msg enum 20061101.094225 E 644 CListsNotify::OnNotify(const CNotifyDataEdListElement*) invalid CNotify msg enum 20061101.094225 I 644 QBSDKMsgSetHandler Request 1 completed successfully. 20061101.094225 I 644 MsgSetHandler Finished. 20061101.094225 I 644 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 3892), ret = 0. 20061101.094241 I 644 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 3892). 20061101.094242 I 644 SpecVersion Current version of qbXML in use: 5.0 20061101.094242 I 644 QBSDKMsgSetHandler QUERY: Invoice 20061101.094242 I 644 QBSDKMsgSetHandler Request 1 completed successfully. 20061101.094242 I 644 MsgSetHandler Finished. 20061101.094242 I 644 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 3892), ret = 0. 20061101.094242 I 644 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 3892). 20061101.094242 E 644 XercesSAXErrorHandler Element 'TxnDate' is not valid for content model: '(TxnID,EditSequence,CustomerRef?,ClassRef?,ARAccountRef?,TemplateRef?,TxnDate?,RefNumber?,BillAddress?,ShipAddress?, IsPending?,PONumber?,TermsRef?,DueDate?,SalesRepRef?,FOB?,ShipDate?,ShipMethodRef?,ItemSalesTaxRef?,Memo?, CustomerMsgRef?,IsToBePrinted?,CustomerSalesTaxCodeRef?,((InvoiceLineMod|InvoiceLineGroupMod))*)' -- error at line 7, column 687 in XML data. 20061101.094242 I 644 MsgSetHandler Parser error, finishing. 20061101.094242 I 644 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 3892), ret = 1. 20061101.094242 E 3892 RequestProcessor Process Request error = 80042500, There was an error when parsing the provided XML file. 20061101.094242 I 644 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 3892). 20061101.094242 E 644 XercesSAXErrorHandler Element 'TxnDate' is not valid for content model: '(TxnID,EditSequence,CustomerRef?,ClassRef?,ARAccountRef?,TemplateRef?,TxnDate?,RefNumber?,BillAddress?,ShipAddress?, IsPending?,PONumber?,TermsRef?,DueDate?,SalesRepRef?,FOB?,ShipDate?,ShipMethodRef?,ItemSalesTaxRef?,Memo?, CustomerMsgRef?,IsToBePrinted?,CustomerSalesTaxCodeRef?,((InvoiceLineMod|InvoiceLineGroupMod))*)' -- error at line 7, column 687 in XML data. 20061101.094242 I 644 MsgSetHandler Parser error, finishing. 20061101.094242 I 644 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 3892), ret = 1. 20061101.094242 E 3892 RequestProcessor Process Request error = 80042500, There was an error when parsing the provided XML file. 20061101.094242 I 644 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 3892). 20061101.094242 E 644 XercesSAXErrorHandler Element 'TxnDate' is not valid for content model: '(TxnID,EditSequence,CustomerRef?,ClassRef?,ARAccountRef?,TemplateRef?,TxnDate?,RefNumber?,BillAddress?,ShipAddress?, IsPending?,PONumber?,TermsRef?,DueDate?,SalesRepRef?,FOB?,ShipDate?,ShipMethodRef?,ItemSalesTaxRef?,Memo?, CustomerMsgRef?,IsToBePrinted?,CustomerSalesTaxCodeRef?,((InvoiceLineMod|InvoiceLineGroupMod))*)' -- error at line 7, column 687 in XML data. 20061101.094242 I 644 MsgSetHandler Parser error, finishing. 20061101.094242 I 644 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 3892), ret = 1. 20061101.094242 E 3892 RequestProcessor Process Request error = 80042500, There was an error when parsing the provided XML file.
Error: (Worked in version 6) INSERT INTO InvoiceLine (TxnID, TermsRefFullName, InvoiceLineDesc, FQSaveToCache) VALUES ('4346-1071520492', 'Due on receipt', 'Test', 0 )
2006-11-01 09:44:44 QODBC Ver: 7.00.00.194 ********************************************************************************************************************* IsAService: False SQL Statement: INSERT INTO InvoiceLine (TxnID, TermsRefFullName, InvoiceLineDesc, FQSaveToCache) VALUES ('4346-1071520492', 'Due on receipt', 'Test', 0 )
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 = "includeNone"> <InvoiceModRq requestID = "1"> <InvoiceMod> <TxnID>4346-1071520492</TxnID> <EditSequence>1197729745</EditSequence> <InvoiceLineMod> <TxnLineID>4348-1071520492</TxnLineID> </InvoiceLineMod> <InvoiceLineMod> <TxnLineID>4349-1071520492</TxnLineID> </InvoiceLineMod> <InvoiceLineMod> <TxnLineID>434A-1071520492</TxnLineID> </InvoiceLineMod> <InvoiceLineMod> <TxnLineID>5BEC-1071520492</TxnLineID> </InvoiceLineMod> <InvoiceLineMod> <TxnLineID>5BED-1071520492</TxnLineID> </InvoiceLineMod> <InvoiceLineMod> <TxnLineID>5BEE-1071520492</TxnLineID> </InvoiceLineMod> <InvoiceLineMod> <TxnLineID>5BEF-1071520492</TxnLineID> </InvoiceLineMod> <TermsRef> <FullName>Due on receipt</FullName> </TermsRef> <InvoiceLineMod> <TxnLineID>-1</TxnLineID> <Desc>Test</Desc> </InvoiceLineMod> </InvoiceMod> </InvoiceModRq> </QBXMLMsgsRq> </QBXML>
20061101.094443 I 644 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 3892). 20061101.094443 I 644 SpecVersion Current version of qbXML in use: 5.0 20061101.094443 I 644 QBSDKMsgSetHandler QUERY: Invoice 20061101.094443 I 644 QBSDKMsgSetHandler Request 1 completed successfully. 20061101.094443 I 644 MsgSetHandler Finished. 20061101.094443 I 644 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 3892), ret = 0. 20061101.094443 I 644 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 3892). 20061101.094443 E 644 XercesSAXErrorHandler Element 'TermsRef' is not valid for content model: '(TxnID,EditSequence,CustomerRef?,ClassRef?,ARAccountRef?,TemplateRef?,TxnDate?,RefNumber?,BillAddress?,ShipAddress?, IsPending?,PONumber?,TermsRef?,DueDate?,SalesRepRef?,FOB?,ShipDate?,ShipMethodRef?,ItemSalesTaxRef?,Memo?, CustomerMsgRef?,IsToBePrinted?,CustomerSalesTaxCodeRef?,((InvoiceLineMod|InvoiceLineGroupMod))*)' -- error at line 7, column 714 in XML data. 20061101.094443 I 644 MsgSetHandler Parser error, finishing. 20061101.094443 I 644 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 3892), ret = 1. 20061101.094443 E 3892 RequestProcessor Process Request error = 80042500, There was an error when parsing the provided XML file. 20061101.094444 I 644 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 3892). 20061101.094444 E 644 XercesSAXErrorHandler Element 'TermsRef' is not valid for content model: '(TxnID,EditSequence,CustomerRef?,ClassRef?,ARAccountRef?,TemplateRef?,TxnDate?,RefNumber?,BillAddress?,ShipAddress?, IsPending?,PONumber?,TermsRef?,DueDate?,SalesRepRef?,FOB?,ShipDate?,ShipMethodRef?,ItemSalesTaxRef?,Memo?, CustomerMsgRef?,IsToBePrinted?,CustomerSalesTaxCodeRef?,((InvoiceLineMod|InvoiceLineGroupMod))*)' -- error at line 7, column 714 in XML data. 20061101.094444 I 644 MsgSetHandler Parser error, finishing. 20061101.094444 I 644 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 3892), ret = 1. 20061101.094444 E 3892 RequestProcessor Process Request error = 80042500, There was an error when parsing the provided XML file. 20061101.094444 I 644 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 3892). 20061101.094444 E 644 XercesSAXErrorHandler Element 'TermsRef' is not valid for content model: '(TxnID,EditSequence,CustomerRef?,ClassRef?,ARAccountRef?,TemplateRef?,TxnDate?,RefNumber?,BillAddress?,ShipAddress?, IsPending?,PONumber?,TermsRef?,DueDate?,SalesRepRef?,FOB?,ShipDate?,ShipMethodRef?,ItemSalesTaxRef?,Memo?, CustomerMsgRef?,IsToBePrinted?,CustomerSalesTaxCodeRef?,((InvoiceLineMod|InvoiceLineGroupMod))*)' -- error at line 7, column 714 in XML data. 20061101.094444 I 644 MsgSetHandler Parser error, finishing. 20061101.094444 I 644 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 3892), ret = 1. 20061101.094444 E 3892 RequestProcessor Process Request error = 80042500, There was an error when parsing the provided XML file. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-11-02 11:23:27 |
When you do:
INSERT INTO InvoiceLine (TxnID, InvoiceLineDesc, FQSaveToCache) VALUES ('4346-1071520492', 'Test', 0 )
using a TxnID you are adding invoice lines to an existing invoice that already has the TxnDate and TermsRefFullName written in the header Invoice record. When using QODBC v7, you can only insert additional lines to the InvoiceLine table using line values only. You can't write header values. Any changes to an existing Invoice header detail needs to by done using UPDATEs. |
|
|
|
|