OpenSync

Home Forums OpenSync Violation of PRIMARY KEY constraint 'PK_buildassembly'

This topic contains 27 replies, has 4 voices, and was last updated by  Yudel Rosales 1 year ago.

Viewing 13 posts - 16 through 28 (of 28 total)
  • Author
    Posts
  • #62868

    Jason
    Participant

    We’re running QuickBooks Enterprise Manufacturing and Wholesale 17.

    #62873

    Yudel Rosales
    Keymaster

    Can you create a new database and run the full populate again the new database please.

    thanks

    #62876

    Jason
    Participant

    I literally just did that a few days ago and had exactly the same problem.

    #62877

    Yudel Rosales
    Keymaster

    Can you share your company file with us? So, we can trouble shoot it on house. Let me know please.

    #62880

    Jason
    Participant

    Yes, we can share the company file with you. FYI, it’s 1.20GB.

    How do you want it shared? Dropbox, http://FTP…?

    #62882

    Yudel Rosales
    Keymaster

    Email me to opensync@synergration.com. whichever you prefer.

    #62884

    Jason
    Participant

    Sent you a Google Drive link.

    #62895

    Yudel Rosales
    Keymaster

    We are working on it.
    Best Regards,

    #62901

    Jason
    Participant

    Is there any progress on this? We can’t delay indefinitely.

    #63198

    marius
    Premium Member

    Was this problem resolved?
    I’m having the same issue using QuickBooks Enterprise 2015 and OpenSync 3.0.18.
    Also I’m not sure why the table as primary and unique key for TxnID, primary is unique by default.

    #63228

    Yudel Rosales
    Keymaster

    Unfortunately we haven’t yet. In the mean time can you remove the primary key attribute and the primary key index on the database. And run a full populate.

    #63524

    tiger1
    Participant

    “Unexpected error. Check the “qbsdklog.txt” file for possible additional information.:-2147220478″

    I try to do a task but when reach the “unit of measure” table it stop the tasking and the above message shown on log file then “QuickBooks” got interrupted and shutdown.

    #63545

    Yudel Rosales
    Keymaster

    Run a rebuild/verify on your company file.

Viewing 13 posts - 16 through 28 (of 28 total)

You must be logged in to reply to this topic.