TN schema error ?

, ,
1

Hi,

Does any of you have seen this type of error ? If any idea how to solve it.

java.sql.SQLException: [wm-cjdbc33-0069][Oracle JDBC Driver][Oracle]ORA-02291: integrity constraint (TN_MD.FK_ACTLOG_RELATEDDOCID_BIZDOC) violated - parent key not found

Thanks in advance
Ram

2

At what point you are getting this error?During doc submission to TN or quering doc’s from TN DB?

Please give more details on your steps.

HTH,
RMG

3

Motati100:

Hope this helps you:

Error:ORA-02291: integrity constraint (string.string) violated - parent key not found.
Cause: A foreign key value has no matching primary key value.
Action: Delete the foreign key or add a matching primary key.
In your case (string.string) would be ==>TN_MD.FK_ACTLOG_RELATEDDOCID_BIZDOC
Thanks
Scoobydoo

4

Hi RMG
Thanks for the response… We found the cause for it. We are getting this error because of custom call to wm.tn.log service in one of our service.

Thansk
Rama

5

Thanks for the update.Glad to know you found the problem and resolved it.

HTH,
RMG

6

Hi motati100,
You said the prolem was because of a call to wm.tn.log service. But why was it failing? We are also getting this error for only one partner and that too for an outbound 997 to that partner. We are currently using webMethods only to receive the documents and pass it to Gentran where actual mapping happens. I was thinking may be we received the 850 from the partner through FAX or email and it got into Gentran from there so this error is coming because we don’t have the parent document (850) information in TN but that is not the case. 850 also came in webMethods first. So what else can be the problem? Can someone throw some light on it?