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

adempiere | sernaton | 10 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Can not delete Banks, Charges, Business Partner Groups, ...?

    adempiere | 10 years ago | sernaton
    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
  2. 0

    Delete error in deleting products

    adempiere | 9 years ago | javed_jamee
    org.postgresql.util.PSQLException: ERROR: update or delete on table "m\_product" violates foreign key constraint "mproduct\_cinvoiceline" on table "c\_invoiceline"   Detail: Key (m\_product\_id)=(1000025) is still referenced from table "c\_invoiceline".; State=23503; ErrorCode=0
  3. 0

    Getting "cannot commit when autocommit is enabled" exception while working with CachedRowSet in JDBC

    Stack Overflow | 4 years ago | user2191938
    org.postgresql.util.PSQLException: Cannot commit when autoCommit is enabled.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Cannot commit when auto commit is enabled (JDBC)

    Stack Overflow | 4 years ago | user2250795
    org.postgresql.util.PSQLException: Cannot commit when autoCommit is enabled.
  6. 0

    An I/O error occured while sending to the backend

    Stack Overflow | 4 years ago | user826323
    org.postgresql.util.PSQLException: An I/O error occured while sending to the backend.

    1 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. 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()
    2. PostgreSQL JDBC Driver
      AbstractJdbc2Connection.commit
      1. org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
      2. org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
      3. org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
      4. org.postgresql.jdbc2.AbstractJdbc2Connection.executeTransactionCommand(AbstractJdbc2Connection.java:653)
      5. org.postgresql.jdbc2.AbstractJdbc2Connection.commit(AbstractJdbc2Connection.java:673)
      5 frames
    3. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      4. java.lang.reflect.Method.invoke(Unknown Source)
      4 frames
    4. PostgreSQL JDBC Driver
      AbstractJdbc23PooledConnection$ConnectionHandler.invoke
      1. org.postgresql.ds.jdbc23.AbstractJdbc23PooledConnection$ConnectionHandler.invoke(AbstractJdbc23PooledConnection.java:357)
      1 frame
    5. Unknown
      $Proxy2.commit
      1. $Proxy2.commit(Unknown Source)
      1 frame
    6. org.compiere.util
      Trx.commit
      1. org.compiere.util.Trx.commit(Trx.java:380)
      2. org.compiere.util.Trx.commit(Trx.java:453)
      2 frames
    7. org.compiere.model
      GridTab.dataDelete
      1. org.compiere.model.PO.delete(PO.java:2486)
      2. org.compiere.model.GridTable.dataDelete(GridTable.java:2248)
      3. org.compiere.model.GridTab.dataDelete(GridTab.java:920)
      3 frames