#4093 Can't execute some processes and windows ...

R2.5.2
closed
Kathy Pink
5
2006-10-14
2006-10-06
wissem sfar
No

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]

Discussion

  • Kathy Pink
    Kathy Pink
    2006-10-06

    Logged In: YES
    user_id=329831

    please give details on how to replicate in GW int he
    current version
    Thanks

     
  • Kathy Pink
    Kathy Pink
    2006-10-06

    • status: open --> pending
     
    • status: pending --> closed
     
  • Logged In: YES
    user_id=1312539

    This Tracker item was closed automatically by the system. It was
    previously set to a Pending status, and the original submitter
    did not respond within 7 days (the time period specified by
    the administrator of this Tracker).