Microsoft KB Archive/911315

= Error message when you upgrade to Microsoft CRM 3.0: &quot;Microsoft CRM 3.0 Server Setup failed&quot; =

Article ID: 911315

Article Last Modified on 1/20/2006

-

APPLIES TO


 * Microsoft Dynamics 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:  Open SQL Query Analyzer. To do this, click Start, point to Programs, point to Microsoft SQL Server, and then click Query Analyzer. Click the CRM METABASE database.  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  On the Query menu, click Execute.

Additional query words: crm3 crm30 crm3.0

Keywords: kberrmsg kbtshoot kbsetup kbprb kbmbsupgrade KB911315

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.