Geeks With Blogs
Stuart Brierley Integration Management - BizTalk and More

While undeploying a BizTalk Applciation recently something went wrong, leaving BizTalk in a strange state.

When opening the BizTalk Server Administration Console the following message would be displayed:

Schema referenced by Map 'xxxxxxx' 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.

The problem with this was that any attempt to refresh the BizTalk group in the console failed.

I also tried such things as service and server restarts but nothing so simple worked. 

Following various leads lead me to look at the bt_mapspec table in the BizTalkMgmtDb database.  Here I saw that, although the application and all other artifacts of the application had been removed, there was still an entry for the map that the error was reporting on.

Deleting this entry allowed the group to be refreshed and the undeployment and deployment of updated applications have since been working without any problems.

DELETE FROM bt_mapspec WHERE itemid = xxx


Posted on Friday, September 9, 2011 11:27 AM BizTalk Administration and Troubleshooting | Back to top

Comments on this post: BizTalk Administration - Schema referenced by Map has been deleted

# re: BizTalk Administration - Schema referenced by Map has been deleted
Requesting Gravatar...
How to you go about avoiding all the constraints? When i tried to delete, there are a bunch of tables referencing to each other therefore i couldn't delete.
Left by Kevin Nguyen on Jan 04, 2018 8:33 PM

Your comment:
 (will show your gravatar)

Copyright © Stuart Brierley | Powered by: