OpenSync

Home Forums OpenSync Sync Failing: Multiple-step OLE DB operation generated errors.

Tagged: 

This topic contains 8 replies, has 2 voices, and was last updated by  Yudel Rosales 2 months, 2 weeks ago.

Viewing 9 posts - 1 through 9 (of 9 total)
  • Author
    Posts
  • #65459

    Andres
    Participant

    Hello,

    Really hoping someone can point me in the right direction here, just paid for premium support here so hoping for at least a suggestion on where to start here within the next 24hrs.

    Our clients who’s infrastructure we manage has an OpenSync task (EstimateByJobReport) that syncs between their MySQL database (updated by a web form) and Quickbooks, it’s been failing for over a month and we’re stuck. I’m not getting a whole lot of information from the logs:

    The CoreObjXDB log provides no additional information. The sync fails somewhere around the 47,000th record out of about 65,000

    We had this happen a while ago and the issue ended up being an Emdash copy pasted into one of the records. We’ve had them look over the records and have not found any Emdashes in their Quickbooks entries.

    From my research it sounds like one of the records either exceeds maximum length of the field, or contains an invalid character (such as an emdash). I don’t know where to start as far as how to query Quickbooks or the MySQL database to check for this.

    Any help would be appreciated.

    #65469

    Yudel Rosales
    Keymaster

    Which version of OpenSync and QuickBooks are you using?

    #65482

    Andres
    Participant

    Opensync 3.0.16
    MySQL Connector/ODBC 5.3
    Quickbooks Enterprise Contractor Edition 17

    Thanks

    #65484

    Andres
    Participant

    Updating to Opensync 3.0.25 seems to have done trick for now, sync successfully completed with no other changed variables that we can see at the moment.

    #65485

    Yudel Rosales
    Keymaster

    Good that you got the latest version. I was about to suggest to do so.

    #65607

    Andres
    Participant

    Same error is now happening again 1 month later. We are still on the latest version of OpenSync receiving the “Multiple-step OLE DB operation generated errors” failure.

    Is there a way that a report or .CSV file can be exported of the records it is trying to copy to the database? That way we could go through the list and find which record might be causing this error without having to go through all of them from within QuickBooks.

    #65610

    Yudel Rosales
    Keymaster

    yes, you can check the trace of populate. That will be abe to save the data.

    #65628

    Andres
    Participant

    Yudel,

    Can you provide any more information on how to get something like this setup? I’m not quite sure what you mean by check the trace of populate.

    #65642

    Yudel Rosales
    Keymaster

    Hello Andres
    When you checked the trace, it will create a file with all the data that was pulled from QB. This file will be created in the same location that the log files. Then you can analyze the data that is been pulled.

Viewing 9 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic.