topic Error starting an advanced workflow in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/error-starting-an-advanced-workflow/m-p/120194#M84707 <HTML><HEAD></HEAD><BODY><SPAN>I'm running alfresco out of the box on a sybase database. When trying to start an advanced workflow I get his error:</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp; </SPAN><EM> * 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]<BR /><BR />Caused by: com.sybase.jdbc2.jdbc.SybSQLException: SQL Anywhere Error -195: Column 'KEY_' in table 'JBPM_PROCESSINSTANCE' cannot be NULL</EM><BR /><BR /><SPAN>The hibernate script for generating this table is create table </SPAN><STRONG>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_) )</STRONG></BODY></HTML> Wed, 10 Oct 2007 08:29:31 GMT fogo 2007-10-10T08:29:31Z Error starting an advanced workflow https://connect.hyland.com/t5/alfresco-archive/error-starting-an-advanced-workflow/m-p/120194#M84707 I'm running alfresco out of the box on a sybase database. When trying to start an advanced workflow I get his error:&nbsp;&nbsp; * A system error happened during the operation: could not insert: [org.jbpm.graph.exe.ProcessInstance]; nested exception is org.hibernate.exception.ConstraintViolationException: co Wed, 10 Oct 2007 08:29:31 GMT https://connect.hyland.com/t5/alfresco-archive/error-starting-an-advanced-workflow/m-p/120194#M84707 fogo 2007-10-10T08:29:31Z Re: Error starting an advanced workflow https://connect.hyland.com/t5/alfresco-archive/error-starting-an-advanced-workflow/m-p/120195#M84708 <HTML><HEAD></HEAD><BODY><SPAN>So.</SPAN><BR /><BR /><SPAN>Has anyone managed to successfully run Alfresco on Sybase and been able to create advanced work flows?</SPAN><BR /><BR /><SPAN>If so please share your creation script for the JBPM_PROCESSINSTANCE table.</SPAN></BODY></HTML> Sun, 14 Oct 2007 23:06:45 GMT https://connect.hyland.com/t5/alfresco-archive/error-starting-an-advanced-workflow/m-p/120195#M84708 fogo 2007-10-14T23:06:45Z Re: Error starting an advanced workflow https://connect.hyland.com/t5/alfresco-archive/error-starting-an-advanced-workflow/m-p/120196#M84709 <HTML><HEAD></HEAD><BODY><SPAN>For anyone else experiencing this problem, it seems related to </SPAN><A href="http://jira.jboss.com/jira/browse/JBPM-913" rel="nofollow noopener noreferrer">http://jira.jboss.com/jira/browse/JBPM-913</A></BODY></HTML> Mon, 15 Oct 2007 02:31:28 GMT https://connect.hyland.com/t5/alfresco-archive/error-starting-an-advanced-workflow/m-p/120196#M84709 fogo 2007-10-15T02:31:28Z