Error: The value for 'Lookup ID' must be unique when updating constituent record

When attempting to update constituent records via a constituent update batch of records that were imported for updates, users may receive the exception "The value for 'Lookup ID' must be unique" for some records.

Article
Number:57787

Products:

Blackbaud_CRM

When the importing the constituents that return this exception into a revenue update batch, they are flagged as duplicates. This could have been manually corrected, but was not. Therefore, instead of updating the record when running the batch committal process, the system tried to insert a new record with the same lookup ID. This failed because of the unique constraint requirement. The reason each constituent was flagged as a duplicate was that the constituent had the SAME lookup ID with a different type code.

Was this article helpful?

Thanks for your feedback! Did this solve your issue?

Comments (optional):

Thanks for your feedback!

We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.

We’re sorry to hear that. Please tell us why.

I don't like how this works.

The answer is confusing.

The answer didn't match what I was searching for.

Additional Comments (optional):

Thanks for your feedback! If you need assistance, click Chat with Support below.