Populate Build Assemblies From Quickbooks

[kentmParticipant]

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?

[Yudel RosalesStaff]

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

[kentmParticipant]

I am running 3.0.16

[kentmParticipant]

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?

[Yudel RosalesStaff]

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

[robert6Participant]

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

[Yudel RosalesStaff]

We are working on it. Sorry for the inconveniences.

[Yudel RosalesStaff]

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

[Author]

Posts