Hello All,
While updating CDT, got below error
An error occurred while trying to write to the entity "SEC_IPOMarginMapping" [id=a6da64a0-8b67-4c95-9eee-0073b364a76c@705410, type=SEC_IPO_Margin_Mapping_List (id=9412)] (data store: SEC Securities DS). Details: javax.persistence.EntityExistsException: A different object with the same identifier value was already associated with the session : [SECIPOMarginMappingListDT22360#2] Data: TypedValue[it=9413, v={array of values}.
The Unique identifier column is set to auto increment.
Please advise.
Regards.
Discussion posts and replies are publicly visible
You're creating a new record with an Id that already exists in the database instead of updating the existing one.When updating data, don't create a new record with an existing Id. Instead, fetch the existing record from the database, change its values, then save it back.
Hi @nirupamaanuragt,
This error means Appian is trying to insert a record that already exists. Ensure your CDT’s ID field is mapped correctly and that you’re passing the existing record’s ID when updating. If handling multiple records, avoid duplicates, and try refreshing the entity before the update.