BizTalk 2010 Error: Schema referenced by Map 'Map name goes here' has been deleted.

When my BizTalk 2006 R2 applications going to be migrated to BizTalk 2010, I did test run on my test server (BizTalk 2010 on Windows 2008R2 64bit).

Then I choose one of simple live-running application to test with, and I got following error in BizTalk administration console.

TITLE: BizTalk Server Administration
------------------------------ 
Schema referenced by Map 'Map name goes here' has been deleted. The 
local, cached version of the BizTalk Server group configuration is out of date. 
You must refresh the BizTalk Server group configuration before making further 
changes. (Microsoft.BizTalk.Administration.SnapIn) 
For help, click: http://go.microsoft.com/fwlink/?LinkId=47400&ProdName=Microsoft+BizTalk+Server+2010&ProdVer=3.9.469.0&EvtSrc=Microsoft.BizTalk.ExplorerOM.Resources&EvtID=IDS_ERR_FIND_SCHEMA 

This is yet another message from BizTalk with no help at all.  I could not be able to refresh whole BizTalk Group\Applications Node in the BizTalk Administration console. I spent couple of hours ,while scratching my head, to find a solution.

Solutions like, restarting BizTalk service, Administration console, etc did not work. But I found solution (not my own) which is really works though it is not recommended.

The solution is SQL,

-- Run bellow queries against BizTalkMgmtDb database.

-- You can find the related item here
SELECT * FROM bt_mapspec

-- Replace with correct itemid value
DELETE FROM bt_mapspec WHERE itemid =165 

Reason:

One of blog post suggests, it could be the reason when the Map and references Schemas are in separate assemblies. I can agree with it, i believe , in this application the map and its source schema in two separate assemblies.