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.

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

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

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

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

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

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

IndianPerson said...

Submit Article
Hotels for couples
Hotels near delhi airport

Unknown said...

Thanks a lot! I had the same issue with Field permission,

SELECT * from FieldSecurityProfileBase where SupportingSolutionId = ....

Jamess said...

You can find an array of errors that pop up in QuickBooks Payroll that are cared for by our highly knowledgeable and dedicated customer support executives. There are numerous regularly occurring Payroll errors with this software that may be of a little help to you.
QuickBooks Payroll Support Phone Number
QuickBooks Payroll Support Number
QuickBooks Payroll Tech Support Number
QuickBooks Payroll Tech Support
Phone Number for QuickBooks Payroll Support
QuickBooks 24/7 Payroll Support Phone Number USA
QuickBooks Desktop Payroll Support Phone Number
Quickbooks Enhanced Payroll Customer Support
QuickBooks Online Payroll Contact Number
QuickBooks Payroll Contact Phone Number
QuickBooks Payroll Help Phone Number USA
QuickBooks Payroll Service Phone Number
QuickBooks Payroll Support Contact Number
QuickBooks Payroll Technical Support Phone Number
Support for QuickBooks Payroll
QuickBooks Payroll Support USA
QuickBooks Payroll Technical Support
QuickBooks Payroll Support Phone Number USA
QuickBooks Payroll Helpline Number
QuickBooks Payroll Customer Service Number
QuickBooks Payroll Customer Service
QuickBooks Payroll 24/7 Support Number

kevin32 said...

QuickBooks Support Phone Number 1800-243-1465. QuickBooks is an accounting program group released by Intuit supports in compliment and sensible controlling of cash related data. It makes things less requesting paying little information to the likelihood that it is the compound data to that level where it can be effortlessly joined.


QuickBooks Support Phone Number
QB 24x7 Support Number
QuickBooks Support Number
QuickBooks Tech Support Number
QuickBooks Tech Support Phone Number
Intuit QuickBooks Support
Intuit QuickBooks Support Number
QuickBooks Customer Service Number
QuickBooks Customer Service
QuickBooks Customer Service Phone Number
QuickBooks Support
QuickBooks Help Number
Intuit QuickBooks Phone Number
QuickBooks Technical Support Number
QuickBooks Technical Support Phone Number
QuickBooks Toll-free Support Number
QuickBooks Toll-free Number
QuickBooks Desktop Support Number
QuickBooks Support USA
QuickBooks USA Support Phone Number
QuickBooks USA Support Number
QuickBooks Support Phone Number USA
QuickBooks Support Number USA
QuickBooks Support Number 2019
QuickBooks Support Phone Number 2019
QB 24/7 Support Phone Number

Electrostaragent said...

الان افضل العروض وارخص الاسعار في صيانة الكتروستار على جميع الاجهزة الكهربائية كالغسالات والثلاجات والسخانات بالاضافة الى اسرع خدمة عملاء في صيانة فريجيديرللرد على جميع استفساراتكم والرد على الشكاوي في اسرع وقت .

Leo Packers and Movers In Gurgaon said...

Packers Movers In Delhi
Packers and Movers Delhi
Packers and Movers In Dwarka
Packers and Movers In Gurgaon
Packers and Movers In Greater Noida

packers-movers-jabalpur said...


" Choudhary Packers and Movers in Jabalpur are on a rapid rise over the past few years. The modern social trend shows that a significant portion of the population is always travelling from one place to the other to meet up business or job demands.
"
packers and movers in jabalpur
packers and movers jabalpur

Aruna Ram said...

Superb content, This is very helpful for gain my skills and keep posting...
Unix Training in Chennai
Unix Training Fees in Chennai
Advanced Excel Training in Chennai
Oracle DBA Training in Chennai
Tableau Training in Chennai
Oracle Training in Chennai
Unix Training in T Nagar
Soft Skills Training in Chennai
JMeter Training in Chennai
Appium Training in Chennai

silakarim said...
This comment has been removed by the author.
manojpackers said...

Noida packers and movers is one of the best packers and movers services provider in Delhi NCR. which providers you best packers and movers services in Delhi NCR and Delhi NCR to all over India. if you want to packers and movers services in Delhi NCR so visit at-
packers services in noida
packers services in delhi ncr
delhi packers and movers
packers and movers in Delhi
packers movers delhi
home packers and movers in delhi

silakarim said...

Your post is really awesome. It is very helpful for me to develop my skills in a right way.keep sharing such a worthy information
Java Training in Anna Nagar
Java Training in Velachery
Java Training in Tambaram
Java Training in OMR
Java Training in Porur
Java Training in T Nagar
Java Training in Adyar
Java Training in Vadapalani
Java Training in Thiruvanmiyur

sureshshetty said...

7 tips to start a career in digital marketing

“Digital marketing is the marketing of product or service using digital technologies, mainly on the Internet, but also including mobile phones, display advertising, and any other digital medium”. This is the definition that you would get when you search for the term “Digital marketing” in google. Let’s give out a simpler explanation by saying, “the form of marketing, using the internet and technologies like phones, computer etc”.

we have offered to the advanced syllabus course digital marketing for available join now

more details click the link now

[url]https://www.webdschool.com/digital-marketing-course-in-chennai.html[/url]

sureshshetty said...


Web designing trends in 2020

When we look into the trends, everything which is ruling today’s world was once a start up and slowly begun getting into. But Now they have literally transformed our lives on a tremendous note. To name a few, Facebook, Whats App, Twitter can be a promising proof for such a transformation and have a true impact on the digital world.

we have offered to the advanced syllabus course web design and development for available join now

more details click the link now

[url]https://www.webdschool.com/web-development-course-in-chennai.html[/url]

Mahi Chopra said...

Incall/Outcall Escorts Service in Mumbai at very reasonable prices. How much you can spend on a call girls its depends on you what kind of escorts service you want and what you want extra then escorts service through a call girls. When you select a girl for unlimited pleasure then you should know the quality of an independent mumbai escorts girls. Mahi Chopra will provide you high class escorts service within 30 mins. Just visit us or contact us for booking an escorts in mumbai.

Punjabi Call Girls in Mumbai | Mumbai Escort | Independent Mumbai Escorts | Independent Escorts in Mumbai | Mumbai Escorts Agency | Mumbai Escorts Service | Escorts Agency in Mumbai | Escorts Mumbai | Mumbai Female Escorts, Mumbai Escorts

w3webschool said...

Nice post. Thanks for sharing! I want people to know just how good this information is in your article. It’s interesting content and Great work.
Digital Marketing Course In Kolkata
Web Design Course In Kolkata
SEO Course In Kolkata

Anurag Srivastava said...

It was a great blog with so much information of the beautiful places to visit...Sarkari Result has currently published jobs like India Post GDS Online Form, Bank of Maharashtra Recruitment,, AIIMS recruitment, MPPKVVCL Recruitment, Indian Navy Recruitment, Vizag Steel and many more. So, never miss a chance to check out Sarkari Result on daily basis for getting all the information about RRB Recruitment 2020 .