+5I am getting errors on a few pipelines saying it can't add to the table due to duplicate key values; however, these values do not exist in the table. QB support is basically saying this is what sometimes happens in a DB with no solutions.
Today I completely deleted the entire table and ran the pipelines again - the same errors.
+22The upsert may not contain duplicate keys within the upsert set. So yes, those values do not already exists, but that is irrelevant for an upsert. The issue is that the set of record you are trying to upsert has duplicates.
if that is unavoidable, then change your upsert process to just upsert one record at a time. Like:
Prepare a bulk upsert
add upsert row
Commit upsert.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
