CRM 2011 – SQL error while importing solution in crm 2011

I tried to import a solution today and go an error, an SQL error similar to the one below

The culprit in my situation was I had a field which the field was of type int

I then had deleted the variable and created a new one with the same name of type picklist

When you try and import the solution I received an SQL error

To resolve the error you have to delete the variable in the CRM organisation you are trying to import the solution to.  Then you will be able to import the solution.

The best way to find the variable is to use WinMerge and compare the customization.xml files in the previous solution file and the new solution customization.xml.  You can get the solution file by exporting it if you don’t have one to hand.

This makes sense because SQL will have a column with incompatible data and a column with the name you are trying to create a new column for.

5 thoughts on “CRM 2011 – SQL error while importing solution in crm 2011

  1. Georgi Borisov April 3, 2015 / 7:36 am

    But how do you delete it from the managed solution, Ben?


    • Hosk April 3, 2015 / 7:41 am

      You need to remove\change it in your solution and then try and import it again


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.