Issue with data returned from SQL adapter

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Issue with data returned from SQL adapter

Viewing 2 reply threads
  • Author
    Posts
    • #19558

      I am using SQL Adapter to retreive data from a table which takes a value as input and returns another value using a stored procedure. On getting the return value from stored procedure (using generated schema) and values in another XML message, I am mapping it to a output xml schema. Surprisingly, I am not getting any data from SQL.

      I removed the mapping and just stored the message coming out from SQL and I am able to see the data is coming out but when I am trying to map it to another XML schema I am not getting the data mapped.

      Any one found the same issue? Please help me.

      Thank you

    • #19560

       

      Sounds like an issue with the map.

      Are you able to provide schemas, maps and sample data?

    • #19564

      Sidhu,

      It sounds as though the map is not working if you are certain that the SQL Adapter response is returning a populated message.

      Can I suggest that you test the map further under Visual Studio using the response message from the SQL Adapter to ensure that this is not the source of the problem.

      One alternative may be that you have nothing subscribed to the result of the map (which will be published to the MsgBox by the Solicit-Response Send Port. Are you receiving any error messages in the Event Log that suggests you have a subscription or routing failure?

      Rgds, Nick.

      • #19586

        Nick,

        I was able to see the below message from SQL before transforming it to another message.

        <?xml version=”1.0″ encoding=”utf-16″?>
        <Res xmlns=”http://SQL_Gen&#8221;>
        <Student SNO=”2″ Name=”Kumar” Physics=”68″ Chemistry=”95″ />
        </Res>

        After transforming it to point SNO to SNo and Name to Name in output xml, I am getting the below xml.

        <?xml version=”1.0″ encoding=”utf-8″ ?>
        <ns0:StudentOut xmlns:ns0=”http://SQL_Proc_Sample.Schema2“ />

        Please let me know if you can see any issue in the xml generated from SQL

Viewing 2 reply threads
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.