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_) )
