Generic errors while importing solution in Dynamics CRM 2016

While importing an update for a solution or a new solution that is building on top of another solution, then you might face generic error messages. This blog post provides a possible solution for the scenario when the CRM solution import dialog mentions a "Generic SQL error" while downloading the log file serves you the message "0x80044150: Object reference not set to an instance of an object.".

I have found that for some reason it is possible that the Description attribute of an entity is not included in the customizations file when exporting from Dynamics CRM 2015. If this is the case, then the system will crash during import when it tries to determined if the LabelDescriptionHasChanged.

You can confirm that this is the issue by running the following SQL script:
SELECT objectcolumnname, s.FriendlyName 'Solution FriendlyName', label, objectid, LanguageId
FROM [LocalizedLabelAsIfPublishedView] l
LEFT OUTER JOIN solution s ON l.solutionid = s.solutionid
LEFT OUTER JOIN entity e ON l.ObjectId = e.EntityId
WHERE e.name = 'new_entity'

Of course you'll need to change the new_entity to the schemaname of your entity. If this query results only the LocalizedName and LocalizedCollectionName but no "Description", then this is could very well be the cause of the error messages. Another way to confirm is to check the customizations file, search for the entity and determine if the tag <Descriptions> is present.

The way to solve this is quite easy. In your source system, go to the correct entity, add a description and export the solution again. You will need to remove the previous solution from the target environment though.

7 comments:

CrmOnlineUser said...

Hi Ronald, this is a very bad situation, i'm shocked. Before we upgraded to CRM2016 it was no problem to upgrade our solution from our onpremise dev system to the online productive system. Now we face this generic sql error, but we cannot remove the solution from our productive system, as there is allready a ton of data present. is there no other way? Are you aware of a statement from MS?

Thank you in advance..

CrmOnlineUser said...

Hi, me again, we could solve this by create entity descriptions on both installations, dev and productive. after that, the import worked as expected. thank you very much for your solution to this.

Anonymous said...

Hello :) Good job - your blog is a great guide to microsoft dynamics software. Hope you will carry on writing about this great tool :)

Subhash said...

Hi,

Good post.Thanks for sharing..

Anonymous said...

Thank you for sharing this informative post. This will be very helpful for solving the CRM software related problems. Keep posting these kind of posts.

real estate marketing software

Sophia said...

Hi,
Nice blog, Our database can help you to target prospects to get high response rates and guaranteed results. Now reach and engage with your targeted audience by Microsoft Dynamics CRM Uers Email List and stay connected with IT Technology in USA, Canada, UK, Australia and Europe.

Unknown said...


I had doubts about magic spells after purchasing many spells that never worked I actually decided to never buy a spell again. I have tried different spell casters..Some of them never answered me after I paid and were obvious scammers, some really cast a spell but for some reason it didn't work. Then I saw a video on you-tube with a person who was mentioning she had results with prophet ogidiga . Despite the suspicions I had his site looked real so I gave spells a last try. It's probably the best decision I ever made in my life because it worked and my boyfriend came back with me After I broke up with him I spent a lot of time wishing that I could just turn the clock backwards.He helped me do just that. fact our relationship feels like the [(M I R A C L E C E N T E R 1 1 0 @ g m a i l . c o m] or call + 2 3 4 9 0 6 7 4 6 4 0 4 8