BizTalk Server 2013 R2 BHM toolBizTalk 2013 R2 ships with a new tool called as “BizTalk Health Monitor”. BHM is freely available for all BizTalk 2013 R2 users. More about BHM tool at BizTalkHealthMonitor
Recently my system event viewer was filled with the below ENTSSO error and all my Biztalk application stopped working.
The error saysDescription: An error occurred while attempting to access the SSO database. Function: LookupXp File: lookupserver.cpp:283 Arithmetic overflow error converting IDENTITY to data type int. Arithmetic overflow occurred.. SQL Error code: 0x00001FB3 Error code: 0xC0002A21, An error occurred while attempting to access the SSO database..
The reason for the above error is that the identity column in the SSOX_AuditXPLookup had crossed the maximum limit and this cause the SSO lookup function to failing.The resolution for this issue is we need to Reseed the identity column of this table, but its always safe to take back up of BizTalk database and Master secret. Also, stop all the process using the database before doing the reseed.
Steps for Reseed:-Stop ENTSSO Service, BizTalk host instances, IIS and SQL server agent jobs. Run the cmd in sql server DBCC CHECKIDENT (SSOX_AuditXPLookup, RESEED, 1)Start the Services that were stopped.Manual steps to modify the data type of xl_identity from int to bigint are provided at http://support.microsoft.com/kb/980960.
Written byShashidharan Krishnan \ Kshitj Dattani
Reviewed byJainath V R
Microsoft India GTSC