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.
Thank you Stefan Helzle I was not aware Appian does not change the Tables. That fixed my issue.
Appian will NEVER delete any structural data from DB and only add things. E.g. renaming a field in CDT will create a new field in DB and leave the old one.