Ravindar, .Net, Biztalk developer

Just another WordPress.com weblog

why do we need to call pipeline from orchestration and how do we do it?

http://geekswithblogs.net/sthomas/archive/2005/06/16/44023.aspx

http://geekswithblogs.net/arnoudlems/articles/69521.aspx

June 25, 2011 Posted by | Biztalk Server | Leave a Comment

BizTalk Aggregation Pattern for Large Batches

http://blogs.msdn.com/b/richardbpi/archive/2006/05/08/592476.aspx

June 19, 2011 Posted by | Biztalk Server | Leave a Comment

Get Uniques values from a list through XSLT

Get Unique values for a list of values

xxxx

yyyy

xxxx

The desired output is:

xxxx
yyyy

so use this

<xsl:variable name="unique-list"
select="//state[not(.=following::state)]" />

for example like below 

<xsl:variable name="unique-list"
select="s4:AdTermID[not(.=following::s4:AdTermID)]" />

the above statement will get the unique values in to that variable (just like it is an array)

if you want to make a for each loop based on this unique values use below code

<xsl:for-each select="$unique-list">

your logic here

</xsl:for-each>

if you want to compare any value to this array element use below code where AdTermID is the elemnt

<xsl:if test="your elment here=s4:AdTermID[not(.=following::s4:AdTermID/text())]">

when you try to compare a value with thes values in the array you should use /text()

source of article

http://www.bernzilla.com/item.php?id=333

see the comments of Abhinav Maheshwari

June 16, 2011 Posted by | Biztalk Server | Leave a Comment

Virtual PC console not showing up

VPC stored it’s configuration in the following file:

%APPDATA%\Microsoft\Virtual PC\Options.xml

Within that XML file, I found the following nodes: “left_position” and “top_position”

Reset “left_position” and “top_position” to 0 fixed the issue.

June 14, 2011 Posted by | Uncategorized | Leave a Comment

Directly querying the BizTalk database for suspended messages

SELECT
nvcName as ApplicationName,
DATEADD(hh,-6,dtSuspendTimeStamp) as DateSuspended, — Subtract the appropriate hours for your timezone
nvcAdapter as Adapter,
nvcURI as URI,
nvcErrorDescription as ErrorDescription
FROM InstancesSuspended
LEFT OUTER JOIN [Services]
on InstancesSuspended.uidServiceID = [Services].uidServiceID
LEFT OUTER JOIN Modules
on Modules.nModuleID = [Services].nModuleID
WHERE DtCreated between DATEADD(dd,-7,GETUTCDATE()) and GETUTCDATE()
and nErrorCategory=0
ORDER BY dtCreated desc

article source

http://geekswithblogs.net/bosuch/archive/2010/11/29/directly-querying-the-biztalk-database-for-suspended-messages.aspx

June 12, 2011 Posted by | Biztalk Server | Leave a Comment

Project Reference Errors in BizTalk

While developing BizTalk projects that referencing several other projects, many errors will be shown while compiling the BizTalk Projects. These errors will go away once the references are removed and added again.

Also, sometimes, updated made in the referenced projects will not be updated automatically.

This is a known issue with BizTalk Server 2009 and after googling I found that Microsoft has given a Hot Fix for this which can be downloaded below link

http://support.microsoft.com/kb/977428

the original post is at

http://masteringbiztalkserver.wordpress.com/2010/12/01/project-reference-errors-in-biztalk/

June 12, 2011 Posted by | Biztalk Server | Leave a Comment

How to debug Orchestrations from Visual Studio for biztalk 2009 using C# .cs file

An Orchestration *.odx file contains an XML file and code written in a language specific to BizTalk called X#.

You can easily find these, when you right click an orchestration and open it with XML Editor or Notepad.

XML Representation of the Orchestration is used by the Graphical Designer to show the shapes on the screen.

X# code is in turn converted to C# at runtime using XSharp.exe file and this C# assembly will be executed.

This C# file can be found inside \obj\Debug\BizTalk\Xlang\File0.cs once the project is built.

Unlike in earlier versions of BizTalk, only one .cs file will be created irrespective of number of orchestration you have in your project.

This File0.cs file has different sealed internal classes for each of the orchestration in your project.

To debug your orchestration or code written in an expression shape, open this File0.cs and keep a break point. Attach BizTalk Server to the BtsNTSvc Process.

Now you will be able to debug your orchestration using C# Code.

http://masteringbiztalkserver.wordpress.com/2011/02/21/debugging-orchestrations-in-visual-studio-2009-using-c-cs-file/#comment-21

June 11, 2011 Posted by | Biztalk Server | Leave a Comment

modifying a BizTalk Message using C# or External Dll

http://masteringbiztalkserver.wordpress.com/2010/12/01/how-to-modify-a-biztalk-message-using-c-or-external-dll/

June 11, 2011 Posted by | Biztalk Server | Leave a Comment

biztalk map documenter as HTML

http://biztalkmapdoc.codeplex.com/documentation

June 11, 2011 Posted by | Biztalk Server | Leave a Comment

Enterprise SSO service start failure after installing VS2010

BizTalk and SSO was running smooth before the installation of VS2010 on my machine. I have a 64-Bit machine with Windows Server 2008 R2 and BTS 2009 installed. When I installed VS2010 my SSO was stopped and when I tried to start I started getting the error below

—————————
Services
—————————
Windows could not start the Enterprise Single Sign-On Service service on Local Computer.

Error 0×80131700: 0×80131700

To issue started because it unregisterd SSOSQL.dll which is found on C:\Program Files\Common Files\Enterprise Single Sign-On folder. To register it again run regasm on the VS command prompt from your 32-Bit machine.

regasm C:\Program Files\Common Files\Enterprise Single Sign-On\SSOSQL.dll

On my 64-Bit it worked by running the 64-Bit regasm which is found on C:\Windows\Microsoft.NET\Framework64\v2.0.50727.

So go to the framework64 folder from the command prompt and run

regasm C:\Program Files\Common Files\Enterprise Single Sign-On\SSOSQL.dll

June 10, 2011 Posted by | Asp.Net, Biztalk Server | Leave a Comment

Follow

Get every new post delivered to your Inbox.