[community-content]

It helps.
Thanks a lot!

[community-content]

You might want to try to rebuild and redeploy the Orchestration project.

Make sure you close all windows and try again.

Maybe it’s a caching problem…

[community-content]

[code:1:c20522979f]<?xml version=\"1.0\"?>
<xsl:stylesheet version=\"1.0\" xmlns:xsl=\"http://www.w3.org/1999/XSL/Transform\">

<xsl:template match=\"/\">
<OutputOrders>

<xsl:for-each select=\"/ItemDetails/Orders[Branch1/Type01/Name]\">
<Order>
<xsl:variable name=\"ID\">
<xsl:value-of select=\"ID\"/>
</xsl:variable>
<ID>
<xsl:value-of select=\"$ID\"/>
</ID>
<Name>
<xsl:value-of select=\"Branch1/Type01/Name\"/>
</Name>
<xsl:variable name=\"myXpathItemCode\">//ItemDetails/Orders[ID='<xsl:value-of select=\"ID\"/>’]/Branch1/Type02/ItemCode</xsl:variable>
<DebugXpath>
<xsl:value-of select=\"$myXpathItemCode\"/>
</DebugXpath>

<xsl:variable name=\"myXpathItemValue\" select=\"//ItemDetails/Orders[ID=$ID]/Branch1/Type02/ItemCode\"/>

<ItemCode>
<xsl:value-of select=\"$myXpathItemValue\"/>
</ItemCode>
</Order>
</xsl:for-each>
</OutputOrders>
</xsl:template>
</xsl:stylesheet>[/code:1:c20522979f]

Here’s another example. One of my issues in debugging was that I had [ID=’$ID’] [ID=$ID].

The difference between my code and Greg’s is that this one does not require the nodes to be in specific sequence.

[community-content]

I can’t tell whats really going on, without a schema and samples, but if I take your subject line literally, you may need to use the more obscure features of the looping functoid.

Say you have in your source schema a repeating set, but in your destination schema you want it to flatten out… say maybe a repeating <Ph_Number> element in the source schema and a <myphnum1>, <myphnum2> and <myphnum3> element in the destination schema…

Here’s your source:

<loop>
<Ph_Number>1234567</Ph_Number>
<Ph_Number>1212123</Ph_Number>
<Ph_Number>9999999</Ph_Number>
</loop>

And here’s what you want the destination to be:

<myphnum1>1234567</myphnum1>
<myphnum2>1212123</myphnum2>
<myphnum3>9999999</myphnum3>

The trick is to tie the looping functoid to the loop on the source (in my example, the <Ph_Number> element), and connect it THREE TIMES to the destination… once to myphnum1, once to myphnum2, and once to myphnum3.

Then you can use the Iteration Functoid (tied to the <Ph_Number> element) to get whether you’re looking at the first, second, or third <Ph_Number>. Run the Iteration output to 3 different ‘=’ functoids. Each of the ‘=’ functoids will compare the iteration to a 1, 2, or 3 respectively. Wire the three ‘=’ functoids to three value-mapper-flatteners. Also wire the <Ph_Number> element to each of the three value-mapper-flatteners. Then wire the value-mapper-flatteners to <myphnum1>,<myphnum2>, and <myphnum3> elements respectively in the destination schema.

I have this in a diagram that I use when I teach BizTalk… so I can send it to you if you email me. (find me in the Memberlist).

Anyway, the obscure trick to this is that the looping functoid will walk the multiple records in the source schema as many times as its wired to non-repeating elements in the destination schema! Then all you have to do is add enough logic to figure out which record will go to which element… in my example I just used the iteration functoid.

[community-content]

Two possibles:

1) If you’re using SQL2k5 you will need to turn on Named Pipes and TCP/IP from the SQL Server configuration manager.

2) When using Virutal PC you will invariably run into network connectivity issues when trying to connect to resources, even though those resources are on the same machine. On the Virtual PC you need to go to Add/Remove hardware, and manually choose & install the Microsoft Loopback adapter. Once its installed, it will show up in ControlPanel/Network Connections with an odd name like Network Connection 2. R-Click it, choose rename and give it a decent name, like ‘Loopback Adapter’. Then R-Click it again, choose Properties, scroll down to ‘Internet Protocol’ and click the Properties button. Switch to ‘Use the following IP address’ and then provide a bogus class C address, like 192.168.0.1. Press OK a couple of times and then shutdown and restart the Virtual PC.

[community-content]

In resp to the first message (tutorial 3, lesson 3), see the tutorial corrections at: http://blogs.msdn.com/lizal

It would appear that the B2BSchemas did not deploy. I would verify that it compiled and then try to deploy it again after recycling the destination BizTalk instance.

[community-content]

This week MS released a KB article (918847) on an similar problem with BTS04/Win2k3sp1. More interesting is if you follow the KB chain you get to Article 884021, which shows it to be a bug in the .Net framework 1.0 / 1.1. I just wonder if somewhere in bowels of 2.0, it has the same broken logic?

Anyway, I spent a few hours this past weekend rearranging my plethora of projects into just 3 – 1 for the EDI schemas, 1 for all my other biztalk artifacts, and 1 for my helper classes that I use for my maps and orchestrations. Life is good again.

[community-content]

The only thing that jumps out at me is that you are using a laptop… remember there are some things that just don’t work right without a network connection. If you are running without a network connection (IP config says your IP is 0.0.0.0) then you will have SSO problems (and EDI problems since the EDI shares won’t work either). If this is the case, you can add the loopback adapter, set it up with a bogus class C address, like 192.168.0.1 or whatever. When you run your laptop w/o a network connection, enable the loopback… when you connect to an actual network, disable the loopback.

[community-content]

Yes. Thanks. I noticed this in a sample I had downloaded, though I am still receiving \”Reason: No Disassemble stage components can recognize the data.\” Is there some other reference that I need to delete?

I am trying to use an \”envelope\”.

FYI –
Really I am just trying to receive an xml message with many records (after some header information) and break them out into separate xml files. I see two method – one without a custom pipeline (though using promoted properities, and one using a custom pipeline. The one NOT using the custom pipeline makes use of a data/source xml file that is NAMESPACE-less. Any thoughts are appreciated.

Thx,
Phil

[community-content]

I don’t have any other ideas, maybe someone else can help?
You never said for sure when you get the error – is it when you compile?

[community-content]

The only idea I have is to make sure the XML file you are dropping is well-formed (open with Internet Explorer browser). Maybe someone else can help?

[community-content]

The Biztalk Help gives quite detailed instructions for both IIS5 and IIS6 (slightly differetn). I have videos that outline it at website below.

Even though the instructions are there – it can be quite frustrating. It doesn’t work unless all the security is set up correctly.

[community-content]

I’ll try to look for SQL server 2005 SSIS. Thank you for your time!

[community-content]

the type modifier is public

[community-content]

Thanks, Stephan.

I have following rule
1.If Employee.Emp:/Empname = Northwind.Customer.CustomerName
Action Employee.Emp:/EmpID = 100

2. If Not Employee.Emp:/Empname = Northwind.Customer.CustomerName
Action Employee.Emp:/EmpID = 200

Initially I have called expression shape in orchestration where I have written following code

SqlConnectivity = new System.Data.SqlClient.SqlConnection(\”Persist Security Info=False;Integrated Security=SSPI;database=Northwind;server=(local)\”);
SqlConnectivity.Open();
SqlTransaction = SqlConnectivity.BeginTransaction();
DatabaseConnectivity = new Microsoft.RuleEngine.DataConnection( \”Northwind\”,\”Customer\”, SqlConnectivity, SqlTransaction );

Then I used Call rule shape where I passed two parameters: message variable and Database connectivity (of type Microsoft.RuleEngine.DataConnection)

And when I tested again nothing happens.

Then I found out that for database connectivity we need Factretriever.

So I created C# class file.

My code is as follows

namespace myFactRetriever
{
public class myFactRetriever : IFactRetriever
{
public object UpdateFacts(RuleSetInfo rulesetInfo, Microsoft.RuleEngine.RuleEngine engine, object factsHandleIn)
{
object factsHandleOut;

// The following logic asserts the required DB rows only once and always uses the the same values (cached) during the first retrieval in subsequent execution cycles
if (factsHandleIn == null)
{

SqlConnection SqlConnectivity = new SqlConnection(\”Initial Catalog=Northwind;Data Source=(local);Integrated Security=SSPI;\”);
DataConnection DatabaseConnectivity = new DataConnection(\”Northwind\”, \”Customer\”, SqlConnectivity);
engine.Assert(DatabaseConnectivity);
factsHandleOut = DatabaseConnectivity;
}

else
{
factsHandleOut = factsHandleIn;
}
return factsHandleOut;
}

}
}

I built and GACed.
Now I configured policy version property for factretriever. But when I test the policy I get following error

\”Method or Operation is not implemented\”
This error I am getting even if I run Orchestration also…

Now where I have gone wrong?
1.Do I need to have any refernce of factretriver in Biztalk project? But then even policy test itself is failing..
2. Do I need to pass any parameter?
3.how can I make use of this factretriever in rule composer?
4. Should I use the database connectivity expression in expression shape in Orchestration ?

It would be great help if you guide me

Thank you

[Author]

Posts