August 21, 2018
BizTalk DTA Purge And Archive Job Error: Unspecified error occurred on SQL Server. Connection may have been terminated by the server. [SQLSTATE HY000] (Error 0) Unable to find index entry in index ID 1, of table xyz, in database ‘BizTalkDTADb’. The indicated index is corrupt or there is a problem with the current update plan. Run DBCC CHECKDB or DBCC CHECKTABLE. If the problem persists, contact product support. [SQLSTATE HY000] (Error 8646). The step failed.
Time to Read: 6 minutes Problem Statement Today when I ran the BHM to check the health of my BizTalk development box, I found that the BizTalk job DTAPurgeAndArchive job was failing continuously. When I opened the history for the job, I found following error logged in the history. “Current Error: ABC\BiztalkService. Unspecified error occurred on SQL Server. Connection may have been terminated by the...