Hello All,
Facing an issue while deleting the data from the Data Store entity, we are using "Delete from Data Store Entities" smart service in the process model to delete the data.
Error: An error occurred while trying to delete data. No data was deleted. Details: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute statement
Entity and pid of the entity is passed correctly.
Appian Version: 23.4.265.0
Please advise if anyone faced this issue earlier and how to resolve.
Thanks
Discussion posts and replies are publicly visible
Issue is resolved, it's caused due to the error in corresponding table trigger.