Editing a Teaming / Vibe Workflow fails

  • 7007466
  • 05-Jan-2011
  • 27-Apr-2012

Environment

Novell Teaming 2.1
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

Resolution

Execute the following SQL to remove all rows from the JBPM_LOG table:

UPDATE JBPM_LOG SET PARENT_=null;
DELETE FROM JBPM_LOG;

Feedback service temporarily unavailable. For content questions or problems, please contact Support.