Error message when you upgrade to Microsoft CRM 3.0: "Microsoft CRM 3.0 Server Setup failed"
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 |
For Additional Information, please see:
http://mscrm.exiis.net/microsoft-crm-support/Pages/default.aspx
|