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 […]
Tweet This query will give you a list of the BizTalk Hosts:
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, […]
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.
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.
Tweet This Script will give you detailed information on suspended message in BizTalk. Run this script against the BizTalkMsgBoxDb.
Tweet This SQL Script will give you the count of all suspended messages in BizTalk. Run this against the BizTalkMsgBoxDb.
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, […]
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 […]