Skip to main content
S
snehay0001
December 22, 2023
Solved

An error occurred while trying to delete data. No data was deleted. Details: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute statement

  • December 22, 2023
  • 1 reply
  • 0 views

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

    Best answer by snehay0001

    Issue is resolved, it's caused due to the error in corresponding table trigger.

    1 reply

    S
    snehay0001AuthorAnswer
    December 22, 2023

    Issue is resolved, it's caused due to the error in corresponding table trigger.

      Terms & ConditionsAccessibility statement