org.apache.openjpa.persistence.PersistenceException: GDS Exception. 335544466. violation of FOREIGN KEY constraint "INTEG_46" on table "SCHEDULE_ELEMENT" Foreign key reference target does not exist {prepstmnt 8820448 UPDATE schedule_element SET persistentPlanable = ?, plannedEndTriggerId = ?, plannedStartTriggerId = ? WHERE id = ? [params=(byte[]) [B@1b7faf, (long) 0, (long) 0, (long) 224]} [code=335544466, state=HY000] FailedObject: xms.common.beans.bus.planning.schedule.B_ScheduleElement-224

openjpa-users | Datin Benoit | 3 years ago
  1. 0

    [Open JPA 2.2.2] Missing SQL statements

    openjpa-users | 3 years ago | Datin Benoit
    org.apache.openjpa.persistence.PersistenceException: GDS Exception. 335544466. violation of FOREIGN KEY constraint "INTEG_46" on table "SCHEDULE_ELEMENT" Foreign key reference target does not exist {prepstmnt 8820448 UPDATE schedule_element SET persistentPlanable = ?, plannedEndTriggerId = ?, plannedStartTriggerId = ? WHERE id = ? [params=(byte[]) [B@1b7faf, (long) 0, (long) 0, (long) 224]} [code=335544466, state=HY000] FailedObject: xms.common.beans.bus.planning.schedule.B_ScheduleElement-224
  2. 0

    Wrong SQL update query generated on merge

    Stack Overflow | 3 years ago | Oleg_Andreych
    org.apache.openjpa.persistence.PersistenceException: Неправильный синтаксис около ключевого слова "WHERE". {prepstmnt 1814850604 UPDATE COMPANY_REF SET WHERE ID = ? [params=(int) 11751]} [code=156, state=S0001] FailedObject: ru.hostco.jpa.Company-11751
  3. 0

    JPA (openjpa), DB2, update, commit = Invalid cursor name?

    Stack Overflow | 4 years ago | Maxim Suponya
    org.apache.openjpa.persistence.PersistenceException: Invalid cursor name. FailedObject: prepstmnt 125018062 UPDATE CCHDEVT.TCC_PROPERTY SET COMMENTS = ?, LAST_UPDATED = ? WHERE PROPERTY_NAME = ? [org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement_]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    HDP 2.0 Oozie Error: E0803 : E0803: IO error, E0603

    Stack Overflow | 2 years ago | jaksky
    org.apache.openjpa.persistence.PersistenceException: An SQL data change is not permitted for a read-only connection, user or database. {prepstmnt 2096695648 INSERT INTO WF_JOBS (id, app_name, app_path, conf, group_name, parent_id, run, user_name, bean_type, created_time, end_time, external_id, last_modified_time, log_token, proto_action_conf, sla_xml, start_time, status, wf_instance) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)} [code=20000, state=25502] FailedObject: org.apache.oozie.WorkflowJobBean@355319a8
  6. 0

    [GERONIMO-3907] Persistence Exception is not visible/lost for client. - ASF JIRA

    apache.org | 1 year ago
    org.apache.openjpa.persistence.PersistenceException: FEHLER: Einfügen oder Aktualisieren in Tabelle »person« verletzt Fremdschlüssel-Constraint »person_historie_fk_fkey« Detail: Schlüssel (historie_fk)=(27) ist nicht in Tabelle »historie« vorhanden. {prepstmnt 19422193 INSERT INTO vesuv.person (id, bemerkung, historie_fk, name, persontyp, phonetischer_diskriptor_name, vermoegensverzeichnis_fk, vorgaenger_version_fk) VALUES (?, ?, ?, ?, ?, ?, ?, ?) [params=(long) 7, (null) null, (long) 27, (String) , (int) 0, (String) , (long) 0, (null) null]} [code=0, state=23503] FailedObject: de.nrw.hagen.ggrz.bv.person.db.PersonPAO@124dc48

    2 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.apache.openjpa.persistence.PersistenceException

      GDS Exception. 335544466. violation of FOREIGN KEY constraint "INTEG_46" on table "SCHEDULE_ELEMENT" Foreign key reference target does not exist {prepstmnt 8820448 UPDATE schedule_element SET persistentPlanable = ?, plannedEndTriggerId = ?, plannedStartTriggerId = ? WHERE id = ? [params=(byte[]) [B@1b7faf, (long) 0, (long) 0, (long) 224]} [code=335544466, state=HY000] FailedObject: xms.common.beans.bus.planning.schedule.B_ScheduleElement-224

      at org.apache.openjpa.jdbc.sql.DBDictionary.narrow()
    2. OpenJPA Aggregate Jar
      DelegatingStoreManager.flush
      1. org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4962)
      2. org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4922)
      3. org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:136)
      4. org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:78)
      5. org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:144)
      6. org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:79)
      7. org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:100)
      8. org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:88)
      9. org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:550)
      10. org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:107)
      11. org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:59)
      12. org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:105)
      13. org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:78)
      14. org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:732)
      15. org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131)
      15 frames