Showing posts from January, 2013

Deletion State Codes Fields Preventing Solution Import

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.   DELETE   a   --select A.LogicalName   FROM    metadataschema . attribute   a          INNER   JOIN   metadataschema . entity   e            ON   e . entityid   =   a . entityid   WHERE   a . attributeof   IS   NOT   NULL          AND   a . attributetypeid   =   '00000000-0000-0000-00AA-110000000019'          AND   a . logicalname   LIKE   '%dsc'          AND   a . iscustomfield   =   1   -- Delete the dsc attribute map columns DELETE   am   --select AM.*