DB Error deploying the Sample BPEL process
kmecheri Jan 1, 2006 5:29 PMHello
I get the following error while deploying the hello bpel process.
I am running jboss 4.0.2 and jbpm-bpel1.0-alpha3.
[deploypar] 17:19:25,916 DEBUG BpelReader : upgraded bpel document: hello.bpel
[deploypar] 17:19:25,996 INFO BpelReader : read bpel process: hello.bpel
[deploypar] 17:19:26,267 DEBUG ProcessArchiveDeployer : starting transaction to deploy process BpelDefinition(helloWorld)
[deploypar] Hibernate: select processdef0_.ID_ as col_0_0_ from JBPM_PROCESSDEFINITION processdef0_ where processdef0_.NAME_=? order by processdef0_.VERSION_ desc
[deploypar] Hibernate: insert into JBPM_PROCESSDEFINITION (NAME_, VERSION_, ISTERMINATIONIMPLICIT_, STARTSTATE_, TARGETNAMESPACE_, ENABLECOMPENSATION_, EXPRESSIONLANG_, QUERYLANG_, ABSTRACT_, CLASS_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, 'B')
[deploypar] Hibernate: insert into JBPM_NODE (NAME_, PROCESSDEFINITION_, ACTION_, SUPERSTATE_, SUPRJOINFAILURE_, COMPOSITEACTIVITY_, JOINCONDITION_, IMPLICIT_, ISOLATED_, CLASS_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, 'O')
[deploypar] Hibernate: insert into JBPM_NODE (NAME_, PROCESSDEFINITION_, ACTION_, SUPERSTATE_, SUPRJOINFAILURE_, COMPOSITEACTIVITY_, JOINCONDITION_, CLASS_) values (?, ?, ?, ?, ?, ?, ?, 'i')
[deploypar] 17:19:27,799 WARN JDBCExceptionReporter : SQL Error: 2601, SQLState: S1000
[deploypar] 17:19:27,799 ERROR JDBCExceptionReporter : Attempt to insert duplicate key row in object 'JBPM_NODE' with unique index 'JBPM_NODE_WHILE__20007231492'
[deploypar] 17:19:27,799 ERROR GraphSession : org.hibernate.exception.GenericJDBCException: could not insert: [org.jbpm.bpel.def.Sequence]
[deploypar] 17:19:27,869 WARN JbpmSession : can't pop current session: are you calling JbpmSession.close() multiple times ?
[deploypar] java.lang.RuntimeException: couldn't save process definition 'BpelDefinition(helloWorld)'
[deploypar] at org.jbpm.db.GraphSession.saveProcessDefinition(GraphSession.java:35)
[deploypar] at org.jbpm.jpdl.par.ProcessArchiveDeployer.deployProcessDefinition(ProcessArchiveDeployer.java:77)
[deploypar] at org.jbpm.jpdl.par.ProcessArchiveDeployer.deployZipInputStream(ProcessArchiveDeployer.java:47)
[deploypar] at org.jbpm.ant.DeployParTask.deploy(DeployParTask.java:69)
[deploypar] at org.jbpm.ant.DeployParTask.execute(DeployParTask.java:57)
[deploypar] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
[deploypar] at org.apache.tools.ant.Task.perform(Task.java:364)
[deploypar] at org.apache.tools.ant.Target.execute(Target.java:341)
[deploypar] at org.apache.tools.ant.Target.performTasks(Target.java:369)
[deploypar] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
[deploypar] at org.apache.tools.ant.Project.executeTarget(Project.java:1185)
[deploypar] at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:40)
[deploypar] at org.eclipse.ant.internal.ui.antsupport.EclipseDefaultExecutor.executeTargets(EclipseDefaultExecutor.java:32)
[deploypar] at org.apache.tools.ant.Project.executeTargets(Project.java:1068)
[deploypar] at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.run(InternalAntRunner.java:423)
[deploypar] at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.main(InternalAntRunner.java:137)
[deploypar] Caused by: org.hibernate.exception.GenericJDBCException: could not insert: [org.jbpm.bpel.def.Sequence]
[deploypar] at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:82)
[deploypar] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:70)
[deploypar] at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
[deploypar] at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1777)
[deploypar] at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2178)
[deploypar] at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:34)
[deploypar] at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
[deploypar] at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:240)
[deploypar] at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:160)
[deploypar] at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:95)
[deploypar] at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:184)
[deploypar] at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:173)
[deploypar] at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:96)
[deploypar] at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:69)
[deploypar] at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:468)
[deploypar] at org.hibernate.engine.Cascades$5.cascade(Cascades.java:154)
[deploypar] at org.hibernate.engine.Cascades.cascadeAssociation(Cascades.java:771)
[deploypar] at org.hibernate.engine.Cascades.cascade(Cascades.java:720)
[deploypar] at org.hibernate.engine.Cascades.cascade(Cascades.java:847)
[deploypar] at org.hibernate.event.def.AbstractSaveEventListener.cascadeAfterSave(AbstractSaveEventListener.java:363)
[deploypar] at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:265)
[deploypar] at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:160)
[deploypar] at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:95)
[deploypar] at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:184)
[deploypar] at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:173)
[deploypar] at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:96)
[deploypar] at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:69)
[deploypar] at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:468)
[deploypar] at org.hibernate.engine.Cascades$5.cascade(Cascades.java:154)
[deploypar] at org.hibernate.engine.Cascades.cascadeAssociation(Cascades.java:771)
[deploypar] at org.hibernate.engine.Cascades.cascade(Cascades.java:720)
[deploypar] at org.hibernate.engine.Cascades.cascadeCollection(Cascades.java:895)
[deploypar] at org.hibernate.engine.Cascades.cascadeAssociation(Cascades.java:792)
[deploypar] at org.hibernate.engine.Cascades.cascade(Cascades.java:720)
[deploypar] at org.hibernate.engine.Cascades.cascade(Cascades.java:847)
[deploypar] at org.hibernate.event.def.AbstractSaveEventListener.cascadeAfterSave(AbstractSaveEventListener.java:363)
[deploypar] at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:265)
[deploypar] at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:160)
[deploypar] at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:95)
[deploypar] at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:184)
[deploypar] at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
[deploypar] at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:173)
[deploypar] at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
[deploypar] at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:69)
[deploypar] at org.hibernate.impl.SessionImpl.save(SessionImpl.java:481)
[deploypar] at org.hibernate.impl.SessionImpl.save(SessionImpl.java:476)
[deploypar] at org.jbpm.db.GraphSession.saveProcessDefinition(GraphSession.java:31)
[deploypar] ... 15 more
[deploypar] Caused by: java.sql.SQLException: Attempt to insert duplicate key row in object 'JBPM_NODE' with unique index 'JBPM_NODE_WHILE__20007231492'
[deploypar] at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:364)
[deploypar] at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2754)
[deploypar] at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2195)
[deploypar] at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:620)
[deploypar] at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:483)
[deploypar] at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:445)
[deploypar] at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:402)
[deploypar] at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:104)
[deploypar] at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1759)
[deploypar] ... 58 more
BUILD FAILED
C:\bpel_new\doc\examples\hello\build.xml:105: couldn't deploy process archives : couldn't save process definition 'BpelDefinition(helloWorld)'
Total time: 32 seconds