Details
-
Bug
-
Resolution: Support Request
-
Medium
-
None
-
2.3.3
-
None
-
Tomcat, Windows Server, JDK 1.5
Description
If we attempt to remove a Space and the Space has multiple versions of a template, we get the following error:
Cause:
org.springframework.dao.DataIntegrityViolationException: (Hibernate operation): data integrity violated by SQL ''; nested exception is java.sql.BatchUpdateException: Batch entry 7 delete from PAGETEMPLATES where TEMPLATEID=25 was aborted. Call getNextException to see the cause.
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:93)
caused by: java.sql.BatchUpdateException: Batch entry 7 delete from PAGETEMPLATES where TEMPLATEID=25 was aborted. Call getNextException to see the cause.
at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2497)
We have to manually remove the templates from the DB.