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
  • #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.

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

You must be logged in to reply to this topic.