community-content

Forum Replies Created

Viewing 15 posts - 2,296 through 2,310 (of 9,648 total)
  • Author
    Posts
  • in reply to: Help needed to start biztalk EDI application development #23216

    Hi Ram,

     

       Here are the steps that you would do to generate an XML schema in BizTalk from a Stored Procedure in SQL Server that fetches data (SELECT statement):

    1) Your stored procedure would contain a SELECT statement like this: SELECT Field1 FROM Table1 FOR XML RAW, XMLDATA

    Pay attention to the use of predicate FOR XML RAW, XMLDATA as this is important that it be there in order for you to successfully generate the XML schema

    2) Go to your BizTalk project, and run the SQL Adapter Wizard from the option Add Generated Items -> Add Adapter Metadata, point to the targeted database server/database in Data Link Properties window, fill in the Schema information, and pick the stored procedure as the Statement Type information.

    3) Once your schema is successfully generated by the wizard, you can modify your stored procedure to comment the XMLDATA part of your SELECT statement, before you are ready to this SP from BizTalk.

     

        If you follow these steps, you should be able to generate your schema, use it in a map or orchestration and deploy your BizTalk project.

     

        Good luck!

     

        Daniel.

     

    in reply to: Mapping Error #23215

    Can you provide more details:

    What is your map trying to do?
    Does it use a custom Xslt file
    Are you using scripting functoids
    Have you tried removing functoids, etc, until it works to narrow down what could be causing the problem?

    in reply to: Call Send Pipeline to get original message #23214

    You might like to use the Message Archiving pipeline component. Add this as the first component in your receive pipeline.

    The code is here: http://btsmsgarchcomp.codeplex.com/

     

     

    in reply to: Separating the BizTalk Server and SQL Server into two machines #23213

    Are the BizTalk Server and SQL Server in the same domain.
    Are you using a domain account on the Biztalk server when configuraing Biztalk.
    Does this account have sysadmin rights on the SQL Server.

    Can you give us some more information on what you are trying to configure and what is the error?

     

    in reply to: Biztalk APP failing to load into Terradata #23211

    Hello , we resolved this: For TeraData OLE DB Provider to work correctly, there are 2 dependencies to be installed; Shared ICU library for TeraData TeraData GSS. Both were not installed in our server; once installed, it worked; Thanks

    in reply to: Help needed to start biztalk EDI application development #23209

    Hi Daniel,

         Thanx. Before I go to oracle, I have tried get the xml input and store/update my SQL server database records. but could not able to do.

    please help me to send sample steps or procedures to save my xml elements in to sql db. Your domain samples also ok . I tried google also but i can’t

    sucess. Please show the step by step procedure to update/fetch sql db site.. one or two fields samples is enough. Again please send sample. I am

    using Biztalk Server 2006 R2. I am expecting your reply.

     

    Regards

    Ram

    in reply to: Issue while connecting to Sharepoint #23206

    I had installed WSS & Biztalk in same machine.

    iam 🙁 getting error as follows.

    The file you are attempting to save or retrieve has been blocked from this Web site by the server administrators

    Please help me out of this errors

    in reply to: Debatching based on schema attribute vlaue. #23205

    Daniel, My requirement is

    If ID value is same then it should come under one record.

    For Ex If Id value is same for 5 records all the five records should come under one <Employee> tag.  Please help me getting this…

    Thanks in advance

    Hi akshalika,

       You might want to take a look at this site, and see if you can find some information there to resolve your AS400 issue:

    http://blogs.msdn.com/sjackson/archive/2009/04/06/how-does-his-fit-in-with-biztalk-server.aspx

       Also, you can pose your question to one of the MSDN forums related to BizTalk adapters, the moderators over there are pretty good in answering any questions and resolving issues.

       Good luck!

     

        Daniel.

     

    in reply to: Biztalk APP failing to load into Terradata #23203

    Hi,

    Sorry for misleading you on this one: it’s not the ODBC datasources that you should be checking.

    Check to see whether or not the OLE DB Provider for Teradata is installed on that node, if not, that should lead you to resolving this issue.

    My apologies,

    Daniel.

     

    in reply to: Biztalk installation on Dev environment #23202

    That is not correct. BizTalk is also licesed / CPU.

    But what you need is dev licences.

    in reply to: Biztalk APP failing to load into Terradata #23200

    Hello Daniel,

         Are you referring to the ODBC Datasources in Admin Tool under Control Panel?

      if yes, is that applicable here since this is OLEDB driver?

        Kindly clarify

    thanks

    Regards,

     

    in reply to: Biztalk APP failing to load into Terradata #23199

    Hi,

       From looking at the error description, it would seem that you are missing a DSN connection on that particular node, which is being called by the BizTalk application. Check the list of DSN connections on that node with the 2 other nodes (that work) to see if that’s the case.

       Good luck!

       Daniel.

     

    in reply to: Problem with exception #23197

    I have a similar orchestration, External users submit data to a SOAP endpoint and need to always receive a response.

     

    I resolved this by creating one response message schema that can handle both sucess and failure situations.

    I also make calls from the orchestration to other services that may fail.  Those calls I wrap in a non-transacted scope, with an exception handler for the scope that subscribes to a fault message that I add to the action on the send/recieve port.

    If an exception occurs in one of the calls to external resources, I store information about it in variables.

    At the end of the orchestation I create the response message using the data gathered throughout processing and return it.

    in reply to: Help needed to start biztalk EDI application development #23196

    Hi Ram,

       Assuming that you are on BizTalk Server 2006, use the BizTalk Adapter for Oracle DB, that comes with the suite of BizTalk Line of Business Adapters in version 2006. Using that adapter, you should be able to generate your XML schema from the Oracle DB table that you are targeting in your map.

       Hope this clarifies the process for you.

       Daniel.

     

Viewing 15 posts - 2,296 through 2,310 (of 9,648 total)