Solution With Id = 86ac16ec-41d7-4685-a330-0b1c31411260 Does Not Exist

In some rare scenario's you might get the error message "solution With Id = 86ac16ec-41d7-4685-a330-0b1c31411260 Does Not Exist" while deleting a solution. In our scenario this seems to happen after using the holding solution approach. Luckily this can be solved as long as you have access to the SQL database. Note: Direct SQL updates are unsupported, so only perform this action if you're aware of the risks.

The error appears due to some remaining AttributeMap records for virtual attributes. In more detail, when you create an attribute map between two entities for a lookup attribute, it not only creating an attribute map for the id of the entity, but also for the name of that particular lookup. So in case of an account mapping, it creates an attribute map for accountid as well as accountidname. After moving around with solutions, CRM occacionally forgets to update the owning solution id for the 'name' attribute mappings.

You can visualize the relevant attributes using the following query:

SELECT
 a.SolutionId,
 a.SourceAttributeName,
 a.TargetAttributeName,
 pa.SolutionId,
 pa.SourceAttributeName,
 pa.TargetAttributeName
FROM attributemapbase a
LEFT OUTER JOIN attributemapbase pa
 ON a.parentattributemapid=pa.attributemapid
WHERE a.solutionid='86ac16ec-41d7-4685-a330-0b1c31411260'

You'll see the virtual attributes with their parent attributes and the corresponding solutionid according to the attribute map. The mismatch between the solutionid of the attributemap and the solutionid of the parent attribute map is what causes the error while deleting the solution. Updating the solutionid will solve the issue for you. Here's the query to help you perform this action. Obviously you'll need to change the solutionid to the solutionid as presented to you when downloading the error log file:

UPDATE AttributeMapBase
 SET SolutionId = pa.solutionid
 FROM AttributeMapBase
LEFT OUTER JOIN AttributeMapBase AS pa
 ON AttributeMapBase.ParentAttributeMapId = pa.AttributeMapId
WHERE AttributeMapBase.SolutionId = '86ac16ec-41d7-4685-a330-0b1c31411260'

I'm sure Microsoft will fix this issue sooner or later, but for now I hope this post will help you anyway.


Update:
Apparently there are other scenario's when this error occurs as well. When you create a businessrule, then on the database a record will be created in the "WorkflowBase" will be created, as well as one or more records in the "ProcessTriggerBase". For some reason it is possible that the records in the ProcessTriggerBase are not updated to the new solution ID, resulting in an incorrect record. While deleting a managed solution the deletion process recorgnized the non existing SolutionID and causes the delete to stop.

The way to identify the business rule that is causing the issue, you can run the following query:

select ptb.ProcessId, wb.Name, ptb.solutionid, wb.solutionid
from
 
 
ProcessTriggerBase ptb
 
left join WorkflowBase wb on ptb.ProcessId = wb.WorkflowId
where
ptb.solutionid='86ac16ec-41d7-4685-a330-0b1c31411260'

You then can delete this business rule by hand using the advanced find (search for all processes with category=business rule). Once this rule is removed, then the solution can be uninstalled.

40 comments:

Hans Nellestijn said...

Hi Ronald,

Thanks, you made my day!
We regularly use the "holding solution approach" and I regularly got this error-message. Again, your blog is the only one found with a real solution to this.

Ronald Lemmen said...

Much appreciated Hans!

ax dynamics said...

Hello! Thank you for sharing this, I had no Idea how to remove the message and fix this error. Thanks for help, I’m a beginner in erp software sphere, but I’m trying to do my best and learn some new features.

Packers and movers bangalore said...

Packers-and-movers-bangalore.in provides all the type of #moving solutions, no matter where you want to shift into the city or shift another city or another country ..
Packers And Movers Bangalore Charges

Packers Movers Gurgaon said...

Really impressive post. I read it whole and going to share it with my social circules. I enjoyed your article and planning to rewrite it on my own blog.
Packers And Movers Gurgaon
Packers And Movers In Gurgaon charges

Packers Movers Gurgaon said...

We Provide Best Packers And Movers Gurgaon List for Get Free Best Quotes, Compare Charges,
Save Money And Time, Household Shifting Services @ http://packers-and-movers-gurgaon.in/
Packers And Movers Bangalore to hyderabad

Packers And Movers Bangalore said...

I must say you had done a tremendous job,I appreciate all your efforts.Thanks alot for your writings......Waiting for a new 1...Please visit our wonderful and valuable website-
Packers And Movers Bangalore

Packers And Movers Bangalore said...

Packers And Movers Indiranagar Bangalore



Packers And Movers Electronics City bengaluru

Packers And Movers Marathahalli Colony bengaluru

Packers And Movers whitefield Bangalore

Packers And Movers Hsr Layout bengaluru

packers and movers hyderabad said...

Thanks on your marvelous posting! I really enjoyed reading it, you’re a great author.Please visit here:
Packers And Movers Hyderabad

rahul sharma said...


packers and movers pune
packers and movers indore
packers and movers gurgaon

James R said...

Hi, Ronald - I know this is an old blog but have you ever had this issue with a web resource?

Packers And Movers Jaipur said...

Brilliant information being shared here with us,This is very interesting, You’re a very skilled blogger.Plz visit here: Packers And Movers Jaipur

Packers And Movers Jaipur said...

Packers And Movers Jaisalmer
Packers And Movers Jodhpur
Packers And Movers Udaipur
Packers And Movers Abu Road
Packers And Movers Banswara
Packers And Movers Barmer
Packers And Movers Bundi
Packers And Movers Chomu

Packers And Movers Jaipur said...

Packers And Movers Jaipur to Mumbai
Packers And Movers Jaipur to Haridwar
Packers And Movers Jaipur to Noida
Packers And Movers Jaipur to Leh
Packers And Movers Jaipur to Guntur
Packers And Movers Jaipur to Muzaffarpur
Packers And Movers Jaipur to Indore
Packers And Movers Jaipur to Surat

packers and movers chennai said...

An excellent information provided thanks for all the information i must say great efforts made by you. thanks a lot for all the information you provided.
Packers And Movers Chennai

packers and movers chennai said...

Packers And Movers Chennai to Jaipur
Packers And Movers Chennai to Mumbai
Packers And Movers Chennai to Delhi
Packers And Movers Chennai to Gurgaon
Packers And Movers Chennai to Kolkata
Packers And Movers Chennai to Bhubaneswar
Packers And Movers Chennai to Bhopal
Packers And Movers Chennai to Lucknow
Packers And Movers Chennai to Chandigarh

packers and movers chennai said...

Packers And Movers Kanyakumari Tamilnadu
Packers And Movers Karur Tamilnadu
Packers And Movers Krishnagiri Tamilnadu
Packers And Movers Madurai Tamilnadu
Packers And Movers Nagapattinam Tamilnadu
Packers And Movers Namakkal Tamilnadu
Packers And Movers Nilgiris Tamilnadu
Packers And Movers Perambalur Tamilnadu
Packers And Movers Pudukkottai Tamilnadu
Packers And Movers Ramanathapuram Tamilnadu

Coimbatore Ooty Taxi said...

Wonderful ! Thanks for Sharing this article keep update this kind of nice articles ..

AGARWAL PACKERS said...

Manish Packers and Movers Pvt Ltd
Packers and Movers Bangalore
Packers and Movers Gurgaon
Packers and Movers Indore
Packers and Movers Kolkata
Packers and Movers Mumbai
Packers and Movers Nagpur
Packers and Movers Raipur
Packers and Movers Ahmedabad
Packers and Movers Indore

cavin straut said...

pogo support number is available to customers covered by Support and Subscription contract. PoGo Technical Support is delivered primarily in English except where local language availability is noted. Most Pogo Support Number listed for Phone assistance is toll-free Number 1833-442-7444. which will directly connect you with the Pogo Support and get you necessary help. For More Info>>> pogo games not loading, Pogo games not loading, Pogo support number, Pogo games not working, Pogo technical problem

Indian World Packers and Movers said...

Thanks for your great article. Totally super evrything you said. Kindly visit us @
Packers and movers tuticorin
Packers and movers nagercoil

Manish Packers and Movers Pvt Ltd said...

Packers and Movers Dewas Naka Indore
Packers and Movers Vijay Nagar Indore
Packers and Movers Scheme 54 Indore
Packers and Movers Delhi
Packers and Movers Pune
Packers and Movers Jodhpur
Packers and Movers Kanpur
Packers and Movers Ghaziabad
Packers and Movers Noida
Packers and Movers Navi Mumbai

Manish Packers and Movers Pvt Ltd said...

Manish Packers and Movers Pvt Ltd as a Services providing company can make all the difference to your Home Relocation experience. Indore based Company which offers versatile solutions, Right team that easily reduce the stress associated with a Household Shifting, Vehicle Transportation. we help things run smoothly and reduce breakages and offer you seamless, Affordable, Reliable Shifting Services, Compare Shifting Charges, Visit :
Manish Packers and Movers Ptv Ltd @ https://www.manishpackersmoversindore.in/
Packers and Movers Indore @ https://www.manishpackersmoversindore.in/packers-and-movers-indore.html
Manish Packers Indore @ https://www.manishpackersmoversindore.in/manish-packers-and-movers-indore.html
Packers and Movers Gurgaon @ https://www.manishpackersmoversindore.in/packers-movers-gurgaon.html
Packers and Movers Kolkata @ https://www.manishpackersmoversindore.in/packers-movers-kolkata.html
Packers and Movers Mumbai @ https://www.manishpackersmoversindore.in/packers-movers-mumbai.html
Packers and Movers Bhopal @ https://www.manishpackersmoversindore.in/packers-movers-bhopal.html
Packers and Movers Nagpur @ https://www.manishpackersmoversindore.in/packers-movers-nagpur.html
Packers and Movers Raipur @ https://www.manishpackersmoversindore.in/packers-movers-raipur.html
Packers and Movers Ahmedabad @ https://www.manishpackersmoversindore.in/packers-movers-ahmedabad.html

Manish Packers and Movers Pvt Ltd said...


Best Movers and Packers in India for Moving and Shifting Door to Door Transportation Services to all over India. Visit More :-
Manish Packers and Movers Pvt Ltd Blog
Packers and Movers Bhopal
Packers and Movers Jabalpur
Packers and Movers Vadodara
Packers and Movers Udaipur
Packers and Movers Jaipur
Packers and Movers Chandigarh
Packers and Movers Chennai
Packers and Movers Hyderabad
Packers and Movers in Indore

Manish Packers and Movers Pvt Ltd said...

Hire Manish Packers and Movers Pvt Ltd in India for hassle-free Household Shifting, Office Relocation, Car Transportation, Loading Unloading, packing Unpacking at affordable Price Quotation. Top Rated Safe and Secure Service Providers who can help you with 24x7 and make sure a Untroubled Relocation Services at Cheapest/Lowest Rate. Visit More :-
Manish Packers and Movers Pvt Ltd
Packers and Movers Bangalore
Packers and Movers Gurgaon
Packers and Movers Indore
Packers and Movers Kolkata
Packers and Movers Mumbai
Packers and Movers Nagpur
Packers and Movers Ahmedabad
Manish Packers in Indore
Manish Packers and Movers Pvt Ltd Sitemap

sofia olivia said...

Sign in certifications of QuickBooks entered by the client aren't acknowledged by the site of a money related establishment, at that point happens QuickBooks Error 5510. The error is the straightforward warning that preparing of sign in the demand has been halted due absence of certain refresh of data.

Manish Packers and Movers Pvt Ltd said...

Packers and Movers DLF Gurgaon
Packers and Movers Iffco Chowk Gurgaon
Packers and Movers MG Road Gurgaon
Packers and Movers Palam Vihar Gurgaon
Packers and Movers Udyog Vihar Gurgaon
Packers and Movers Asansol
Packers and Movers Durgapur
Packers and Movers Haldia
Packers and Movers Kharagpur
Packers and Movers Siliguri

Manish Packers and Movers Pvt Ltd said...

Best Packers and Movers in India
Packers and Movers Andheri Mumbai
Packers and Movers Thane Mumbai
Packers and Movers Bandra Mumbai
Packers and Movers Dadar Mumbai
Packers and Movers Goregaon Mumbai
Packers and Movers Kurla Mumbai
Packers and Movers Mhow
Packers and Movers Pithampur
Packers and Movers Khandwa

Manish Packers and Movers Pvt Ltd said...

Packers and Movers Jamnagar
Packers and Movers Gandhidham
Packers and Movers Nashik
Packers and Movers Gwalior
Packers and Movers Visakhapatnam
Packers and Movers Patna
Packers and Movers Ranchi
Packers and Movers Bilaspur
Packers and Movers Korba
Packers and Movers Raigarh

Manish Packers and Movers Pvt Ltd said...

Packers and Movers Indore
Movers and Packers Indore

Bee Yes said...

Amazing Article ! I have bookmarked this article page as i received good information from this. All the best for the upcoming articles. I will be waiting for your new articles. Thank You ! Kindly Visit Us @ Coimbatore Travels | Ooty Travels | Coimbatore Airport Taxi

Manish Packers and Movers Pvt Ltd said...

Packers and Movers Indore
Movers and Packers Indore
Packers and Movers Andheri Mumbai
Packers and Movers Bandra Mumbai
Packers and Movers Dadar Mumbai
Packers and Movers Goregaon Mumbai
Packers and Movers Kurla Mumbai
Packers and Movers Thane Mumbai
Packers and Movers Neemuch
Packers and Movers Ratlam

Manish Packers and Movers Pvt Ltd said...

Packers and Movers Sector 14, 17, 19 Gurgaon
Packers and Movers Sector 23 Gurgaon
Packers and Movers Sector 45, 46, 47 Gurgaon
Packers and Movers Sector 55, 56, 57 Gurgaon

sofia olivia said...

On the off chance that you confront any bother or are reluctant to take after the means you can contact QuickBooks POS support. The accomplished QuickBooks specialists will guide and help you to settle your QuickBooks POS Error 1330 and fruitful item refresh. You can interface with them through the email support mode and live talk alternative.

Manish Packers and Movers Pvt Ltd said...

Packers and Movers Viman Nagar Pune
Packers and Movers Magarpatta City Pune
Packers and Movers Wakad Pune
Packers and Movers Baner Pune
Packers and Movers Daund Pune
Packers and Movers Hinjewadi Pune
Packers and Movers Pimple Saudagar Pune
Packers and Movers Hadapsar Pune
Packers and Movers Talegaon Pune
Packers and Movers Kharadi Pune

Manish Packers and Movers Pvt Ltd said...

Packers and Movers Indore

Manish Packers and Movers Pvt Ltd said...

Packers and Movers Indore
Packers and Movers Bangalore
Packers and Movers Gurgaon
Best Packers and Movers Indore
Packers and Movers Kolkata
Packers and Movers Mumbai
Packers and Movers Nagpur
Packers and Movers Delhi
Packers and Movers Pune
Packers and Movers Ahmedabad

Rajesh choudhary said...

Packers and Movers in India
Packers and Movers Raipur
Packers and Movers Nagpur
Packers and Movers Jaipur
Packers and Movers Udaipur
Packers and Movers Surat
Packers and Movers Vadodara
Packers and Movers Chandigarh
Packers and Movers Jabalpur
Packers and Movers Hyderabad

Starit said...

You have made good some points. It is also helpful for us. I really enjoyed reading your post. Thank's for sharing your post. To know more about info:
movers and packers in Dhaka
packers in Dhaka

Shanthi Cabs said...

Amazing article. Your blog helped me to improve myself in many ways thanks for sharing this kind of wonderful informative blogs in live. I have bookmarked more article from this website. Such a nice blog you are providing ! Kindly Visit Us @ Best Travels in Madurai | Tours and Travels in Madurai | Madurai Travels