Uploaded image for project: 'Red Hat Fuse'
  1. Red Hat Fuse
  2. ENTESB-5185

BPEL - Domain mode - Postgres DB - Unable to deploy quickstart

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Out of Date
    • Affects Version/s: jboss-fuse-6.3
    • Fix Version/s: fuse-7.0
    • Component/s: SwitchYard
    • Labels:
      None

      Description

      It is not possible to deploy SwitchYard BPEL application to EAP in domain mode if you use Postres DB. I will attach server log.

      [Server:server-one] 11:22:58,982 ERROR [org.apache.ode.store.ProcessStoreImpl] (ProcessStoreImpl-1) Error persisting deployment record for {http://www.jboss.org/bpel/examples}SayHello-0; process will not be available after restart!: javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute statement
      [Server:server-one] 	at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387)
      [Server:server-one] 	at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310)
      [Server:server-one] 	at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1316)
      [Server:server-one] 	at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:881)
      [Server:server-one] 	at org.apache.ode.dao.jpa.store.ConfStoreDAOConnectionImpl.setVersion(ConfStoreDAOConnectionImpl.java:95) [riftsaw-dao-jpa-3.2.0.Final-redhat-4.jar:3.2.0.Final-redhat-4]
      [Server:server-one] 	at org.apache.ode.store.ProcessStoreImpl$2.call(ProcessStoreImpl.java:301) [riftsaw-bpel-store-3.2.0.Final-redhat-4.jar:3.2.2.Final-redhat-5]
      [Server:server-one] 	at org.apache.ode.store.ProcessStoreImpl$2.call(ProcessStoreImpl.java:271) [riftsaw-bpel-store-3.2.0.Final-redhat-4.jar:3.2.2.Final-redhat-5]
      [Server:server-one] 	at org.apache.ode.store.ProcessStoreImpl$Callable.call(ProcessStoreImpl.java:886) [riftsaw-bpel-store-3.2.0.Final-redhat-4.jar:3.2.2.Final-redhat-5]
      [Server:server-one] 	at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_74]
      [Server:server-one] 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_74]
      [Server:server-one] 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_74]
      [Server:server-one] 	at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_74]
      [Server:server-one] Caused by: org.hibernate.exception.ConstraintViolationException: could not execute statement
      [Server:server-one] 	at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:129)
      [Server:server-one] 	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
      [Server:server-one] 	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:124)
      [Server:server-one] 	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)
      [Server:server-one] 	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:189)
      [Server:server-one] 	at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:96)
      [Server:server-one] 	at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:58)
      [Server:server-one] 	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2987)
      [Server:server-one] 	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3499)
      [Server:server-one] 	at org.hibernate.action.internal.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:81)
      [Server:server-one] 	at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:395)
      [Server:server-one] 	at org.hibernate.engine.spi.ActionQueue.addResolvedEntityInsertAction(ActionQueue.java:229)
      [Server:server-one] 	at org.hibernate.engine.spi.ActionQueue.addInsertAction(ActionQueue.java:209)
      [Server:server-one] 	at org.hibernate.engine.spi.ActionQueue.addAction(ActionQueue.java:193)
      [Server:server-one] 	at org.hibernate.event.internal.AbstractSaveEventListener.addInsertAction(AbstractSaveEventListener.java:321)
      [Server:server-one] 	at org.hibernate.event.internal.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:286)
      [Server:server-one] 	at org.hibernate.event.internal.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:192)
      [Server:server-one] 	at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:125)
      [Server:server-one] 	at org.hibernate.ejb.event.EJB3PersistEventListener.saveWithGeneratedId(EJB3PersistEventListener.java:78)
      [Server:server-one] 	at org.hibernate.event.internal.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:208)
      [Server:server-one] 	at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:151)
      [Server:server-one] 	at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:78)
      [Server:server-one] 	at org.hibernate.internal.SessionImpl.firePersist(SessionImpl.java:772)
      [Server:server-one] 	at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:746)
      [Server:server-one] 	at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:750)
      [Server:server-one] 	at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:875)
      [Server:server-one] 	... 8 more
      [Server:server-one] Caused by: org.postgresql.util.PSQLException: ERROR: null value in column "id" violates not-null constraint
      [Server:server-one]   Detail: Failing row contains (null, 0).
      [Server:server-one] 	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270)
      [Server:server-one] 	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1998)
      [Server:server-one] 	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
      [Server:server-one] 	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:570)
      [Server:server-one] 	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:420)
      [Server:server-one] 	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:366)
      [Server:server-one] 	at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:493)
      [Server:server-one] 	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:186)
      [Server:server-one] 	... 29 more
      

      I also tried to use MySQL database. Quickstart works but server log contains a lot of errors.
      https://gist.github.com/basovnik/ade659e3fe9b9c43e6ae

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  tcunning tcunning
                  Reporter:
                  mbasovni Martin Basovnik
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: