3 Replies Latest reply on Aug 28, 2017 1:16 PM by Huy Vu quoc

    Configure BPM Suite 6.4 with postgreSQL

    Huy Vu quoc Newbie

      I installed bpm suite v6.4 default with h2 successful. When i configure with postgreSQL(9.5), every thing is OK, so when i create project, form, business process, so i build and deploy, i have error:

      Caused by: org.postgresql.util.PSQLException: ERROR: null value in column "id" violates not-null constraint

        Detail: Failing row contains (null, null, null, 2017-08-28 01:44:30.9, 0).

              at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2101)

              at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1834)

              at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)

              at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:510)

              at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:386)

              at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:332)

              at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:537)

              at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:204)

      I don't know cause, i downloaded script jboss-bpmsuite-6.4.0.GA-supplementary-tools.zip(Red Hat JBoss BPM Suite Download | Red Hat Developers ) and run create table and schema. Please help me and thank any for your help.