Undeploy Error in BizTalk Explorer
I was clueless when I got this error when I undeploy the assembly using BizTalk Explorer or using WMI script.
SQL exception: I/O error 23(Data error (cyclic redundancy check).) detected during read at offset 0x00000000630000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL\data\BizTalkMgmtDb.mdf'.
Finally got the UnDeploy done in SQL way. Just run the below sql script in your Biztalk DB and delete your assembly from GAC manually.
-------------------
use BiztalkMgmtDB
go
declare @iAssemblyID int
select @iAssemblyID=nID from bts_assembly where nvcName = 'yourAssemblyName'
delete from bt_mapspec where assemblyid = @iAssemblyID
delete from bt_documentspec where assemblyid = @iAssemblyID
delete from bts_item where assemblyid = @iAssemblyID
delete from bt_properties where nassemblyid = @iAssemblyID
delete from bt_sensitiveproperties where assemblyid = @iAssemblyID
delete from bts_assembly where nID = @iAssemblyID
--------------------
0 Comments:
Post a Comment
<< Home