Environment
Novell Teaming 2.1
Novell Vibe 3.x
Novell Vibe 3.x
Situation
When modifying a workflow definition which is associated with one or more entries, deleting or modifying a state and/or transition may fail with one of the the following errors:
Definition with this name already exists
Invalid data entered or data too long
The above error would cause one of the following errors to be logged in the catalina.out file:
WARN [http-8080-4] [org.hibernate.util.JDBCExceptionReporter] - SQL Error: 2292, SQLState: 23000
ERROR [http-8080-4] [org.hibernate.util.JDBCExceptionReporter] - ORA-02292: integrity constraint (SITESCAPE.FK_LOG_TRANSITION) violated - child record found
OR
WARN [org.hibernate.util.JDBCExceptionReporter] - SQL Error: 1451, SQLState: 23000
ERROR [org.hibernate.util.JDBCExceptionReporter] - Cannot delete or update a parent row: a foreign key constraint fails (`sitescape`.`jbpm_log`, CONSTRAINT `FK_LOG_TRANSITION` FOREIGN KEY (`TRANSITION_`) REFERENCES `jbpm_transition` (`ID_`))
ERROR [org.kablink.teaming.portlet.definitionBuilder.ViewController] - Invalid data entered or data too long
Definition with this name already exists
Invalid data entered or data too long
The above error would cause one of the following errors to be logged in the catalina.out file:
WARN [http-8080-4] [org.hibernate.util.JDBCExceptionReporter] - SQL Error: 2292, SQLState: 23000
ERROR [http-8080-4] [org.hibernate.util.JDBCExceptionReporter] - ORA-02292: integrity constraint (SITESCAPE.FK_LOG_TRANSITION) violated - child record found
OR
WARN [org.hibernate.util.JDBCExceptionReporter] - SQL Error: 1451, SQLState: 23000
ERROR [org.hibernate.util.JDBCExceptionReporter] - Cannot delete or update a parent row: a foreign key constraint fails (`sitescape`.`jbpm_log`, CONSTRAINT `FK_LOG_TRANSITION` FOREIGN KEY (`TRANSITION_`) REFERENCES `jbpm_transition` (`ID_`))
ERROR [org.kablink.teaming.portlet.definitionBuilder.ViewController] - Invalid data entered or data too long
Resolution
Execute the following SQL to remove all rows from the JBPM_LOG table:
UPDATE JBPM_LOG SET PARENT_=null;
DELETE FROM JBPM_LOG;
UPDATE JBPM_LOG SET PARENT_=null;
DELETE FROM JBPM_LOG;