Configure BPM Suite 6.4 with postgreSQL

[huyrong]

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.

[amit12345]

There is no issue from BPMN side.The error is coming from your database table .If possible please share the table structure with us.

[huyrong]

Thank for quickly answer my question.

I create database from script download from jboss-bpmsuite-6.4.0.GA-supplementary-tools.zip(Red Hat JBoss BPM Suite Download | Red Hat Developers)

I used default and don't edit any table, sequence, index,...

[huyrong]

I solved error. Sorry, i don't configure persistence.xml

Thanks all for your help.