Since I always have a hard time remembering where it is and what to run, there are two scripts that you can run in your non-production region that can clean up currently running orchestrations that you have already terminated and it is waiting to clear it up.
You will first need to go and create the real stored procedure bts_CleanupMsgBox (this replaces the shell that is there).
The instructions are as follows to clean it up:
- Stop BTS.
- Do IISRESET if you are using web services.
- Run “bts_CleanupMsgbox” on your message box database. This will mark your instances for deletion and it will not actually delete it.
- Run “bts_PurgeSubscriptions” on your message box database. This will purge all your messages marked for deletion.
- Restart your BTS.