#18 Requests can't be saved

X_Unsupported
closed-fixed
5
2001-11-05
2001-11-04
Jorg Janke
No

Email fron Dan:
Partner relations->requests
- Put in "due" and a test summary.
- Clicked saved changes
- Error message came on screen (integrity
constraint violated, parent key not found)

How do I copy/paste the error messages? When I click
File->Email on an error message dialog box, nothing
happens (where do I set up my e-mail so it works?).
So I can either give you a screen shot, or copy the
text from the "-debug" window, which is below.

I appreciate your help. I look forward to getting the
Sales Lead tracking / reporting section of this going
soon. So that if I can get that going good enough to
impress my client, then you might have another
developer join the team. :-)

Dan Browning
Kavod Technologies

===========> SQL Exception: MTable.dataSave
SQL= SELECT
ROWID,R_Request_ID,AD_Client_ID,AD_Org_ID,DocumentNo,Du
eType,Request
Type,AD_User_ID,Priority,IsEscalated,Summary,IsActive,C
_BPartner_ID,C_BP
artner_C
ontact_ID,C_Project_ID,C_Order_ID,C_Invoice_ID,M_Produc
t_ID,C_Payment_ID
,Request
Amt,C_Campaign_ID,DateLastAction,LastResult,ActionType,
Result,R_MailText
_ID,Mail
Text,DateNextAction,NextAction,Processing,Processed,Cre
atedBy,Created,Up
datedBy,
Updated FROM R_Request WHERE 1=2
===========> ORA-02291: integrity constraint
(ACCORTO.RREQUEST_RREQUESTACTION) v
iolated - parent key not found
ORA-06512: at "ACCORTO.R_REQUEST_TRG", line 14
ORA-04088: error during execution of
trigger 'ACCORTO.R_REQUEST_TRG' ; State=23000;
ErrorCode=2291 ===========> SaveError ORA-02291:
integrity constraint (ACCORTO.RREQUEST_RREQUES
TACTION) violated - parent key not found
ORA-06512: at "ACCORTO.R_REQUEST_TRG", line 14
ORA-04088: error during execution of
trigger 'ACCORTO.R_REQUEST_TRG'

Discussion

  • Jorg Janke

    Jorg Janke - 2001-11-05
    • labels: 364562 --> Application Dictionary
     
  • Jorg Janke

    Jorg Janke - 2001-11-05

    Logged In: YES
    user_id=87038

    Trigger had BEFORE/AFTER COMMIT Logic - created two Trigger;
    Workaround: Disable Trigger

    Followup Problem: Action History cannot be displayed
    (Column Created twice in list).

     
  • Jorg Janke

    Jorg Janke - 2001-11-05

    Logged In: YES
    user_id=87038

    Trigger had BEFORE/AFTER COMMIT Logic - created two Trigger;
    Workaround: Disable Trigger

    Followup Problem: Action History cannot be displayed
    (Column Created twice in list).

     
  • Jorg Janke

    Jorg Janke - 2001-11-05

    Logged In: YES
    user_id=87038

    ** Fixed in R2.4 **

     
  • Jorg Janke

    Jorg Janke - 2001-11-05
    • status: open --> closed-fixed
     
  • Jorg Janke

    Jorg Janke - 2001-11-05

    Logged In: YES
    user_id=87038

    ** Fixed in R2.4 **

     

Log in to post a comment.