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
  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