none
Biztalk to/from Amazon EDI

    Question

  • Dear All,

    I have a very confusing lab has going on.

    Currently I am trying to setup an EDI to exchange order information from Amazon.

    The amazon site has only given me  information of AS2ID AS2URL & CA.

    I have lab installed Biztalk 2013R2 with SQL 2012, also configured it as the Walkthrough https://msdn.microsoft.com/en-us/library/bb727687.aspx.

    And I have no idea where to put those 3 variables into biztalk server.

    I have move the CA into 'Certificate(local computer)>>Other People>>Certificates',not sure have I done it right?

    Can anyone point out the direction for me.

    Very much appreciate!!


    Monday, November 28, 2016 10:33 AM

Answers

All replies

  • Hi

    So, you know the AS2ID for Amazon. You also need to know your own AS2 ID. Then you can configure both the IDs in the AS2 Agreement Settings Page. Refer the MSDN documentation for step-by-step details-

    https://msdn.microsoft.com/en-us/library/ff629755.aspx

    image.png

    Regarding the certificate, it may also have to be installed in the Trusted Root Certification Authorities Store-

    image.png

    Now, regarding the AS2 URL of Amazon, you will (possibly) have to set it up in several places. If they are expecting asynchronous MDN, you have to specify that URL here-

    image.png

    Also, you will have to setup SendPort(s) from BizTalk pointing to the Amazon URL for EDI documents/997/MDN(if aysnchronous).

    Refer below blogs-

    https://gautambiztalkblog.com/2016/02/05/as2-setup-to-exchange-edi-messages-using-biztalk-server/

    https://gautambiztalkblog.com/2016/02/11/agreements-and-party-settings-for-edi-over-as2-in-biztalk-server/

    Also, refer below samples that ships with BizTalk SDK that covers both synchronous and asynchronous MDNs-

    https://msdn.microsoft.com/en-us/library/bb727687.aspx

    https://msdn.microsoft.com/en-us/library/bb727975.aspx


    Thanks Arindam



    Monday, November 28, 2016 11:59 AM
    Moderator
  • Hi,

    They have given you AS2ID to be configured in your party you need to create business agreement and parties that will have your receive port detail and send port detail. In this party you need to configure AS2ID.

    https://msdn.microsoft.com/en-us/library/azure/hh949815.aspx

    They have given you AS2 URL that you have to use it on your send port to send them AS2 message.

    Certificate you need to install in the user of BizTalk host instance and also you need configure certificate inside port. Never forget to configure the certificate at the BizTalk group hub page properties else you will get some errors which are hard to rectify.

    we have spend lot of time to learn this let us know if you need more help.

    follow this links for AS2 configurations;

    https://msdn.microsoft.com/en-in/library/bb226317.aspx

    Regards,

    Sharad Verma

    Monday, November 28, 2016 1:15 PM
  • Thank you all for the help.

    In fact I made a rookie mistake by not enabling the Application-Pool in 32-Bit mode.

    Also I re-install the CA into Biztalks running account.

    It seems I have already pass the 1st barrier.

    At-least now I can see errors in Event-Viewer.

    But now with a new issue.

    Amazon shows I can pass the receiving test(amazon to my lab) with no error.

    but my event viewer shows error I don't understand as under:

    .....................is being suspended with following errors:Error: 1 (Miscellaneous error)
     6: Finding the document specification by message type "http://schemas.microsoft.com/BizTalk/EDI/X12/2006#X12_00400_850" failed. Verify the schema deployed properly.

    I have look over the internet and found only answer is this (https://social.msdn.microsoft.com/Forums/en-US/43c53fa4-b17d-41f6-b893-6a875ff61a23/target-namespace-in-enable-custom-transaction-set-definition-noneffective?forum=biztalkediandas2) that I don't understand.

    Anyone can help me out?

    I am not quite sure what the "Schema" means(how it work or what it for) and how to deploy it(do I need to?)

    Monday, December 5, 2016 6:14 AM
  • Hi

    Is the error while receiving 850/Purchase Order from Amazon? 

    "Finding the document specification by message type "http://schemas.microsoft.com/BizTalk/EDI/X12/2006#X12_00400_850" failed. Verify the schema deployed properly."

    It looks like the version number (in bold above) is incorrect - it may be due to incorrectly formatted EDI file that is being sent by your partner/vendor. Check in the sample EDI format file they are sending you. Ideally it should be 00401 or 00501, and not 00400. 

    Refer the section "X12 Schema Discovery" in below document-

    https://msdn.microsoft.com/en-us/library/bb246089.aspx

    What schema is deployed in BizTalk? It will probably be either -

    http://schemas.microsoft.com/BizTalk/EDI/X12/2006#X12_00401_850

    OR

    http://schemas.microsoft.com/BizTalk/EDI/X12/2006#X12_00501_850

    Hence, BizTalk is unable to load the schema in the error message, since it does not exist.


    Thanks Arindam





    Monday, December 5, 2016 7:11 AM
    Moderator
  • Hello Again,

    first to thank you all for the help.
    But I read all the paper mention above and still have no clue about "what's the role pf schema"

    Now I can see some error message from system and found this in Biztalks error log

    -----------------------------------------------------------------------------------------------------------
    <UnrecognizedSchema>
    <UnrecognizedSegment>ST*850*0001</UnrecognizedSegment>
    <UnrecognizedSegment>BEG*00*NE*CONNECTIVITYTEST**20161215</UnrecognizedSegment>
    <UnrecognizedSegment>REF*CR*SILNG</UnrecognizedSegment>
    <UnrecognizedSegment>CSH*N</UnrecognizedSegment>
    <UnrecognizedSegment>DTM*064*20161215</UnrecognizedSegment>
    <UnrecognizedSegment>DTM*063*20161215</UnrecognizedSegment>
    <UnrecognizedSegment>N1*ST**92*RNO1</UnrecognizedSegment>
    <UnrecognizedSegment>PO1*1*23*EA*23.45*PE*EN*1234567891234</UnrecognizedSegment>
    <UnrecognizedSegment>CTT*1*23</UnrecognizedSegment>
    <UnrecognizedSegment>SE*10*0001</UnrecognizedSegment>
    </UnrecognizedSchema>
    -----------------------------------------------------------------------------------------------------------

    The samething I receive from another EDI lab.
    I can get files like this.

    -----------------------------------------------------------------------------------------------------------
    ISA*00*          *00*          *ZZ*AMAZON         *ZZ*SPTESTID       *161117*0842*U*00400*900000033*0*T*>~
    GS*PO*AMAZON*SPTESTID*20161117*0842*900000033*X*004010~
    ST*850*0001~
    BEG*00*NE*CONNECTIVITYTEST**20161117~
    REF*CR*SILNG~
    CSH*N~
    DTM*064*20161117~
    DTM*063*20161117~
    N1*ST**92*RNO1~
    PO1*1*23*EA*23.45*PE*EN*1234567891234~
    CTT*1*23~
    SE*10*0001~
    GE*1*900000033~
    IEA*1*900000033~
    -----------------------------------------------------------------------------------------------------------

    Does it means I didn't deploy the schema correctly?
    I remember I read from some where I can use built-in schema.
    If so, How should I deploy or configure it?
    Monday, December 19, 2016 3:01 AM
  • Never mind my last post.

    I have found the solution of deploying the schema by this document  https://msdn.microsoft.com/en-us/library/bb226539.aspx

    and change the error message with a new one about "failed routing because there is no subscribing orchestration or send port."

    "

    But now the question is: Do I have to create all the possible schema document inside Visual Studio and deploy them? or there be built-in's I can use directly.

     
    Monday, December 19, 2016 5:15 AM
  • Hi 

    I would request you to refer the below walkthrough-

    http://social.technet.microsoft.com/wiki/contents/articles/2264.biztalk-server-edi-scenario-send-an-x12-message-and-receive-an-acknowledgement.aspx#eeee

    Note that you have to unpack the schema from the XSD_Schema\EDI folder in BizTalk installation path, and deploy the schema assembly like any other schema in BizTalk-

    https://msdn.microsoft.com/en-us/library/aa559168.aspx?f=255&MSPPError=-2147217396

    You should also refer below article on configuring EDI X12 parties-

    https://msdn.microsoft.com/en-us/library/ff629750.aspx


    Thanks Arindam


    Monday, December 19, 2016 6:00 AM
    Moderator