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

lesliem over 9 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 Aleksi White
Appian Employee
over 9 years ago

To get a better idea of what is going on, we can increase the logging to DEBUG for this error. Please do the following:

1) In <APPIAN_HOME>/ear|runtime_ear/suite.ear/resources/appian_log4j.properties, add the following two lines:
log4j.logger.org.hibernate.SQL=DEBUG
log4j.logger.org.hibernate.type=TRACE

2) Wait a few minutes for the properties to be picked up

3) Recreate the error and attach the application-server.log
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Aleksi White
Appian Employee
over 9 years ago

To get a better idea of what is going on, we can increase the logging to DEBUG for this error. Please do the following:

1) In <APPIAN_HOME>/ear|runtime_ear/suite.ear/resources/appian_log4j.properties, add the following two lines:
log4j.logger.org.hibernate.SQL=DEBUG
log4j.logger.org.hibernate.type=TRACE

2) Wait a few minutes for the properties to be picked up

3) Recreate the error and attach the application-server.log
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data