Method Community

 

Method Crash after QB Rebuild

Last post 03-15-2011 11:42 AM by Method_Michael. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 03-15-2011 10:07 AM

    Method Crash after QB Rebuild

    We had to rebuild our QB file yesterday after having login issues. At least one Changes synch completed after the rebuild (12:18 pm) and we shut down the Method engine at that point so that it wouldn't impair QB performance on that system. We restarted Method at approximately 5:00 pm, but at some point after 6:00 pm (the last time it was checked, and showed running), the Method Engine crashed and threw a Windows error.

    The Conflicts Log shows the following:

    There was an issue with the sync. Try doing a File > Utilities > Verifiy and Rebuild in QuickBooks, and trying again. Also, make sure QuickBooks has all updates installed. If this persists, contact technical support.
    Now for the technical stuff! QuickBooks SDK response was: There has been an internal error when processing the request.
    The request was: <?xml version="1.0" ?> <?qbxml version="8.0"?> <QBXML> <QBXMLMsgsRq onError = "stopOnError"> <InvoiceQueryRq requestID = "0"> <ModifiedDateRangeFilter><FromModifiedDate>2011-03-14T12:18:48-07:00</FromModifiedDate></ModifiedDateRangeFilter> <IncludeRetElement>TxnID</IncludeRetElement> <IncludeRetElement>TimeModified</IncludeRetElement> <IncludeRetElement>TxnDate</IncludeRetElement> </InvoiceQueryRq> </QBXMLMsgsRq> </QBXML>
    The response was: <?xml version="1.0" ?> <QBXML> <QBXMLMsgsRs> <InvoiceQueryRs requestID="0" statusCode="1000" statusSeverity="Error" statusMessage="There has been an internal error when processing the request."> <InvoiceRet> <TxnID>1AB-1136407708</TxnID> <TimeModified>2011-03-14T13:00:36-07:00</TimeModified> <TxnDate>2006-01-04</TxnDate> </InvoiceRet> <InvoiceRet> <TxnID>318-1136579878</TxnID> <TimeModified>2011-03-14T13:00:37-07:00</TimeModified> <TxnDate>2006-01-06</TxnDate> </InvoiceRet> <InvoiceRet> <TxnID>47F-1136847138</TxnID> <TimeModified>2011-03-14T13:00:39-07:00</TimeModified> <TxnDate>2006-01-09</TxnDate> </InvoiceRet> <InvoiceRet> <TxnID>49E-1136848591</TxnID>

    (plus another dozen or so transactions)

     

    What caused the crash, and prevented the synchs from 'clearing out' overnight? We're concerned that the QB Rebuild caused all the record timestamps to be changed, which in our experience may mean that the synchs will be grinding away for the next two days - and slowing down regular QB use while doing so.

    Thanks..

  • 03-15-2011 11:42 AM In reply to

    Re: Method Crash after QB Rebuild

    Answer

    Lee,

    I exported my Customer table and took a look at the TimeModifiedAccounting field and then rebuilt by QuickBooks file and performed a full Sync and then exported the Customer Table again. The TimeModifiedAccounting field did not change but in my case my file wasn't corrupt so I can't say for certain if the same will apply to you. There's a chance that your QuickBooks Company file my still have some issues, try doing a Rebuild again or a Verify.

    Based on this:

    <?xml version="1.0" ?> <?qbxml version="8.0"?> <QBXML> <QBXMLMsgsRq onError = "stopOnError"> <InvoiceQueryRq requestID = "0"> <ModifiedDateRangeFilter><FromModifiedDate>2011-03-14T12:18:48-07:00</FromModifiedDate></ModifiedDateRangeFilter> <IncludeRetElement>TxnID</IncludeRetElement> <IncludeRetElement>TimeModified</IncludeRetElement> <IncludeRetElement>TxnDate</IncludeRetElement> </InvoiceQueryRq> </QBXMLMsgsRq> </QBXML>

    It looks like Method was trying to request a listed of invoices that were modified after a certain date but QuickBooks returned an error below:

    <?xml version="1.0" ?> <QBXML> <QBXMLMsgsRs> <InvoiceQueryRs requestID="0" statusCode="1000" statusSeverity="Error" statusMessage="There has been an internal error when processing the request."> <InvoiceRet> <TxnID>1AB-1136407708</TxnID> <TimeModified>2011-03-14T13:00:36-07:00</TimeModified> <TxnDate>2006-01-04</TxnDate> </InvoiceRet> <InvoiceRet> <TxnID>318-1136579878</TxnID> <TimeModified>2011-03-14T13:00:37-07:00</TimeModified> <TxnDate>2006-01-06</TxnDate> </InvoiceRet> <InvoiceRet> <TxnID>47F-1136847138</TxnID> <TimeModified>2011-03-14T13:00:39-07:00</TimeModified> <TxnDate>2006-01-09</TxnDate> </InvoiceRet> <InvoiceRet> <TxnID>49E-1136848591</TxnID>

    -Michael

    Michael Melo
    Product Manager
    Method Integration Inc.
    Website: http://www.method.me
    LinkedIn: http://www.linkedin.com/in/MichaelMelo
Page 1 of 1 (2 items)