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

    [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 | 5 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 | 3 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