Find Orphaned DTA Service Instances with SQL Query
Tweet I was trying to find what messages were being orphaned, so I started doing a little digging to figure out how I could get more detail. With that being said, I still use the Terminator to fix the issue. I do NOT recommend updating or changing any messages in the messagebox without consent from […]
SQL Query to list BizTalk Hosts
Tweet This query will give you a list of the BizTalk Hosts:
Monitor BizTalk Server (BizTalkMgmtDb) SQL Job Fails
Tweet A client was experiencing failures with the BizTalk job Monitor BizTalk Server (BizTalkMgmtDb), which calls stored procedure [dbo].[btsmon_Inconsistent]. This proc calls several other stored procedures to cleanup the messagebox and other meta-tables within BizTalk. These procs generate dynamic SQL scripts and to run against the tables within the BizTalk databases. Depending on your configuration, […]
How to Clear or Purge the Biztalk Tracking Database
Tweet Stop all running Biztalk services, load up SQL Management Studio, on the BiztalkDTADb database run the following script. Note that this script does not archive data. The last part shrinks the database and log files.
Count of Active or Started Messages in BizTalk.
Tweet This script will give you a count of active messages within BizTalk. This includes currently processing messages, as well as suspended resumable messages. Run this against the BizTalkDTADb.
SQL Script for suspended message detail in BizTalk
Tweet This Script will give you detailed information on suspended message in BizTalk. Run this script against the BizTalkMsgBoxDb.
Count of Suspended Messages in BizTalk
Tweet This SQL Script will give you the count of all suspended messages in BizTalk. Run this against the BizTalkMsgBoxDb.
BizTalk Macros
Tweet Here is a list of the File Name Macros. You can use a combintation of these to create your file names in the FILE transport properties (see screen shot below). Macro Definition %datetime% Coordinated Universal Time (UTC) date time in the format YYYY-MM-DDThhmmss (for example, 1997-07-12T103508). %datetime_bts2000% UTC date time in the format YYYYMMDDhhmmsss, […]
Starting BizTalk Server
Tweet I am starting on Microsoft BizTalk server today. I will be posting information on my progress. With my Service Oriented Architecture (SOA) background, the concepts are very familiar. I wish I would have started sooner, as BizTalk solves a lot of problems with moving data between systems. I will keep you posted! Looking forward […]