FW: cocould not change the bindings for orchestration-One or more instances of the orchestration

Source: Internet
Author: User
Tags biztalk

Lately I tried to redeploy a BizTalk 2006 solution from Visual Studio 2005. unfortunately I was confronted with the following error message "cocould not change the bindings for orchestration '. ', Version = 1.0.0.0, Culture = neutral, PublicKeyToken = c380e04620d206e8' as one or more instances of the orchestration still exist ".
When I tried to Unenlist and delete the Orchestration from the BizTalk Administration tool, I Have ed the same error.
I found out that I had a few suspended instances. These instances need to be terminated before you can undeploy/redeploy the orchestration.
Terminating instances can be done in several manners:
-The polite manner: by terminating the instances using the BizTalk Administration Tool
-The not so polite manner: by using a Stored Procedure to clean up the MessageBox
Removing instances using the BizTalk Administration Tool
In the BizTalk Administration Group click in the left pane on 'biztalk Group [Name of Computer/Name of Management database'. in the right pane the 'group overview' appears. click on the tab page 'new query' to create a query that searches for the sushortded instances. in the 'query expression' grid the first Search field is already selected, namely 'search For ', also the 'eques' operator is alread Y filled in the second field. All we have to do in the 'value'-field is search for suspended instances. And... Lucky us: when we open the dropdown box we see that 'suincluded Service instances' is one of the values we can choose! Next, we run the query by hitting the button with the label 'run query '. the grid 'query results' now contains all susponded instances found. all we need to do is select all suspended instances, right click on the selection and choose 'terminate instances '. the BizTalk Administration Tool asks for confirmation and removes the instances. when you rerun the query, the instances will be removed and the orchestration can be undeployed/redeployed. so far for the polite manner.
Removing instances using a Stored Procedure
The less polite manner to remove suspended instances is by running a Stored Procedure which will clean up the MessageBox. Attention: this is NOT a recommended procedure on production environments!
Open the SQL Server Management Studio and connect to the database server. in the left pane expand the server-node and the Databases-node. next, click on the MessageBox-database (BizTalkMsgDb) and hit the 'new query'-button in the toolbar. in the right pane you can enter SQL commands. since you selected the MessageBox-database in the left pane, the commands are executed against that database. now ty Pe: 'exec bts_CleanupMsgbox 0' (without the quotes) and hit '! Execute '-button in the toolbar. All suincluded instances will now be removed. You can now undeploy/redeploy the orchestration.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.