locked
Accessing Party EDI details through code in 2013 RRS feed

  • Question

  • Hi,

    We are looking at options of accessing the Party EDI details from orchestration in BTS 2013 R2. But looks like the property X12Receiver belonging to the partner object  Microsoft.BizTalk.Edi.PartnerAgreementManager.Partner has been deprecated. Although, using the property does not give a compilation error, it throws exception during runtime with the below error:

    System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'edi_PartnerX12InterchangeSelect'.

    Any pointers on how the accessing of party EDI details through code/within orchestration can be achieved? Appreciate any help on this regards. Thanks.

    Monday, August 25, 2014 7:19 AM

Answers

  • Refer "Custom Party Resolution" sample available in the BizTalk SDK - http://msdn.microsoft.com/en-in/library/aa559134.aspx and pay specific attention to the code in "PartyResolutionStream.cs". This has the logic for querying the BizTalk Party database tables.

    You can expose you own library/helper with this code and leverage it in the orchestration.

    That having said, if you use the EDI Pipelines, the party resolution is done for you and available on the received message in the orchestration as promoted property. Refer http://msdn.microsoft.com/en-us/library/bb226500.aspx

    Regards.

    • Proposed as answer by M.R.Ashwin Prabhu Tuesday, August 26, 2014 3:22 PM
    • Marked as answer by Angie Xu Thursday, August 28, 2014 1:52 AM
    Monday, August 25, 2014 10:36 AM