Looking for PowerObjects? Don’t worry, you’re in the right place! We’ve been part of HCL for several years, and we’ve now taken the final step in our acquisition journey: moving our website to the HCL domain. Nothing else is changing – we are still fanatically focused on Microsoft Business Applications!

HCLTech Microsoft Business Applications Practice Blog

for Dynamics 365, Power Platform and the rest of the Microsoft technology stack


Field Is Not Unique Error when Importing a Solution in CRM 2011

Post Author: HCLTech |

If you have production CRM environment and development/test/UAT environment(s), you have probably encountered a situation where you may need to create fields manually separately in both environments. If you do this and then later import a solution from Test to Production, you may see an error in the solution import claiming that field with the specified name already exists, or that 'Column names in each table must be unique. Column name x in table yy is specified more than once.'

This is usually result of schema of the field being different. It could be string in one CRM and option set in another. A trickier problem is when the schema name of the field differs by capitalization, for example po_testfield and po_TestField. Capitalization is ignored when checking if the field already exists, but for some reason it is not accepted as same field and be updated with new metadata.


Here are two screenshots of same field in two different CRMs. Even if the name of the field is same for both 'po_testfield', the schema name is different for 'po_testfield' vs 'po_TestField'. Importing a solution containing this field will result in above error.

Field Is Not Unique Error in Dynamics CRM

Field Is Not Unique Error


To fix this issue, delete the field in test and recreate it with matching schema name. After that, the field should be recognized as a same field and will not result in error in the subsequent imports.

More information regarding best practices of CRM 2011 solutions can be found in the following blogs:

And of course, if you are still experiencing issues or have additional questions, you can always reach out to the CRM experts at PowerObjects!

Happy CRM'ing!

By Joe D365
Joe D365 is a Microsoft Dynamics 365 superhero who runs on pure Dynamics adrenaline. As the face of PowerObjects, Joe D365’s mission is to reveal innovative ways to use Dynamics 365 and bring the application to more businesses and organizations around the world.

PowerObjects Recommends