Forum Replies Created
-
Posts
-
Can you expand a bit on "large amount of data". Is this 200KB or 2GB
One option is to return the data in the web service response, but this would depend on how large it is and how long it takes to generate.
If you are going to create a file and download via Http then you are probably best to do this in a custom .NET component called from an orchestration. You component would accept the Url as a parameter and return an XmlDocument or Xlang message to the orchestration.
Another possibility is to use a request response Http port but this will require some code on the web site hosting the data. Rather than receiving the Url from the web service you would get a file name or identifier, you would then send this data to an ASP.NET/PHP/JSP web page that would return the large xml data file.
If this file is very large you may need a delay between calling the web service and attempting to download the file
What is the trigger that will start this process and what will you do with the data once your receive it in Biztalk?
The minOccurs attribute only checks for the existence of the node, not the content.
To create a constraint against the node content you need to derive your own types
e.g.
<element name="EmailAddress type="non-empty-string"/>
<simpleType name='non-empty-string'>
<restriction base='string'>
<minLength value='1'/>
</restriction>
</simpleType>Thanks Man,
Is there any way to check where is problem lies… Whether BTS adapter is receiving any request or not ??
I have tired with sample @ SDK .. Its working fine…
not sure I agree with this.
<root>
<base1>
<something1>
<base2>
<something2>
<something3>
<base3>
In the above, the siblings are: base1, base2, base3 …. also, something2 & something 3 are siblings.
Base1 & Something1 are parent/child. so is Base2 & Something2.
Think of a sibling as "brother/sister"… not parent/child.
I’ve never done exactly what you are asking. I think it could be done using custom XSLT.
If you are not an expert XSLT coder (not many of them), you could always pass the message into a .net component inside an Orchestration. Then, you could use any type of logic you wanted to sort the message and break it up. It wouldn’t perform well though and if the message got to big it would “Out of memory” on you.
I’m guessing if you opened up HAT, you should use the query builder or modify one of the pre build queries to get this information. Don’t really know off the top of my head though.
I’ve never really tried this before. Have you tried receiving the flat file as a String and they calling a Receive Pipeline inside the Orchestration that does the Flat File work?
That might work.
Might be able to do it all on the Receive Location side as well just using a flat file pipeline.
You need to use a Correlation Set to promote the properties when you send a message out of the Orchestration using Direct Binding. It seems a little odd, but it is the only way to accomplish what you want.
Just define a correlation set with your property in it and initialize it on the Send Port. You will not have anyone following the correlation set.
Charles Young talks more about it here: http://geekswithblogs.net/cyoung/articles/17364.aspx or http://geekswithblogs.net/cyoung/articles/19546.aspx
Well the easiest way is to expose your Orchestration as a web service. Then you could just consume it as you would any other web service.
If you need to use HTTP Post, you’ll need to format your post according to the schema defined for the input into your Orchestration.
Hope this helps.
A sibling is related to another node like:
<root>
<base>
<something>
In this example, the something node is a sibling to the base node.
It is also called a Parent – Child relationship.
Hope this helps.
Doug,
I did try adding a parameter to the stored proc but that didn't make a difference. Thanks for the tip.
Greg,
I tried running a simple select on the generator but I also so no activity in SQL Profiler when running it. Everything looks good in MSDTC. The same stored proc does execute from the SQL receive port, so permissions and communications seem ok.
Anyway, as a workaround, I deployed the BizTalk project to another machine on which both BT and SQL for BT run. I created a database on this machine with a table and stored proc identical to those from which I was trying to create the schema. Running the wizard on this machine, pointing to the local database's stored proc, the schema generator worked and I got my schema, which is now working fine on the original BT machine. When I have some free time I'll try to troubleshoot the original problem out of curiosity but for now I have a workaround. I'll be sure to post what I find out.
Thanks to everyone for the suggestions. They're much appreciated!
– Shawn
I don't think the stored proc is at fault. Typically if the select statement or stored procedure is at fault you will get an error message.
Have you checked MSDTC connectivity to this SQL Server.
A quick check is to run the wizard and use a select statement you know will work
like: select * from sysobjects for xml autoThe problem is the namespace:
Your message has a namespace of: http://BizCompTest2.BizCompTest3OutSchema
While the xpath has a namespace of http://BizCompTest4.BizCompTest4OutSchema
The xpath namespace is set when you promote the distinguished field in your schema and will match the schema target namespace.
You need to change the namespace in the second line of your code above
Also, if you set the "Use Default Constructor" property on xmlDocVar you do not need the first line.
