Discussions

Expand all | Collapse all

"Attempting to add a non-unique value to a field marked "unique" error on a QB Connected Table

  • 1.  "Attempting to add a non-unique value to a field marked "unique" error on a QB Connected Table

    Posted 14 days ago
    My connected table has been erroring out on the hourly table refreshes due to the following error:

     The error was: Trying to add a non-unique value to a field marked unique - Your import data has duplicate values for the following unique fields Field name: "

    I was able to verify that the field in question does not have any duplicate values in both the source and destination table. In addition, the destination table already has the records in question within the table, so if anything, the records should be updated but there shouldn't be an error on the refresh. 

    Has anyone else dealt with a similar issue? Not certain of what next steps to try aside from reaching out to QB Support.

    ------------------------------
    Niraj Shah
    ------------------------------


  • 2.  RE: "Attempting to add a non-unique value to a field marked "unique" error on a QB Connected Table

    Posted 14 days ago
    Is the same field unique in both the origin table and the synced table? Or is the unique field only in the synced table?

    If only in the synced table, check to see if there are multiple blank entries that are trying to sync. A duplicate blank will register as non-unique.

    ------------------------------
    Mike Tamoush
    ------------------------------



  • 3.  RE: "Attempting to add a non-unique value to a field marked "unique" error on a QB Connected Table

    Posted 13 days ago
    Hi Mike,

    Yes. The same field is unique and required in both the origin and synced table. 

    I submitted a support ticket to QB and they couldn't figure out the issue either and are escalating the ticket.