Posts

Showing posts from January, 2013

Deletion State Codes Fields Preventing Solution Import

Image
If you have upgraded a CRM database from 4.0. to 2011 you may have some leftover fields that end in dsc.  These fields can later on come back to haunt you by showing up as missing components when import a solution into 2011. The fields will always end in “dsc” as you can see in the image below.


John Hoven has written a SQL script which will remove these attributes from the database.  After removing them re-export the solution and attempt the import again.
-- Delete the custom DSC attributes from the database.
DELETEa
--select A.LogicalName
FROMmetadataschema.attributea
INNERJOINmetadataschema.entitye
ONe.entityid