Populate Build Assemblies From Quickbooks - QuickBooks API / Integration Forums

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

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

Author
Posts
October 21, 2017 at 6:23 am #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?
November 5, 2017 at 10:01 am #62323

Yudel Rosales
Keymaster
Which version of OpenSync are you using? Can you post your log files please?
November 6, 2017 at 6:41 pm #62354

kentm
Participant
I am running 3.0.16
November 6, 2017 at 6:42 pm #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?
November 7, 2017 at 11:05 am #62360

Yudel Rosales
Keymaster
yes, on the main windows go to Help->Send Diagnostics. This option will send the log files to me.
Thanks
November 14, 2017 at 10:30 am #62407

robert6
Participant
What’s the status of this. I get the same error.
November 14, 2017 at 10:53 am #62408

Yudel Rosales
Keymaster
We are working on it. Sorry for the inconveniences.
December 21, 2017 at 9:19 am #62679

Yudel Rosales
Keymaster
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

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

You must be logged in to reply to this topic.

OpenSync