CrmDuplicateRecordException Error 0x80040237 “Cannot insert duplicate key.” during import of CRM Solution

So when you import a solution, then this leads to error 0x80040237 “Cannot insert duplicate key.”? Then download the solution import XML log file, open in Excel, and have a look at the name of the troubled entity.


Then unzip solution ZIP and open the customizations.xml. Find the troubled entity, the easiest is to search for:

<entity Name="[yourentity]">

Within this entity you should find something similar to this:

<CustomControlDefaultConfigs>

        <CustomControlDefaultConfig>

          <PrimaryEntityTypeCode>10046</PrimaryEntityTypeCode>

          <CustomControlDefaultConfigId>{924314e7-3e47-e614-80de-fc15b4269a54}</CustomControlDefaultConfigId>

          <ControlDescriptionXML><controlDescriptions /></ControlDescriptionXML>

          <IntroducedVersion>2016.07.6.1</IntroducedVersion>

        </CustomControlDefaultConfig>

      </CustomControlDefaultConfigs>

The PrimaryEntityTypeCode is from the origin/source environment. In the target environment, the PrimaryEntityTypeCode is different. This usually isn’t an issue, but somehow the system can get confused. Most likely you’ll find that the Guid for this CustomControlDefaultConfigId appears for two different PrimaryEntityTypeCodes in the target system. You can confirm this using this query:

SELECT PrimaryEntityTypeCode, * FROM CustomControlDefaultConfigBase WHERE CustomControlDefaultConfigId = '[your guid]'

If you indeed see records with different PrimaryEntityTypeCode and the same CustomControlDefaultConfigId, then this is indeed the issue. The one which doesn’t match the code from the XML file, in this example 10046, is the one from the origin environment, the other from the target environment. We should get rid of the one which matches the origin environment.

DELETE FROM CustomControlDefaultConfigBase WHERE CustomControlDefaultConfigId = '[your guid] AND PrimaryEntityTypeCode = '[PrimaryEntityTypeCode from customizations.xml]'

If after fixing this bug you’re faced with another error on the same entity, with the message ‘There should not be more than one component instance for a solution being upgraded’, then it’s getting more challenging. My advice? Contact Microsoft Support..

37 comments:

Kanhasoft said...

Are you looking for CRM Solution Developer? Kanhasoft offers custom CRM Software Development to the offshore clients from countries UK, Canada, USA, Japan, Australia, Sweden, Norway, Switzerland, New Zealand, Germany, South Africa and 45 more.

Karla said...

Lovely post. Learned so much from it. Many Many thanks. Cheers.

steve said...


الرائد تقدم خدمات تطهير و تعقيم خزانات المياه فى جدة و مكة لاننا :
افضل شركة غسيل خزانات بجدة
و افضل شركة غسيل خزانات بمكة
للمزيد قم بزيارة
افضل شركة تنظيف منازل

Packers and Movers Bangalore said...

Packers and Movers Bangalore as a Services providing company can make all the difference to your ###Home Relocation experience. Bangalore 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 @
Packers And Movers Bangalore

Packers and Movers Chennai said...

Packers and Movers Chennai Give Safe and Reliable ***Household Shifting Services in Chennai with Reasonable ###Packers and Movers Price Quotation. We Provide Household Shifting, Office Relocation, ✔✔✔Local and Domestic Transportation Services, Affordable and Reliable Shifting Service Charges @
Packers And Movers Chennai

Brians Ocean said...

A befuddling web diary I visit this blog, it's incredibly grand. Strangely, in this present blog's substance made motivation behind fact and sensible. The substance of information is instructive
Thanks For Sharing
Types Of Obesity
Expensive Workout Equipment
Blood Pressure and Weight
Successful Journey Through Recovery
homemade laxatives
Deal With Stress
How Much Do You Really Owe Your Ex?
Can Mangosteen Cure Diabetes

Realtek Consulting said...

Thanks for sharing informative post.

Customer relationship management Software in chennai
CRM software in chennai
CRM software in us
erp in chennai
crm software development services in us
crm software development in us

usman said...

We as QuickBooks Support Phone Number +1-844-233-5335 team provide our matchless support for the issues in QuickBooks to its users worldwide. It goes without saying that QuickBooks is one of the most helpful accounting software presents in the current time. Read more- https://tinyurl.com/yy9ov86q & visit us- https://www.qbooksupportphonenumber.com/

usman said...

Our support team at QuickBooks Payroll Support Phone Number +1-800-417-3165 helps you deal with the issues that pop up in this software. When it comes to errors, there are so much that you may face. Read more- https://tinyurl.com/y6crto3c & visit us- https://www.qbcustomersupportphonenumber.com/quickbooks-payroll/

usman said...

We as QuickBooks Support Phone Number +1-844-233-5335 team provide our matchless support for the issues in QuickBooks to its users worldwide. It goes without saying that QuickBooks is one of the most helpful accounting software presents in the current time. Read more- https://tinyurl.com/yy9ov86q & visit us- https://www.qbooksupportphonenumber.com/

usman said...

We as QuickBooks Support Phone Number +1-844-233-5335 team provide our matchless support for the issues in QuickBooks to its users worldwide. It goes without saying that QuickBooks is one of the most helpful accounting software presents in the current time. Read more- https://tinyurl.com/yy9ov86q & visit us- https://www.qbooksupportphonenumber.com/

usman said...

QuickBooks Support Phone Number team that assists you at +1-800-329-0391 is of great help to all the QuickBooks users. This team leaves no stone unturned to help you get rid of QuickBooks errors. Often a good product loses its popularity and demand because of its poor support services. Therefore, for a product as famous and useful as QuickBooks, it is essential to take support from a dependable team. Read more- https://tinyurl.com/y52oohj6 & Visit us-https://issuu.com/harymason46/docs/dial_quickbooks_support_phone_numbe_330b3f16252322

usman said...

QuickBooks Support Phone Number team that assists you at +1-800-329-0391 is of great help to all the QuickBooks users. This team leaves no stone unturned to help you get rid of QuickBooks errors. Often a good product loses its popularity and demand because of its poor support services. Therefore, for a product as famous and useful as QuickBooks, it is essential to take support from a dependable team. Read more- https://tinyurl.com/y52oohj6 & Visit us-https://issuu.com/harymason46/docs/dial_quickbooks_support_phone_numbe_330b3f16252322

Quickbooks Payroll said...

We are providing technical support in Quickbooks for MAC support phone number it is Specifically designed for MAC operating system.We are providing 24*7 technical support so if you need any query.Please call us our Toll-free Number + 1-800-986-4607.

Unknown said...

Dial Sage 50 customer support phone number Canada 1-844-995-7243 to get the efficient customer support services for Sage 50 accounting software issues at the most pocket friendly market price. Read more- https://tinyurl.com/y2nsgqga & visit us-https://www.getsupportcontactnumber.com/sage-50-customer-support-phone-number-canada-1-844-995-7243/

Unknown said...

Ours is a team at sage 50 technical support phone number 1-844-995-7243 that leaves no stone unturned to bring you out of any difficulty that you are facing while using Sage 50. Whether it is Sage 50c or classic Sage 50 we help you in all the ways possible to resolve all your issues and let you carry on with your work without much interruption. Read more- https://tinyurl.com/yyueyche & visit us-https://www.getsupportcontactnumber.com/

Quickbooks Payroll said...

Nice Blog Thanks for sharing this useful link. It’s a really informative for all. QuickBooks is one of the best accounting software which helps in managing your company finances and accounting. Any technical issue obstructing your way ahead? Call us now on Quickbooks Payroll Support Phone Number 1-800-986-4607.

usman said...

Our team at QuickBooks Support Phone Number +1 800-417-3165 has been providing its matchless assistance for the errors in QuickBooks for quite a long time. Though this software is regarded as one of the top most accounting applications in the world, it is often accompanied by some errors. Before we jump onto its errors, let’s have a brief introduction of QuickBooks. Visit us- https://www.theqbsupportphonenumber.com/

usman said...

Get prominent solutions for QuickBooks near you right away! Without any doubts, QuickBooks has revolutionized the process of doing accounting that is the core strength for small as well as large-sized businesses. QuickBooks Support Phone Number +1-800-417-3165 is a backing portal that authenticates the users of QuickBooks to run its features in a user-friendly manner. Visit us- https://www.qbcustomersupportphonenumber.com/

usman said...

Our support team at QuickBooks Payroll Support Phone Number +1-800-417-3165 helps you deal with the issues that pop up in this software. When it comes to errors, there are so much that you may face. From installation error to upgrading error to update issues to even multi-user troubles etc., all the issues of QuickBooks Payroll are solved in the easiest manner by our talented team. Visit us- https://www.qbcustomersupportphonenumber.com/quickbooks-payroll/

QuickSupportNumber247 said...


QuickBooks Support Phone Number +1-855-686-6166 you can get the best answers for all the problems in QuickBooks. This software provides you tools that are extremely beneficial for almost every industry type in the world.Quickbooks Support Phone Number+1-855-686-6166 can fix all issues which are relate with quickbooks pro, quickbooks premier, quickbooks enterprise, quickbooks pos or quickbooks accountant. We have 24*7 support team for,

QuickBooks Pro
QuickBooks Premier
QuickBooks Enterprise
QuickBooks Point of Sale
QuickBooks Payroll
QuickBooks Accountant

Several mind-blowing features are contained by each of these versions. Any hindrance caused by any QuickBooks error is taken care of by our QuickBooks Support team.

usman said...

QuickBooks error 6073
It would be a delight for you to know that this team is available at your service for 24 hours. Therefore, in future, if you ever encounter QuickBooks error 6073 just call at QuickBooks Support Phone Number +1 800-417-3165 and all your issues will vanish. Read more- https://tinyurl.com/y4dd4brh & visit us- https://www.qbcustomersupportphonenumber.com/quickbooks-error-6073/
QuickBooks error 6129
So, next time if you face any issue in this software like QuickBooks error 6129 call at QuickBooks Support Phone Number +1 800-417-3165. Read more- https://tinyurl.com/y4jmbpdr & visit us-https://www.qbcustomersupportphonenumber.com/quickbooks-error-6129/

usman said...

QuickBooks error 6147
Apart from this, these guys are available 24*7 to fix issues like QuickBooks error 6147 for you. So, dial QuickBooks Support Phone Number +1 800-417-3165 and get away with the problems in this software. Read more- https://tinyurl.com/y2w6wh5r & visit us-https://www.qbcustomersupportphonenumber.com/quickbooks-error-6147/
QuickBooks error 6150
Apart from this, these guys are available round the clock at your service. So, in case you encounter QuickBooks error 6150 in future, do not hesitate to call the team at QuickBooks Support Phone Number +1 800-417-3165. Read more- https://tinyurl.com/y3fd9f6s & visit us-https://www.qbcustomersupportphonenumber.com/quickbooks-error-6150/

usman said...

QuickBooks error 6210
Also, these guys are quite friendly in nature and are always ready to help you even at the wee hours. So, call them at QuickBooks Support Phone Number +1 800-417-3165 without any doubt the next time you encounter QuickBooks error 6210. Read more- https://tinyurl.com/y5qqjzah & visit us- https://www.qbcustomersupportphonenumber.com/quickbooks-error-6210/
QuickBooks error 61
So, stop wasting your time in the search of a dependable support team, rather call at QuickBooks Support Phone Number +1 800-417-3165 and get QuickBooks error 61 fixed in no time. Read more- https://tinyurl.com/y25pyzw6 & visit us- https://www.qbcustomersupportphonenumber.com/quickbooks-error-61/

usman said...

QuickBooks error 30159
So, next time if you come in terms with QuickBooks error 30159 just call at QuickBooks Support Phone Number +1 800-417-3165. Read more- https://tinyurl.com/yymsk8vb & visit us- https://www.qbcustomersupportphonenumber.com/quickbooks-error-30159/
QuickBooks error 12007
So, in future if you come across any issue like QuickBooks error 12007 just dial QuickBooks Support Phone Number +1 800-417-3165. Read more- https://tinyurl.com/y26he33c 7 visit us- https://www.qbcustomersupportphonenumber.com/quickbooks-error-12007/
QuickBooks error 12029
These experts work towards achieving maximum customer satisfaction. Therefore, call them at QuickBooks Support Phone Number +1 800-417-3165 and get issues like QuickBooks error 12029 fixed instantly. Read more- https://tinyurl.com/yyulub9j & visit us- https://www.qbcustomersupportphonenumber.com/quickbooks-error-12029/

usman said...

QuickBooks error OLSU 1013
Also, this exceptional team is available 24/7 at your service. So, call the team at QuickBooks Support Phone Number+1 800-417-3165 to get done with the errors in QuickBooks error OLSU 1013. Read more- https://tinyurl.com/y3vrhfuu & visit us- https://www.qbcustomersupportphonenumber.com/quickbooks-error-olsu-1013/
QuickBooks error 102
And most of all, they are available at your service for 24 hours. So just dial their toll-free number +1 800-417-3165 and get away with the issues like QuickBooks error 102. Read more- https://tinyurl.com/y59pl7e8 7 visit us-https://www.qbcustomersupportphonenumber.com/quickbooks-error-102/

usman said...

Being customer friendly with all their customers is another quality of this team. Hence, call them at their toll-free number +1 800-417-3165 and get fixed issues like QuickBooks installation error. Read more- https://tinyurl.com/y6znyj9d & visit us- https://www.qbcustomersupportphonenumber.com/quickbooks-installation-error/

usman said...

QuickBooks error 324
So, next time if you come across QuickBooks error 324 wave it a big good bye by calling at QuickBooks Support Phone Number +1 800-417-3165. Read more- https://tinyurl.com/yxzc4jkg & visit us- https://www.qbcustomersupportphonenumber.com/quickbooks-error-324/
QuickBooks Install Error 1904
So, in future if you ever come across QuickBooks Install Error 1904 just dial QuickBooks Support Phone Number +1 800-417-3165. Read more- https://tinyurl.com/y6sfzl3u & visit us- https://www.qbcustomersupportphonenumber.com/quickbooks-install-error-1904/

usman said...

Our team at QuickBooks Support Phone Number +1 800-417-3165 has been providing its matchless assistance for the errors in QuickBooks for quite a long time. Though this software is regarded as one of the top most accounting applications in the world, it is often accompanied by some errors. Before we jump onto its errors, let’s have a brief introduction of QuickBooks. Visit us- https://www.theqbsupportphonenumber.com/

usman said...

Enjoy Top-Notch Assistance at QUICKBOOKS PAYROLL SUPPORT PHONE NUMBER +1 800-417-3165. It is said that ‘hard work and success go hand in hand’. Our team at QuickBooks Payroll Support Phone Number +1 800-417-3165 follows this mantra dedicatedly and the results that we have achieved so far are applaudable. QuickBooks is the most opted application when it comes to handle accounting affairs. It automates the complete business running process in such a way that everything falls into place. Visit us- https://www.theqbsupportphonenumber.com/quickbooks-payroll/

Quickbooks Payroll said...

Nice Blog It’s a really informative for all. QuickBooks is a reliable accounting software. You can easily use and install QuickBooks.We are providing technical support in Quickbooks Support Phone Number 1800. Please call us our Toll-free Number + 1-800-986-4607.

Quickbooks Payroll said...

Nice Blog Thanks for sharing this use full link. It’s a really informative for all. QuickBooks is a reliable accounting software. You can easily use and install QuickBooks.We are providing technical support in Quickbooks Payroll Support Phone Number . Our technical support team is 24*7 available so if you need any help. Please call us our Toll-free Number + 1-800-986-4607.

paloma thomas said...


Hi, I was looking for content that can help me with my project. Thank you! All the points that are mentioned in your blog are relevant and simple to understand. You can even manage your work by downloading QuickBooks. For more help related to issues, contact us at QuickBooks Tech Support Phone Number +1 833-222-6943. The teams of professional technicians are available 24 hours 365 days.
Visit more: https://www.qbtechservices.com/

smith said...

Hey loved all that you shared. Undoubtedly, you have some of the best posts that I have come across. Keep going and all the best. Now, you can easily manage your time by downloading QuickBooks software. For any issues related to this software, you can contact us at QuickBooks Enterprise Support Phone Number +1 833-222-6943.
You can even visit the website https://www.qbtechservices.com/ to know about the policies and services

HP Printer Support said...

QuickBooks Support Phone Number
QuickBooks is one of the most sought-after financial accounting software in the marketplace. Due to its great variety of features, it has become extremely popular among its users. However, it can from time to time be plagued by certain technical hindrances. This where the QuickBooks Support Phone Number comes into play. Once you get in touch with the QuickBooks Support team, our expert technicians will provide you with the technical assistance that you require in order to get rid of whatever issues that might be bogging your system down.Apart from getting amazing quality services, you will get one single solution for all your critical problems through remote assistance. The certified professionals are best and well experienced and always available 24/7 to deliver services on-time or before time. So, if you want to contact the team then easily dial our toll-free number of QuickBooks customer support and get one stop solution for all your problems and build your business. Furthermore, we also provide technical assistance for QuickBooks Payroll Support in case you are in need of it.

HP Printer Support said...

lexmark Printer Support Phone Number
Now all the technical problems associated with Lexmark printers will simply be fixed. By simply job the Lexmark Printer Support Phone Number and telling your problems to the Lexmark Customer Support representatives. Lexmark Printer Technical Customer Support Phone Number is 24*7 available for your help. Lexmark printer provides some nice tools and …

Quickbooks Payroll said...

Nice Blog I am very impressive to your blog. We are providing technical support in Quickbooks Support Phone Number . Our team is highly experienced & available for 24*7. So if you need any support in Quickbooks dial our Quickbooks Support phone number + 1-800-986-4607.