Error message when you upgrade to Microsoft CRM 3.0: "Microsoft CRM 3.0 Server Setup failed" (911315)


The information in this article applies to:

  • Microsoft CRM 3.0

SYMPTOMS

When you upgrade from Microsoft CRM 1.2 to Microsoft Dynamics CRM 3.0, you receive the following error message:
Microsoft CRM 3.0 Server Setup Failed.

Microsoft CRM 3.0 Server Setup did not complete successfully.

Action Microsoft.Crm.Setup.InstallDatabaseAction failed.
Line 257: Incorrect syntax near '?'
Incorrect syntax near keyword 'or'.
Line 697: Incorrect syntax near ')'.

CAUSE

This issue may occur when an attribute name for an entity in Microsoft CRM 1.2 contains a language-specific character.

RESOLUTION

To resolve this issue, follow these steps:
  1. Open SQL Query Analyzer. To do this, click Start, point to Programs, point to Microsoft SQL Server, and then click Query Analyzer.
  2. Click the CRM METABASE database.
  3. Paste the following SQL statement into the query window:
    create function dbo.fn_TranslateDateTime(@attrName nvarchar(300))
returns nvarchar(800)
as
begin
	declare @attrResult nvarchar(800)
	set @attrResult = 'dbo.fn_UTCToTzSpecificLocalTime(' + @attrName + ',' + CHAR(13) + CHAR(10) 
						+ CHAR(9)+ CHAR(9)+ CHAR(9)+ 'us.TimeZoneBias,' + CHAR(13) + CHAR(10)
						+ CHAR(9)+ CHAR(9)+ CHAR(9)+ 'us.TimeZoneDaylightBias,' + CHAR(13) + CHAR(10)
						+ CHAR(9)+ CHAR(9)+ CHAR(9)+ 'us.TimeZoneDaylightYear,' + CHAR(13) + CHAR(10)
						+ CHAR(9)+ CHAR(9)+ CHAR(9)+ 'us.TimeZoneDaylightMonth,' + CHAR(13) + CHAR(10)
						+ CHAR(9)+ CHAR(9)+ CHAR(9)+ 'us.TimeZoneDaylightDay,'+ CHAR(13) + CHAR(10)
						+ CHAR(9)+ CHAR(9)+ CHAR(9)+ 'us.TimeZoneDaylightHour,' + CHAR(13) + CHAR(10)
						+ CHAR(9)+ CHAR(9)+ CHAR(9)+ 'us.TimeZoneDaylightMinute,' + CHAR(13) + CHAR(10)
						+ CHAR(9)+ CHAR(9)+ CHAR(9)+ 'us.TimeZoneDaylightSecond,' + CHAR(13) + CHAR(10)
						+ CHAR(9)+ CHAR(9)+ CHAR(9)+ '0,' + CHAR(13) + CHAR(10)
						+ CHAR(9)+ CHAR(9)+ CHAR(9)+ 'us.TimeZoneDaylightDayOfWeek,' + CHAR(13) + CHAR(10)
						+ CHAR(9)+ CHAR(9)+ CHAR(9)+ 'us.TimeZoneStandardBias,' + CHAR(13) + CHAR(10)
						+ CHAR(9)+ CHAR(9)+ CHAR(9)+ 'us.TimeZoneStandardYear,' + CHAR(13) + CHAR(10)
						+ CHAR(9)+ CHAR(9)+ CHAR(9)+ 'us.TimeZoneStandardMonth,' + CHAR(13) + CHAR(10)
						+ CHAR(9)+ CHAR(9)+ CHAR(9)+ 'us.TimeZoneStandardDay,' + CHAR(13) + CHAR(10)
						+ CHAR(9)+ CHAR(9)+ CHAR(9)+ 'us.TimeZoneStandardHour,' + CHAR(13) + CHAR(10)
						+ CHAR(9)+ CHAR(9)+ CHAR(9)+ 'us.TimeZoneStandardMinute,' + CHAR(13) + CHAR(10)
						+ CHAR(9)+ CHAR(9)+ CHAR(9)+ 'us.TimeZoneStandardSecond,' + CHAR(13) + CHAR(10)
						+ CHAR(9)+ CHAR(9)+ CHAR(9)+ '0,' + CHAR(13) + CHAR(10)
						+ CHAR(9)+ CHAR(9)+ CHAR(9)+ 'us.TimeZoneStandardDayOfWeek' + '), ' 
	return @attrResult
end
  4. On the Query menu, click Execute.
Modification Type:MajorLast Reviewed:1/20/2006
Keywords:kbsetup kberrmsg kbtshoot kbMBSupgrade kbprb KB911315 kbAudEndUser
©2004 Microsoft Corporation. All rights reserved.