Forum Replies Created
-
AuthorPosts
-
September 10, 2009 at 9:53 AM 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.
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?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/
September 10, 2009 at 7:41 AM in reply to: Separating the BizTalk Server and SQL Server into two machines #23213Are 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?
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
September 10, 2009 at 3:45 AM in reply to: Help needed to start biztalk EDI application development #23209Hi 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
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
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
September 8, 2009 at 8:48 AM in reply to: ERROR Read AS400 File Using Host File Adapter "An invalid packed decimal value was encountered in Structure or Record in processing structure"??????? #23204Hi 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.
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.
That is not correct. BizTalk is also licesed / CPU.
But what you need is dev licences.
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,
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.
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.
September 5, 2009 at 11:10 AM in reply to: Help needed to start biztalk EDI application development #23196Hi 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.
-
AuthorPosts