org.postgresql.util.PSQLException: ERROR: update or delete on table "c\_charge" violates foreign key constraint "cchrage\_cchargeacct" on table "c\_charge\_acct" Detail: Key (c\_charge\_id)=(1000000) is still referenced from table "c\_charge\_acct".; State=23503; ErrorCode=0

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

,
Expert tip

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>

Solutions on the web

via adempiere by sernaton
, 1 year ago
ERROR: update or delete on table "c\_charge" violates foreign key constraint "cchrage\_cchargeacct" on table "c\_charge\_acct" Detail: Key (c\_charge\_id)=(1000000) is still referenced from table "c\_charge\_acct".; State=23503; ErrorCode=0
via adempiere by netsika
, 1 year ago
ERROR: update or delete on table "m\_product" violates foreign key constraint "m\_product\_m\_product\_acct" on table "m\_product\_acct"   Detail: Key (m\_product\_id)=(1000003) is still referenced from table "m\_product\_acct".; State=23503; ErrorCode=0
via Google Groups by Kevin Grittner, 3 months ago
ERROR: current transaction is aborted, commands ignored until end of transaction block
via adempiere by nasiraftab
, 1 year ago
ERROR: duplicate key value violates unique constraint "ad\_treebar\_pkey"; State=23505; ErrorCode=0
via adempiere by javed_jamee
, 1 year ago
ERROR: update or delete on table "m\_product" violates foreign key constraint "mproduct\_cinvoiceline" on table "c\_invoiceline"   Detail: Key (m\_product\_id)=(1000027) is still referenced from table "c\_invoiceline".; State=23503; ErrorCode=0
via atlassian.com by Unknown author, 1 year ago
ERROR: update or delete on table "repository_changeset" violates foreign key constraint "fk34a3e6e3cbadfcbd" on table "relevant_changesets" Detail: Key (repository_changeset_id)=(6815755) is still referenced from table "relevant_changesets".
org.postgresql.util.PSQLException: ERROR: update or delete on table "c\_charge" violates foreign key constraint "cchrage\_cchargeacct" on table "c\_charge\_acct" Detail: Key (c\_charge\_id)=(1000000) is still referenced from table "c\_charge\_acct".; State=23503; 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.AbstractJdbc2Connection.executeTransactionCommand(AbstractJdbc2Connection.java:653)
at org.postgresql.jdbc2.AbstractJdbc2Connection.commit(AbstractJdbc2Connection.java:673)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at undefined.$Proxy2.commit(Unknown Source)
at org.compiere.util.Trx.commit(Trx.java:380)
at org.compiere.util.Trx.commit(Trx.java:453)
at org.compiere.model.PO.delete(PO.java:2486)
at org.compiere.model.GridTable.dataDelete(GridTable.java:2248)
at org.compiere.model.GridTab.dataDelete(GridTab.java:920)

Users with the same issue

Once, 6 days ago
Once, 1 week ago
Samebug visitor profile picture
Unknown user
Once, 1 week ago
Once, 2 weeks ago
32 times, 3 weeks ago
99 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.