OpenSync

Home Forums OpenSync Populate Build Assemblies From Quickbooks

This topic contains 6 replies, has 3 voices, and was last updated by  Yudel Rosales 1 week, 2 days ago.

Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • #27621

    kentm
    Participant

    When I populate the Build assemblies table from Quickbooks, I keep getting this error.

    Failed: Violation of PRIMARY KEY constraint ‘PK_buildassembly’. Cannot insert duplicate key in object ‘dbo.buildassembly’. The duplicate key value is (5EB3-1230830875).: componentitemline in table buildassembly:-2147217873

    I deleted it out and tried again, and then it fails on the next record. If I look in the componentlineitemdetail the records are all duplicated. I deleted 4 records and keep getting this error. So I think it is more than just a bad record in Quickbooks?
    How do I prevent this error from happening?

    #62323

    Which version of OpenSync are you using? Can you post your log files please?

    #62354

    kentm
    Participant

    I am running 3.0.16

    #62355

    kentm
    Participant

    I already posted the error in the logs that I am receiving. Looks like the logs will not post here, can I send them to you another method?

    #62360

    yes, on the main windows go to Help->Send Diagnostics. This option will send the log files to me.
    Thanks

    #62407

    robert6
    Participant

    What’s the status of this. I get the same error.

    #62408

    We are working on it. Sorry for the inconveniences.

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

You must be logged in to reply to this topic.