I am getting “Parent Key Not Found” after receiving a document from a partner in Trading Networks. We receive and send EDI document using wM6.5, the attached image includes the webMethods components we installed. the following is the errorlog:

2010-02-23 16:25:31 CST wm.EDIINT:receive com.wm.app.b2b.server.InternalResourceException: Couldnt insert new document (0) java.sql.SQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-02291: integrity constraint (EDITNAS3.FK_BIZDOC_SENDERID_PTNR) violated - parent key not found (1) java.sql.SQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-02291: integrity constraint (EDITNAS3.FK_BIZDOC_SENDERID_PTNR) violated - parent key not found Stack trace data … 0131bcb0205511dfa8dff71d17e24769 NULL 0131bcb0205511dfa8dff71d17e24769

Could anyone help me? Thanks!

Hi Harley,
From the error logs it seems completely database issue and if you go by the error code then below is the reason and solution.

Reason : A foreign key value has no matching primary key value.
Solution: Delete the foreign key or add a matching primary key.

Is it the first time you received document/errored from the TP?

Also check this article on the advantage,a fix(EDI_6-5_SP1,webMethods EDI Module 6.5 SP1 TN Fix 6) is available for similar issue:Get it from SAG.

[URL]http://advantage.webmethods.com/article/?id=1613978628[/URL]

HTH,
RMg

Thanks for your responses, My wMEDIINT vision is 6.5.2, So I installed the fix WmEDIINT_6-5-2_Fix13,WmEDIforTN_6-5-2_Fix17,WmEDI_6-5-2_Fix20 and TNS_6-5_SP1, this error have been fixed, But a new issue was found when we sent documents to partner. Partner can receive the document and send the MDN correctly, but at our end its status is SendMsg:WaitMDN, I received MDN back but the MDN was failed:
com.wm.lang.flow.FlowException: Returned MDN is signed, but can not be verified.

OK good first issue got fixed…Did you check whether the partner sending expected signed MDN and certs?

HTH,
RMG

Thanks!!!