Advanced Users Biztalk WIKI : Useful How to Links Part - 3

Useful How to Links Part - 3

BizTalk Administrator's Checklist Compiled by Microsoft BizTalk Support

http://social.technet.microsoft.com/wiki/contents/articles/629.aspx?CommentPosted=true#commentmessage

Muenchian Grouping and Sorting in BizTalk Maps

http://blogs.msdn.com/b/chrisromp/archive/2008/07/31/muenchian-grouping-and-sorting-in-biztalk-maps.aspx

http://code.msdn.microsoft.com/windowsdesktop/Muenchian-Grouping-and-790347d2

Xslt Template StyleSheet For Biztalk Mapping : Query in Biztalk Map

http://social.msdn.microsoft.com/Forums/en-US/biztalkgeneral/thread/ecc69e42-f126-40b5-83c0-aefcfdf53a85

AppFabric-enabled WCF Data Service Walkthrough (C#)

http://blogs.msdn.com/b/rjacobs/archive/2010/06/30/appfabric-wcf-data-service-cs.aspx

Querying DataSets – Introduction to LINQ to DataSet

http://blogs.msdn.com/b/adonet/archive/2007/01/26/querying-datasets-introduction-to-linq-to-dataset.aspx

Accessing BRE RuleEngine Using .Net Framework

http://arnulfowing.blogspot.com/2007/09/how-to-access-bre-vocabularies-from-net.html

Few links that may help:

http://msdn.microsoft.com/en-us/library/aa995566.aspx                                                                

(MSDN: Walkthrough: Executing the Policy Programmatically)

http://technet.microsoft.com/en-us/library/microsoft.ruleengine.sqlrulestore_members.aspx (SQLRuleStore)

http://arnulfowing.blogspot.com/2008_07_01_archive.html

http://biztalkwithshashikant.blogspot.com/2007/08/implementing-business-rule-engine.html

http://msdn.microsoft.com/en-us/library/aa951249.aspx

iFactRetriever: http://msdn.microsoft.com/en-us/library/aa560118.aspx

http://talentedmonkeys.wordpress.com/2011/01/17/improved-method-for-calling-the-bre-from-net-applications/

http://talentedmonkeys.wordpress.com/2010/08/23/calling-the-bre-from-net-applications/

Read more ...

Advanced Users Biztalk WIKI : Useful How to Links Part - 5

 Useful How to Links Part - 5

Bre Static Support Key

http://blogs.msdn.com/b/asgisv/archive/2010/04/29/troubleshooting-bre-policies-failing-to-return-results.aspx 

http://blogs.msdn.com/b/richardbpi/archive/2005/11/14/492489.aspx

http://technet.microsoft.com/en-us/library/aa950269(BTS.10).aspx

Calling Data Access from Ado.Net

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

http://www.codeproject.com/Articles/15403/Calling-Stored-procedures-in-ADO-NET

http://msdn.microsoft.com/en-us/library/59x02y99.aspx

Sso Configuration Storing Values

http://biztalk-dev.blogspot.com/2008/03/using-sso-database-for-storing.html

Xml Document XPath Sample

http://www.codeproject.com/Articles/9494/Manipulate-XML-data-with-XPath-and-XmlDocument-C

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

ESB Dynamic Routing using Itineraries

http://abhijitmahato.wordpress.com/2010/09/10/biztalk-esb-toolkit-2-0-samples-content-based-routing/

http://tenalinaga.wordpress.com/2010/11/12/esb-dynamic-resoultion-with-bre-and-uddi-and-itineraries/

http://www.go4answers.com/Example/dynamic-itinerary-orchestration-48755.aspx

http://talentedmonkeys.wordpress.com/2010/04/24/resolving-a-dynamic-send-port-in-a-biztalk-orchestration-using-esb-toolkit-2-0/

http://blogdoc.biztalk247.com/article.aspx?page=7f047745-aa05-4090-bab1-d8742ab23a58

http://allcomputers.us/windows_server/biztalk-2010-recipes---administration-and-operations---debugging-orchestrations.aspx

http://blogs.msdn.com/b/appfabriccat/archive/2010/06/23/4-different-ways-to-process-an-xlangmessage-within-an-helper-component-invoked-by-an-orchestration.aspx

Read more ...

Advanced Users Biztalk WIKI : Useful How to Links Part - 4

Useful How to Links Part - 4

Iterate ArrayList in BRE Business Rules

http://msdn.microsoft.com/en-us/library/aa577384(v=BTS.20).aspx

Programming with Business Rules Framework

http://msdn.microsoft.com/en-us/library/aa561833(v=bts.20).aspx

How to Script Import/Export and Deployment of Business Policies using FileRuleStore

http://msdn.microsoft.com/en-us/library/aa559518(v=bts.20).aspx

SSO Configuration Store Application

http://seroter.wordpress.com/2007/09/21/biztalk-sso-configuration-data-storage-tool/

http://www.novaenterprisesystems.com/Blog/post/Configuration-Best-Practices.aspx

http://blogs.msdn.com/b/vishalag/archive/2008/06/22/biztalk-configuration-store.aspx

http://social.msdn.microsoft.com/Forums/eu/biztalkgeneral/thread/7af04214-0f8e-40a7-ba3b-062be80598ad

http://whiteboardworks.com/2010/03/unit-testing-biztalk-business-rule-engine

Tool Source Code:

http://seroter.wordpress.com/2008/02/28/sso-config-data-store-tool-biztalkwcf-scenario-source-code-available/

Here are a few TechNet Wiki articles that have become available recently. I have usually found it difficult to find relevant content on the TechNet Wiki so I thought it would be good to highlight a few of these.

Improving performance when executing a BRE rule:

 http://social.technet.microsoft.com/wiki/contents/articles/high-cpu-when-executing-a-business-rules-engine-bre-policy.aspx

Implement ordered messaging with BizTalk and SSIS:

 http://social.technet.microsoft.com/wiki/contents/articles/implementing-end-to-end-ordered-delivery-using-microsoft-biztalk-server-and-sql-server-service-broker.aspx

BizTalk load testing in VS 2010:

 http://social.technet.microsoft.com/wiki/contents/articles/load-testing-biztalk-server-solutions-with-visual-studio-2010.aspx

Load testing for simultaneous BizTalk unit tests:

 http://social.technet.microsoft.com/wiki/contents/articles/create-a-load-test-to-perform-multiple-unit-tests-simultaneously.aspx

Install and configure BAM in a multi-server environment: http://social.technet.microsoft.com/wiki/contents/articles/install-and-configure-bam-business-activity-monitoring-in-a-multi-computer-environment.aspx

Read more ...

Advanced Users Biztalk WIKI : Useful How to Links Part -2

Useful How to Links Part -2

Implementing Biztalk Pipeline Trace

http://seroter.wordpress.com/2007/01/22/biztalk-application-tracing-part-i/

Biztalk Orchestration Tracing Using Biztalk Diagnostics Library

http://biztalkdiagnostics.codeplex.com/

http://www.codeplex.com/site/search?query=biztalk&ac=2

High Performance Message Transform Alternative to XslTransform vs Xsl 

CompileTransform

http://blogs.msdn.com/b/paolos/archive/2010/01/29/how-to-boost-message-transformations-using-the-xslcompiledtransform-class.aspx

Dynamic Mocking With N-Mock

http://msdn.microsoft.com/en-us/magazine/cc163904.aspx

Biztalk 2010 Documentation

http://www.microsoft.com/download/en/details.aspx?id=11503

Validating Incoming Xml using BRE

http://seroter.wordpress.com/2009/11/11/validating-incoming-data-using-the-biztalk-business-rules-engine/

BizTalk: Delivery Notification in Direct Send Ports

http://agilior.pt/blogs/bruno.camara/archive/2008/04/17/4344.aspx

BizTalk XSLT Reuse (xsl:include) by using MS Build

http://www.peterdol.nl/blog/biztalk-xslt-reuse-xslinclude-by-using-ms-build/

BizTalk Orchestrations XPath: Survival Guide http://social.technet.microsoft.com/wiki/contents/articles/6944.biztalk-orchestrations-xpath-survival-guide.aspx

BizTalk Server: Performance Tuning & Optimization

http://social.technet.microsoft.com/wiki/contents/articles/7801.biztalk-server-performance-tuning-optimization.aspx

http://social.technet.microsoft.com/wiki/contents/articles/5109.biztalk-databases-survival-guide.aspx

http://social.technet.microsoft.com/wiki/contents/articles/7253.biztalk-server-2010-database-biztalkdtadb.aspx

Read more ...

BizTalk and MSDTC , DTC , Transactions

Microsoft Distributed Transaction Coordinator (MSDTC) is an important component in a BizTalk environment. Especially in multi-server environment it is mandatory and needs to setup and configured properly before one starts configuring BizTalk features like group, BRE or BAM. During configuration of these BizTalk features, databases like BizTalkMsgBoxDb, BizTalkMgmtDb, BizTalkDTADb (tracking archiving), BizTalkRuleEngineDb, or BAMPrimairyImport and other (BAMStar, ect) are created on database server. MSDTC is component inside Component Services (Windows 2003, Windows 2008). Below is a screen from DTC inside Component Services Windows Server 2008.

 

By right clicking Local DTC you can configure it via three tabs (Tracing, Logging, and Security). To enable MSDTC on Windows Server 2003 or 2008 you can find that on this MSDN page.

Below is a screen from DTC inside Component Services Windows Server 2003.

There are three tabs available and first on is Tracing (this accounts W2K8):

Above screens show default settings (and is first tab shown if you right click local DTC –> Properties). There is an excellent explanation via official Distributed Services Support Team blog that explains what you can do here. Second tab is Logging:

This tab self explanatory I think. The Microsoft Distributed Transaction Coordinator (MS DTC) log file is in the %windir%\system32\Msdtc directory by default. More on choosing where to put log file you can find here. The third tab is the most important one having DTC work properly:

 

Note: DTC account can be changed, look here how and consider if it is necessary. It can be trickydepending on Operating Systems you are working.

Depending on your Operating System you need to set the following settings (above shows the default settings on Windows 2008).

Configuration Option	Default Value W2K3	Default Value W2K8	Recommended value
Network DTC Access	Enabled	Enabled	Enabled
Client and Administration
Allow Remote Clients	Disabled	Disabled	Disabled
Allow Remote Administration	Enabled	Disabled	Disabled
Transaction Manager Configuration
Allow Inbound	Enabled	Enabled	Enabled
Allow Outbound	Enabled	Enabled	Enabled
Mutual Authentication Required	Disabled	Disabled	Enabled if all remote machines are running Win2K3 SP1 or XP SP2 or higher.
Incoming Caller Authentication Required	Disabled	Disabled	Enabled if running MSDTC on cluster.
No Authentication Required	Disabled	Disabled	Enabled if remote machines are pre-Windows Server 2003 SP1 or pre- Windows XP SP2.
Enable XA Transaction	Disabled	Disabled	Enabled if communicating with an XA based transactional system such as when communicating with IBM WebSphere MQ using the MQSeries adapter.

To validate the connection between BizTalk Server and SQL Server machines you can use DTCPing. Also take into consideration that firewall can block access. To configure firewall on W2K3 you can gohere and for W2K8 here.

Besides DTCPing there is also a tool called DTCTester. Latter utility is to verify transaction support between two computers, if SQL Server is installed on one of the computers. The DTCTester utility uses ODBC to verify transaction support against a SQL Server database. For more information about DTCTester see How to Use DTCTester Tool. DTCPing is to verify transaction support between two computers, if SQL Server is not installed on either computer. The DTCPing tool must be run on both the client and server computer. For more information about DTCPing, see How to troubleshoot MS DTC firewall issues.

To troubleshoot MSTDC you can also find valuable information at this MSDN page and summary of other useful tools here. I hope that if you are building a multi-server BizTalk environment that this information gathered here can help you setup and configure MSDTC properly before you start configuring BizTalk features.

Source SteefJanwiggersBlog

Read more ...