Ask a new question

Biztalk Server 2016 issue

Infra detail of Biztalk server enviornment

Multi node enviornment (one node is primary and another one is joined to that group)

MSSQL server database- BizTalk db's are distributed in two servers (MSSQL Server Instance1: BizTalkmsgboxDB & BizTalkmgmtDB, MSSQL Server Instance 2: BizTalkDTADb & SSODB).

In our enviornment BiztalkTalk server logging a error message in Event log for every 9-10Min.

Error message:

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. SQLServer: xxxxx, Database: BizTalkDTADb.

Permissions are properly granted as per the microsoft documents and also from the blogs, but issue is still exist.

Please check and give me the suggestion.

Your question is out of scope in these consumer-oriented forums. Please ase Biztalk questions in the Biztalk forum on MSDN (https://social.msdn.microsoft.com/Forums/en-US/...), on Technet (https://social.technet.microsoft.com/Forums/en-...), or on the TechCommunity (https://techcommunity.microsoft.com/t5/biztalk-...)
Brian

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Thank you very much Brian,

Updated my queries in Biztalk server general group, hope for the best.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated August 24, 2020 Views 25 Applies to: