I have a process that deletes records using the "Delete from Data Store Ent

lesliem over 10 years ago

I have a process that deletes records using the "Delete from Data Store Entities Smart Service". If I delete 1 record from the CDT there is no issue, but if I delete multiple records I get an error
Details: An error occurred while trying to delete data. No data was deleted. Details: org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1. (APNX-1-4212-000)

It appears that record is deleted and then rolled back. But once the record is rolled back I can go back to the workflow and delete that record individually without an error.

Does anyone know why I am getting this behavior and how to fix it? Thanks...

Discussion posts and replies are publicly visible

Parents

0 lesliem over 10 years ago

The error says no data was deleted but in this instance both records were deleted. In other instances it deletes both records and then rolls back one of the records. If you only delete 1 record it gets no errors and the record is deleted.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 lesliem over 10 years ago

The error says no data was deleted but in this instance both records were deleted. In other instances it deletes both records and then rolls back one of the records. If you only delete 1 record it gets no errors and the record is deleted.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data