parent key not found

, ,
1

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!
wM65.jpg

2

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.

3

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

4

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.



5

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

HTH,
RMG

6

Thanks!!!