Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. An error occurs after applying Update Rollup 12 to Microsoft Dynamics CRM 2011 Server Update Rollup 11: "Generic SQL Error"

An error occurs after applying Update Rollup 12 to Microsoft Dynamics CRM 2011 Server Update Rollup 11: "Generic SQL Error"

View products that this article applies to.

Symptom

When trying to access any Microsoft Dynamics CRM 2011 web page after applying Update Rollup 12 on top of an Update Rollup 11 Dynamics CRM Server, an error occurs:


>Crm Exception: Message: Generic SQL error., ErrorCode: -2147204784, InnerException: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'ObjectTypeCodeName'.



Invalid column name 'ObjectTypeCodeName'.

↑ Back to the top

Cause

This issue only occurs in one of the two following sequences has been met:

1. Update Rollup 12 is applied on top of a CRM Server version below Update Rollup 10

2. The CRM Server is then rolled back to Update Rollup 11

3. Update Rollup 12 is later applied on top of Update Rollup 11

or

1. Update Rollup 12 is applied on top of Update Rollup 7

2. The CRM Server is rolled back to Update Rollup 7

3. An attempt to apply Update Rollup 11 is made; however, the file versions did not change to the correct version number

4. Update Rollup 15 is applied

↑ Back to the top

Resolution

In order to resolve this issue, database updates must be made. Prior to doing this, you must first ensure you have a full backup of your CRM databases in SQL.

Create a Full Database Backup in SQL Server

Once that has been done, run the following two statements SQL Management Studio:

delete from MetadataSchema.Attribute where AttributeId in ('4456bbb5-0bad-4360-afca-74d099056116', 'c3dce60b-fd95-43b4-8d20-ea4bbcd5c436');  

delete from AttributeIds where AttributeId in ('4456bbb5-0bad-4360-afca-74d099056116', 'c3dce60b-fd95-43b4-8d20-ea4bbcd5c436');



After removing these fields, you must complete an IISReset.


↑ Back to the top

Keywords: kb

↑ Back to the top

Article Info
Article ID : 2906374
Revision : 1
Created on : 1/7/2017
Published on : 10/31/2013
Exists online : False
Views : 193