Uploaded image for project: 'jBPM'
  1. jBPM
  2. JBPM-4041

Unable to start process - NULL not allowed for column "PK

XMLWordPrintable

    • Icon: Feature Request Feature Request
    • Resolution: Obsolete
    • Icon: Blocker Blocker
    • jBPM 6.0.0.CR1
    • None
    • Human Task Service
    • None

      Hi,

      I have the following error when trying to start the 'Hiring' process (see stacktrace below). I am using file based H2 datasource and EAP 6.1.

      ----------------------

      11:45:12,082 ERROR [stderr] (http-/0.0.0.0:8080-1) Caused by: org.hibernate.exception.ConstraintViolationException: could not execute statement
      11:45:12,082 ERROR [stderr] (http-/0.0.0.0:8080-1) at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:128)
      11:45:12,082 ERROR [stderr] (http-/0.0.0.0:8080-1) at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
      11:45:12,083 ERROR [stderr] (http-/0.0.0.0:8080-1) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
      11:45:12,083 ERROR [stderr] (http-/0.0.0.0:8080-1) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
      11:45:12,083 ERROR [stderr] (http-/0.0.0.0:8080-1) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:136)
      11:45:12,083 ERROR [stderr] (http-/0.0.0.0:8080-1) at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:96)
      11:45:12,084 ERROR [stderr] (http-/0.0.0.0:8080-1) at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:58)
      11:45:12,084 ERROR [stderr] (http-/0.0.0.0:8080-1) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2966)
      11:45:12,084 ERROR [stderr] (http-/0.0.0.0:8080-1) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3477)
      11:45:12,084 ERROR [stderr] (http-/0.0.0.0:8080-1) at org.hibernate.action.internal.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:81)
      11:45:12,085 ERROR [stderr] (http-/0.0.0.0:8080-1) at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:362)
      11:45:12,085 ERROR [stderr] (http-/0.0.0.0:8080-1) at org.hibernate.engine.spi.ActionQueue.addResolvedEntityInsertAction(ActionQueue.java:203)
      11:45:12,086 ERROR [stderr] (http-/0.0.0.0:8080-1) at org.hibernate.engine.spi.ActionQueue.addInsertAction(ActionQueue.java:183)
      11:45:12,086 ERROR [stderr] (http-/0.0.0.0:8080-1) at org.hibernate.engine.spi.ActionQueue.addAction(ActionQueue.java:167)
      11:45:12,086 ERROR [stderr] (http-/0.0.0.0:8080-1) at org.hibernate.event.internal.AbstractSaveEventListener.addInsertAction(AbstractSaveEventListener.java:321)
      11:45:12,086 ERROR [stderr] (http-/0.0.0.0:8080-1) at org.hibernate.event.internal.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:286)
      11:45:12,087 ERROR [stderr] (http-/0.0.0.0:8080-1) at org.hibernate.event.internal.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:192)
      11:45:12,087 ERROR [stderr] (http-/0.0.0.0:8080-1) at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:125)
      11:45:12,087 ERROR [stderr] (http-/0.0.0.0:8080-1) at org.hibernate.ejb.event.EJB3PersistEventListener.saveWithGeneratedId(EJB3PersistEventListener.java:78)
      11:45:12,087 ERROR [stderr] (http-/0.0.0.0:8080-1) at org.hibernate.event.internal.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:208)
      11:45:12,087 ERROR [stderr] (http-/0.0.0.0:8080-1) at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:151)
      11:45:12,088 ERROR [stderr] (http-/0.0.0.0:8080-1) at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:78)
      11:45:12,088 ERROR [stderr] (http-/0.0.0.0:8080-1) at org.hibernate.internal.SessionImpl.firePersist(SessionImpl.java:852)
      11:45:12,088 ERROR [stderr] (http-/0.0.0.0:8080-1) at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:826)
      11:45:12,088 ERROR [stderr] (http-/0.0.0.0:8080-1) at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:830)
      11:45:12,088 ERROR [stderr] (http-/0.0.0.0:8080-1) at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:875)
      11:45:12,089 ERROR [stderr] (http-/0.0.0.0:8080-1) ... 64 more
      11:45:12,089 ERROR [stderr] (http-/0.0.0.0:8080-1) Caused by: org.h2.jdbc.JdbcSQLException: La columna "PK" no permite valores nulos (NULL)
      11:45:12,090 ERROR [stderr] (http-/0.0.0.0:8080-1) NULL not allowed for column "PK"; SQL statement:
      11:45:12,090 ERROR [stderr] (http-/0.0.0.0:8080-1) insert into ProcessInstanceLog (id, duration, end_date, externalId, user_identity, outcome, parentProcessInstanceId, processId, processInstanceId, processName, processVersion, start_date, status) values (null, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [23502-168]
      11:45:12,090 ERROR [stderr] (http-/0.0.0.0:8080-1) at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
      11:45:12,090 ERROR [stderr] (http-/0.0.0.0:8080-1) at org.h2.message.DbException.get(DbException.java:169)
      11:45:12,090 ERROR [stderr] (http-/0.0.0.0:8080-1) at org.h2.message.DbException.get(DbException.java:146)
      11:45:12,091 ERROR [stderr] (http-/0.0.0.0:8080-1) at org.h2.table.Column.validateConvertUpdateSequence(Column.java:293)
      11:45:12,091 ERROR [stderr] (http-/0.0.0.0:8080-1) at org.h2.table.Table.validateConvertUpdateSequence(Table.java:689)
      11:45:12,091 ERROR [stderr] (http-/0.0.0.0:8080-1) at org.h2.command.dml.Insert.insertRows(Insert.java:120)
      11:45:12,091 ERROR [stderr] (http-/0.0.0.0:8080-1) at org.h2.command.dml.Insert.update(Insert.java:84)
      11:45:12,091 ERROR [stderr] (http-/0.0.0.0:8080-1) at org.h2.command.CommandContainer.update(CommandContainer.java:75)
      11:45:12,092 ERROR [stderr] (http-/0.0.0.0:8080-1) at org.h2.command.Command.executeUpdate(Command.java:230)
      11:45:12,092 ERROR [stderr] (http-/0.0.0.0:8080-1) at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:156)
      11:45:12,092 ERROR [stderr] (http-/0.0.0.0:8080-1) at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:142)
      11:45:12,092 ERROR [stderr] (http-/0.0.0.0:8080-1) at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:493)
      11:45:12,092 ERROR [stderr] (http-/0.0.0.0:8080-1) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:133)
      11:45:12,093 ERROR [stderr] (http-/0.0.0.0:8080-1) ... 85 more
      11:45:12,093 ERROR [stderr] (http-/0.0.0.0:8080-1) *** Message delivery failure ***

              kverlaen@redhat.com Kris Verlaenen
              pzapataf@redhat.com Pedro Zapata Fernandez
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: