Home Forums OpenSync Populate Build Assemblies From Quickbooks

This topic contains 7 replies, has 3 voices, and was last updated by  Yudel Rosales 12 months ago.

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


    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?


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



    I am running 3.0.16



    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?


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



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


    We are working on it. Sorry for the inconveniences.


    We are still working on this matter. In the meantime you can remove the primary key from your database. Sorry for the inconveniences.

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

You must be logged in to reply to this topic.