OpenSync

Home Forums OpenSync Violation of PRIMARY KEY constraint

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

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #63523

    tiger1
    Participant

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

    Cant perform a task due to the about error.
    I rebuild and verify the data in QB there was no problem with database.

    Please advise.

    #63976

    scottjasperse
    Participant

    I have the same issue has there been any resolution? I have run a rebuilt on my QB data with no errors shown.

    Attachments:
    You must be logged in to view attached files.
    #64005

    you have to remove the primary key and the primary key index from buildassembly table. Sorry for the inconveniences.

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

You must be logged in to reply to this topic.