org.postgresql.util.PSQLException

ERROR: null value in column "name" violates not-null constraint; State=23502; ErrorCode=0

Samebug tips1

Try downgrading PostgresSQL server to 9.5 or update your PostgresSQL driver to 9.4-1211 with the following command: <postgresql.version>9.4.1211</postgresql.version>

Don't give up yet. Our experts can help. Paste your full stack trace to get a solution.

Solutions on the web3356

  • via adempiere by tspc
    , 11 months ago
    ERROR: null value in column "name" violates not-null constraint; State=23502; ErrorCode=0
  • via adempiere by jkclee
    , 1 year ago
    ERROR: null value in column "m\_pricelist\_id" violates not-null constraint; State=23502; ErrorCode=0
  • via adempiere by gohyc
    , 1 year ago
    ERROR: null value in column "pricelastpo" violates not-null constraint; State=23502; ErrorCode=0
  • Stack trace

    • org.postgresql.util.PSQLException: ERROR: null value in column "name" violates not-null constraint; State=23502; ErrorCode=0 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:305) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105) at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:189) at org.compiere.util.DB.executeUpdate(DB.java:905) at org.compiere.util.DB.executeUpdate(DB.java:808) at org.compiere.model.PO.saveNew(PO.java:2511) at org.compiere.model.PO.save(PO.java:1917) at org.eevolution.model.MPPCostCollector.afterSave(MPPCostCollector.java:914) at org.compiere.model.PO.saveFinish(PO.java:1995) at org.compiere.model.PO.saveNew(PO.java:2537) at org.compiere.model.PO.save(PO.java:1917) at org.eevolution.form.VOrderReceiptIssue.createCollector(VOrderReceiptIssue.java:1310) at org.eevolution.form.VOrderReceiptIssue.createIssue(VOrderReceiptIssue.java:1247)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    2 times, 1 month ago
    25 times, 7 months ago
    Unknown user
    Once, 10 months ago
    92 more bugmates