Forum Replies Created
-
Posts
-
I got help on MSDN BizTalk forum. The xpath must convert result to a string by using strng-function. E.g. xpath(msgSoapFault, "string(xpath)")
If you trace sql profiler to trace the commands, you should see your polling statement being triggered,
and because empty was return, it give you this warning message.
My setting is different, i have ambienttransaction = false, pollwhiledatafound = false
the differences is, in my stored procedure I have this to making it "xml"
if [datarow count] > 0
begin
–xml generating statements
end
else
begin
select ' ' for xml path('')
end
If you are running BTS on a dev box and using local accounts, try using the full computer name as the domain name. Don't use the workgroup name. Your user name should be something like MyPC1\EsbServiceAccount.
I found the solution: msvcr71.dll had been removed from C:\Windows\sysWOW64. This file is part of the "SAP drivers" you need when you want to use the SAP adapter in a receive port.
First use the count functoid to get the count of records.
If count=1 then get second 30 chars using similar c# code as I sent before ….change the substring index.
If count>1 then use the index functoid and map the value for index=2. So it will pick the data from second row.
i need to get the second 30 characters if there is no line break and second line when there is a line break
Xdoc1 and Xdoc2 are the XML's you want to compare and nodesnotfound gives you the list of nodes from xdoc1 not found in xdoc2.
I just wrote few lines quickly…test it properly.
List<string> nodesnotFound = new List<string>();
bool nodefound = false;
foreach (XmlNode xnode1 in xdoc1)
{
foreach (XmlNode xnode2 in xdoc2)
{
if (xnode1.Name == xnode2.Name)
nodefound = true;
}
if (!nodefound)
{
nodesnotFound.Add(xnode1.Name);
}
nodefound = false;
}
What you can do is
1. Create a flat file schema with a single field with CRLF as delimiter.
So your second problem is solved…..Getting first row.
2. Now we need to get max 30 characters from this first row.
You can use a inline C# functiod with C# code as
public string Get30Chars(string strFirstRow)
{
if (strFirstRow.Length >= 30)
return strFirstRow.Substring(0, 30);
else
return strFirstRow.Substring(0, strFirstRow.Length);
}
Create 5 Send Ports
Create a Send Port Group
Add each Send Port to the Send Port Group
Create a Filter on the Send Port Group using Bts.ReceivePortName (or something close to this)
