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
--------------------

1 Comments:

At 4:29 PM, Blogger The Computer Guys said...

Yo, you have a Terrific blog here! Lots of content means more readers, more readers means more interaction!
I'm definitely going to bookmark you!
I have a
free window xp softwaresite/blog. It pretty much covers free window xp software related stuff.
Come take a Look when you get a chance. :-)

 

Post a Comment

<< Home