AnsweredAssumed Answered

Error starting an advanced workflow

Question asked by fogo on Oct 10, 2007
Latest reply on Oct 15, 2007 by fogo
I'm running alfresco out of the box on a sybase database. When trying to start an advanced workflow I get his error:

   * A system error happened during the operation: could not insert: [org.jbpm.graph.exe.ProcessInstance]; nested exception is org.hibernate.exception.ConstraintViolationException: could not insert: [org.jbpm.graph.exe.ProcessInstance]

Caused by: com.sybase.jdbc2.jdbc.SybSQLException: SQL Anywhere Error -195: Column 'KEY_' in table 'JBPM_PROCESSINSTANCE' cannot be NULL

The hibernate script for generating this table is create table JBPM_PROCESSINSTANCE ( ID_ numeric(19,0) identity not null, VERSION_ int not null, KEY_ varchar(255) null, START_ datetime null, END_ datetime null, ISSUSPENDED_ tinyint null, PROCESSDEFINITION_ numeric(19,0) null, ROOTTOKEN_ numeric(19,0) null, SUPERPROCESSTOKEN_ numeric(19,0) null, primary key (ID_), unique (KEY_, PROCESSDEFINITION_) )