Monday, August 23, 2004

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