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 When I tried to deploy a biztalk application to the server, I got an the error “Could not change the bindings for orchestration ‘orchestration_name_here’, Version=x.x.x.x,Culture=neutral, PublicKeyToken=sometoken’ as one or more instances of the orchestration still exist”. Now what? What does it mean? Quite simply, you have a resumable message sitting in the queue. If […]
Tweet This script will give you a count of all messages by orchestration within BizTalk. This includes currently processing messages.
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, […]