When we try to delete BizTalk application or Map from BizTalk Admin console, we might get this type of error and this error might occur on every environment from development machines to production servers.
Error :
"Error while removing application "BT Project name".
Schema referenced by Map ‘BTProject’ 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."
By Mistake I deployed the BizTalk Map project before the BizTalk
schema project. The BizTalk Map project were having reference to BizTalk Schema
project. When I tried to delete the deployed BizTalk project it gave me above
error.
And every time you refresh BizTalk Admin console you will
get the above error.
Solution :
To fix the above error you need to manually delete entry
from table bt_mapspec, this table is located
inside BizTalkMgmtDB,
You can refer following queries to delete the map
-- Locate the itemId of the map
Select * from bt_mapspec
-- Using the itemId retrieved above delete the map
Delete from bt_mapspec Where
itemid = 'itemId_of_map'
Delete from
bt_mapspec Where assemblyid = ‘id’
After executing above SQL query, just refresh the BizTalk
admin console. It should work now.
Love BizTalk, Think
BizTalk!!!
Biztalk Server Online Training - Biztalk Admin Online Training
ReplyDeletehttp://www.21cssindia.com/courses/biztalk-server-online-training-213.html
COURSE OUT LINE
Introductions to Enterprise Application Patterns and BizTalk Server, Understanding BizTalk Framework, Setting up a BizTalk Server Environment, Messaging Architecture, Setting up a BizTalk Server Environment Engine, Business Activity Monitoring, WCF Services Schemas in BizTalk, Transformations in BizTalk, The BizTalk Messaging Engine and Pipelines, Adapters in BizTalk, Orchestrations, Advanced Orchestrations, Integration Patterns in BizTalkBizTalk Rules with BizTalk, Testing BizTalk Artifacts, BizTalk Server Instrumentation, Error Handling, and Deployment,Tracking and Deploying BizTalk Solutions, Monitoring and Maintenance, Administration, BizTalk Server Performance andTuning, BizTalk Tools, BizTalk 2013 Features, ESB Toolkit 2.
If you are seeking training and support you can reach me on 91-9000444287. contact@21cssindia.com
Biztalk Admin Online Training - http://www.21cssindia.com/courses/biztalk-admin-online-training-220.html
ReplyDeleteOverview - What is Business Process? - Need to Integrate - What is Integration? - Challenges without Integration - Challenges in Business Integration - BizTalk Server - Other Products available in Market - Comparison of BizTalk with Tibco, Web methods & SAP PI - Comparison of BizTalk with SSIS and WPF - Employees to learn at their own pace and maintain control of learning “where, when and how” with boundless access 24/7by 21st Century Software Solutions. contact@21cssindia.com ---- Call Us +919000444287