Hi,
I'm using a process to Delete records from DSE, but I always end up getting the same issue: "An error occurred while trying to delete data. No data was deleted. Details: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update".
In one of my CDT I was able to fix it by changing the relationship between CDTs to behaviour cascade REFRESH instead of ALL, but its not working with the rest of them.
Any ideas?
Discussion posts and replies are publicly visible
After you modified the CDT, did you re-create the tables? Appian will not remove any constraints automatically.
No I did not! Can you point out how to accomplish that please?
https://docs.appian.com/suite/help/20.3/Custom_Data_Types.html
Go to your DB designer and drop the tables affected by your change.