Message Box cleanup

It is usually a very important task to clean up a BizTalk mseeage box during stress testing with large amount of messages. Below are the steps to clean up the message box in order to prepare for the new test.

1. Stop all BizTalk services

2. Type iisreset at command line to recycle IIS service

3. Execute the stored procedure bts_CleanupMsgbox on your message box database

4. Execute the stroed procedure bts_PurgeSubscriptions on your message box database

(if the above stored procedures can't be found, go to your BizTalk installation directory, under “Schema” folder, you can find all original scripts of these stored procedures)

5. Clean up the message box log by running the backup statement similar to below

backup log msgBoxDb to disk = 'yourbackupdirectory\yourbackupfile.bak' with init, stats = 5

6. Restart BizTalk services

Comments

Anonymous said…
Woah! I'm really loving the template/theme of this website.

It's simple, yet effective. A lot of times it's hard to get that "perfect balance"
between superb usability and appearance. I must say that you've done a
great job with this. In addition, the blog loads very fast for me on Internet explorer.
Outstanding Blog!

my weblog; garcinia cambogia with 60 hca
March 11, 2014 at 11:30 PM
Anonymous said…
Very good website you have here but I was curious about if you knew of any community forums
that cover the same topics discussed here? I'd really like to be a part of online community where I can get feed-back from
other knowledgeable individuals that share the same interest.
If you have any suggestions, please let me know. Appreciate it!


Have a look at my site; good heart foods
March 15, 2014 at 12:35 PM
Armen Kirakosyan said…
Hi
You can easily find communities in MSDN forums
March 15, 2014 at 4:21 PM
Post a Comment

Popular posts from this blog

Testing Azure Functions locally with automated integration test

Image
I am investing more and more time and efforts into building Azure Functions and using serverless instead of WebApps. Greater stability and balancing makes it my first choice when need high quality API. Being big fun of automated testing, faced some issues when coding tests and could not find any useful/working examples. Sources can be found here Some steps here Create function with HTTP trigger using template, dont need anything fancy there. Base it on .Net Core 3.1, you can change it, but then check the path in Test project Create MS Test project Folder structure Project structure Important step, install Azure Function tools from command line, just run npm i -g azure-functions-core-tools after that you can test if it is available from command line The idea is to start functions engine from test project. In local environment you can start it from your command line using Func utility, same can be done from Test project. From command line it will look like this F
Read more

XML debatch in pipeline

Image
Last month I had a post were described how to debatch XML message in orchestration using XPath. http://biztalk.kirakosyan.com/2010/02/debatching-records-from-wcf-sql-using.html How I wrote it is not the best solution , in case if you will have hundreds of records the debatching using XPath will consume too much memory and processor. In this post I am going to show how to debatch using pipeline. The sample will fetch multiple records from MS SQL database and after debatching put them to folder. How to create simple WCF-SQL ports and SQL polling you can read in my old post http://biztalk.kirakosyan.com/2010/02/how-to-pull-database-using-wcf-sql.html I will use the same procedure and table to generate Schemas and PortTypes In generated schema change envelop type to yes Next click on TypePolling which is the root for schema In properties find Body XPath and edit it as in picture is Then change the last node to have Max Occurs = 1 Now we should remove hidden stones :-) When you
Read more

How to poll database using WCF-SQL adapter

Image
1. Create database and tables 2. Create stored procedure 3. Create BizTalk project 4. Create orchestration 5. Consume WCF-SQL 6. Write received data to file share First create TESTWCFSQL database from you SQL Management studio Run the script to create table: USE TESTWCFSQL GO IF OBJECT_ID('dbo.MainData', 'U') IS NOT NULL DROP TABLE dbo.MainData GO CREATE TABLE dbo.MainData ( MainDataID int primary key identity(1,1), FirstName nvarchar(30), LastName nvarchar(30), Amount int ) GO Run script in SQL management studio to create procedure IF EXISTS ( SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE SPECIFIC_SCHEMA = N'dbo' AND SPECIFIC_NAME = N'PollData' ) DROP PROCEDURE dbo.PollData GO CREATE PROCEDURE dbo.PollData AS select MainDataID, FirstName, LastName, Amount from dbo.MainData delete from dbo.MainData GO insert some sample lines executing use TESTWCFSQL insert into MainData (FirstName, LastName, Amo
Read more