Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

AD_PInstance_ID Errors !!!

2006-10-06
2013-05-02
  • wissem sfar
    wissem sfar
    2006-10-06

    Hi everybody,
    I have this error and I can't find the reason, it appears when trying to execute some process and windows ... please help me.

    ===========> DB.executeUpdate: Update=INSERT INTO AD_PInstance_Para (AD_Org_ID,UpdatedBy,Updated,SeqNo,ParameterName,P_Number,IsActive,Info,CreatedBy,Created,AD_PInstance_ID,AD_Client_ID) VALUES (1000000,100,TO_DATE('2006-10-06 11:37:31','YYYY-MM-DD HH24:MI:SS'),0,'M_Product_ID',1000003,'Y','Unité centrale',100,TO_DATE('2006-10-06 11:37:31','YYYY-MM-DD HH24:MI:SS'),1000032,11) [null] [11]
    java.sql.SQLException: ORA-02291: integrity constraint (COMPIERE.ADPINSTANCE_ADPINSTANCEPARA) violated - parent key not found
    ; State=23000; ErrorCode=2291
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181)
        at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedStatement.java:543)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1028)
        at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:3753)
        at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:8829)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2886)
        at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:2960)
        at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:157)
        at org.compiere.util.DB.executeUpdate(DB.java:679)
        at org.compiere.util.DB.executeUpdate(DB.java:645)
        at org.compiere.model.PO.saveNew(PO.java:1975)
        at org.compiere.model.PO.save(PO.java:1534)
        at org.compiere.apps.ProcessParameter.saveParameters(ProcessParameter.java:455)
        at org.compiere.apps.ProcessParameter.actionPerformed(ProcessParameter.java:303)
        at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1786)
        at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1839)
        at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)

    ===========> DB.saveError: DBExecuteError - ORA-02291: integrity constraint (COMPIERE.ADPINSTANCE_ADPINSTANCEPARA) violated - parent key not found
    [11]
    ===========> MPInstancePara.saveNew: Not inserted - INSERT INTO AD_PInstance_Para (AD_Org_ID,UpdatedBy,Updated,SeqNo,ParameterName,P_Number,IsActive,Info,CreatedBy,Created,AD_PInstance_ID,AD_Client_ID) VALUES (1000000,100,TO_DATE('2006-10-06 11:37:31','YYYY-MM-DD HH24:MI:SS'),0,'M_Product_ID',1000003,'Y','Unité centrale',100,TO_DATE('2006-10-06 11:37:31','YYYY-MM-DD HH24:MI:SS'),1000032,11) [11]

     
    • MGarcia
      MGarcia
      2006-10-12

      looks to me like a key didn't match.
      " violated - parent key not found "
      You can try pasting the sql statement into sqlplus and runnining it:

      "INSERT INTO AD_PInstance_Para (AD_Org_ID,UpdatedBy,Updated,SeqNo,ParameterName,P_Number,IsActive,Info,CreatedBy,Created,AD_PInstance_ID,AD_Client_ID) VALUES (1000000,100,TO_DATE('2006-10-06 11:37:31','YYYY-MM-DD HH24:MI:SS'),0,'M_Product_ID',1000003,'Y','Unité centrale',100,TO_DATE('2006-10-06 11:37:31','YYYY-MM-DD HH24:MI:SS'),1000032,11)"

      you'll get the same error - also if you look at the sql you'll see 'M_Product_ID' in the value section

      regards
      Mike Garcia