[community-content]

In this case you can use an XmlDocument variable in your orchestration
and load the string into the XmlDocument and assign the XmlDocument to a message.

xmlDocVar.LoadXml(WebRequestResponse.ReturnString);
newMessage = xmlDocVar;

[community-content]

You need to make sure you have 3a for both SQL Server and Analysis Services. Also, you need to have Analysis Services Client on the BizTalk Server with 3a installed as well.

Other than that, I’m sure if there are other special tricks when working with Windows 2000. I’ve always used XP or Windows 2003.

Stephen W. Thomas

[community-content]

I have seen tests working inside VS and not through BizTalk as well.

I think it’s because the pipelines do things like remove empty nodes, allow early termination, etc. I think it’s basically all the “Additional Schema Properties” of flat files.

Make sure I have it right, you need the empty nodes to show up? Or not be empty? One way would be to change the default value of the node. Example: if you have a node with “0000” and the default value is “0” I think the flat file disassembler will remove the node.

Also, you might want to look at the suppress empty node property.

Hope this helps.

Stephen W. Thomas

[community-content]

[quote:58ee0f3c92=\”greg.forsythe\”]The definition of application varies by version.

[quote:58ee0f3c92]In BizTalk 2006, an application is a logical grouping of all the BizTalk design-time artifacts (schemas, maps, pipelines, orchestrations), messaging components (receive ports, receive locations, send ports) and other related items such as policies that comprise an integrated business process. BizTalk applications simplify the deployment and management of BizTalk based solutions.[/quote:58ee0f3c92]

In previous versions an application is not as well defined. The concept of Biztalk Application is a new and welcome change in Biztalk 2006.

You should check of this FAQ
[url]http://www.microsoft.com/biztalk/2006/howtobuy/faq.mspx[/url][/quote:58ee0f3c92]

Yeah, i’ve read that many times.

Would it make sense to equate an application to a map used for an EDI trading partner? Meaning – 1 application for an inbound 850, 1 for an outbound 997, etc?

It’s hard to decide which version one needs when the details are so vague. Thats why i’m trying to get some real world examples, as oppose to MS & their general descriptions.

Also – you pay per processor right? If i have a 2 proc server, i’m gonna need 2 licenses?

[community-content]

I still can’t fix the problem.

Can it be, that the receive pipeline with flat file disassembler makes the error? When I test the map, BizTalk don’t uses any pipeline. But when I run the orchestration, I must set a Pipeline, because without it, the orchestration can’t receive the text message.

If there were any problems with database connection, then the map test should not be succeed. But it works. What are the differences between map testing and the map using in a running orchestration?

[community-content]

Schema of Response of SQL adapter is as follows.

ITD_IDEA //—–Root Node 1
-UT //—– Node 2

– OT //—– Node 3
-OrderID // —- Child 1
-Status // —- Child 2
-Mail // —- Child 3

Out of this mail is child element which is repeated number of times.
Also i have created another XML schema as:

<Schema> //—–Root Node
Record //—– Node 1
Repeated //—– Node 2
OrderID // —- Child 1
Status // —- Child 3
Mail // —- Child 3

Expression Box present in Atomic Shape consist of code as:

xmlDoc = ITD_IDEA_Resp.Parameters;
xmlNodeList= xmlDoc.SelectNodes(\”//*[local-name() =’ut’ ] \”);
Enum = xmlNodeList.GetEnumarator();

It gives me error for Xpath given in Expression box.
How i can resolve this Problem?

Thanks in advance.

[community-content]

Hi,

My source schema is having a default namespace and all the nodes belong to that namespace. eg: xmlns=\”http://mynamespace\”. I mapped this source to a destination schema and while validating my instance message, I am getting the error
\”Output validation error: The root element is missing \”. This will be solved if I am modifying my instance message as xmlns:ns0=\”http://mynamespace\” and prefix all the nodes with ns0. Can anyone suggest a solution for this other than modifying the file?

Thanks in advance.

Deepa

[community-content]

Thanks greg.forsythe for the help.
Now I have another question.If the web service returns a string,which contains a xml structure.So,in this case,how to receive the message?

[community-content]

You cannot rely on the file name to assign a schema.
Only two of the numerous adapters have a file name (FILE & FTP). All the others have no file name and numerous other protocol or application mechanisms for identifying a message.

The internals of Biztalk need to be adapter agnostic, hence the use of the root node and targetnamespace to identify a message type.

You can handle documents without a target namespace, but you can only have one document with the same root node without a namespace.
i.e.
type1 = <invoice> OK
type2 = <invoice xmlns=\”namespace1\”> OK
type3 = <invoice xmlns=\”namespace2\”> OK
type4 = <invoice> this will clash with type 1

This limitation is not by assembly but by Biztalk Server Group.

To delare a schema without a namespace
Open the schema
Select <Schema>
In properties window find the Target Namespace property and delete.

[community-content]

Hi.

Yes , if file name is unique for a certain filetype can I then define which schema should be used for file even if namespaces in xml files are missing.

\\RM

[quote:dc7dbe7952=\”greg.forsythe\”]I am not sure I understand your question:

Does anyone have idea how to define correct schema by filename?

Are you referring to how Biztalk matches an incoming message to its schema?[/quote:dc7dbe7952]

[community-content]

Is it possible to show us the code in the expression shape and an example of a message you are trying to split.

[community-content]

There is a web service,which returns with a message of dataset type.But I don’t know how to receive this type of message.
Please help,thanks!

[community-content]

Stephen,

thanks for the reply.

i finally thought of checking IIS logs and found out that it was one of our vendors who are suppose to use this system sending these messages for no particular reason. I thought it was something on our end that potentially could mess up the processes but no, it’s THEM 🙂

P.S.

too bad that in biztalk you can’t see the host/url of where the message came from

Thanks

[community-content]

it could be something other than sql server. you should check out the install logs to find the exact error and work from there. shouldn’t be hard.

Cheers

[community-content]

You can use a remote SQL Server but you have to be on a domain and be using domain accounts with the correct permissions. Might want to take a look at the multi-computer iinstall instruction inside the installation guide.

Hope this helps.

Stephen W. Thomas

[Author]

Posts