I have also received the same error using v 7.00.00.207 with QB Enterprise 6.0.
The following query randomly fails with the 42S00 error.
Select EstimateLine.*,Item.Type from EstimateLine left outer JOIN Item ON EstimateLine.EstimateLineItemRefListID = Item.ListID where txnId ='2844-1197764203' order by EstimateLineSeqNo, EstimateLineGroupSeqNo
Sometime it works and sometimes it doesn't.
Here is the qodbc message log:
2007-02-20 16:19:16 QODBC Ver: 7.00.00.207 ********************************************************************************************************************* IsAService: True SQL Statement: Select EstimateLine.*,Item.Type from EstimateLine left outer JOIN Item ON EstimateLine.EstimateLineItemRefListID = Item.ListID where txnId = '2844-1197764203' order by EstimateLineSeqNo, EstimateLineGroupSeqNo Error Getting XML in BuildAndLoadXMLForNextRecord Input XML: <?xml version="1.0" encoding="ISO-8859-1"?> <?qbxml version="5.0"?> <QBXML> <QBXMLMsgsRq onError="continueOnError"> <ItemQueryRq requestID="1"> <ListID></ListID> <IncludeRetElement>ListID</IncludeRetElement> <IncludeRetElement>EditSequence</IncludeRetElement> <IncludeRetElement>SalesTaxCodeRef</IncludeRetElement> <OwnerID>0</OwnerID> </ItemQueryRq> </QBXMLMsgsRq> </QBXML> |