none
The adapter failed to transmit message going to send port RRS feed

  • Question

  • Hi ,

    I am creating Restfull api using biztalk server 2013 R2. the input and output are in json format to the api.

    have created the custom pipeline for receive and send pipeline for json decoder and encoder. 

    it was working fine before but not its throwing the error when i run the url through fiddler.


    Monday, May 30, 2016 10:21 AM

Answers

  • Hi Rajeshwari

    Check the messageType that is going to the SendPort - open the suspended instance in Admin Console -> Messages Tab -> double-click and launch the message -> click on 'body' in left-pane. Now check the message contents.

    I guess you need a map that maps from your P_INPUT_T message to the Oracle operation schema. The JSON input XML is directly going to the Oracle SendPort. You need to map the fields from your P_INPUT_T XML message to the Oracle operation schema that was generated when you ran the Consume Adapter Service Wizard. This Oracle operation message needs to go the SendPort.


    Thanks Arindam





    Monday, May 30, 2016 10:24 AM
    Moderator
  • Hi Rajeshwari,

    Your map which converts your input message to oracle message is not getting executed. Please check the flow. 

    Ensure that you have provided the same Root Node and Root Node namespace in JSON Decoder component in your receive pipeline which you have provided while creating the JSON schema using BizTalk JSON schema wizard.

    Also ensure you have oracle schema is deployed properly. You might need to redeploy the schema and unistall / re-install the schema assembly from Gac.
    And ofcourse restart the BTS host instance it should work fine.


    Rachit Sikroria (Microsoft Azure MVP)

    Monday, May 30, 2016 10:32 AM
    Moderator

All replies

  • Hi Rajeshwari

    Check the messageType that is going to the SendPort - open the suspended instance in Admin Console -> Messages Tab -> double-click and launch the message -> click on 'body' in left-pane. Now check the message contents.

    I guess you need a map that maps from your P_INPUT_T message to the Oracle operation schema. The JSON input XML is directly going to the Oracle SendPort. You need to map the fields from your P_INPUT_T XML message to the Oracle operation schema that was generated when you ran the Consume Adapter Service Wizard. This Oracle operation message needs to go the SendPort.


    Thanks Arindam





    Monday, May 30, 2016 10:24 AM
    Moderator
  • Hi Rajeshwari,

    Your map which converts your input message to oracle message is not getting executed. Please check the flow. 

    Ensure that you have provided the same Root Node and Root Node namespace in JSON Decoder component in your receive pipeline which you have provided while creating the JSON schema using BizTalk JSON schema wizard.

    Also ensure you have oracle schema is deployed properly. You might need to redeploy the schema and unistall / re-install the schema assembly from Gac.
    And ofcourse restart the BTS host instance it should work fine.


    Rachit Sikroria (Microsoft Azure MVP)

    Monday, May 30, 2016 10:32 AM
    Moderator
  • Hi Rajeshwari,

    Check the oracle send port settings. Also check you can able to create a Schema using the same settings and check the schema is same as the before.

    Sometime it happens when the table or the functions changed in the Oracle side. So compare the tables or functions.


    Regards, Aboorva Raja R Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Monday, May 30, 2016 1:59 PM