We had an issue, the DTA database was empty, nothing was being tracked, and we were seeing a weird error message that pointed at something else in the event log: Either another TDDS is processing the same data or there is an orphaned session in SQL server holding TDDS lock. Either another TDDS is processing the same data or there is an orphaned session in SQL Server holding TDDS lock. SQL Server: \. Database: BizTalkDTADb   more »

What do you do if you have over 1000 suspended orchestrations, each one would have put a message to the event log when it suspended, however the event log entry does not tell you which instance of the orchestration generated the message, given they could all be the same orchestration called many of times that is failing. How to know which one to look into, and recover from?   more »