Support
Login
Your Password

Sales
North America
Phone: +1 (905)-655-9262
Fax: +1 (905)-655-9395
Email: info@add-on.com

Europe
Phone: +45 7944 7000
Fax: +45 7944 7001

China
Phone: +86 (21) 2221 8396
Email: info-china@add-on.com
Support
Denmark
+45 7944 7002

Europe
+44 (0) 203 002 3889

North America
+1 (202)-536-4165
Knowledgebase: Resource Central
KB0204 - Database update error encountered when upgrading to Resource Central 3.8 SR1

 

Symptom

When you upgrade from an older version of Resource Central (RC) to RC 3.8 SR1, the following error message shows up:

Cause

This issue only occurs with SQL Server 2008 R2.

The built-in SQL function (CONCAT) used in RC Script is introduced for SQL Server 2012 and onwards. Therefore, it is not supported in SQL Server 2008 R2.

 

Resolution

  •           Click [Close] button on the message and keep going with the upgrading process until it is completed
  •           Go to RC server, reach the folder 'UpgradeScripts' (C:\inetpub\wwwroot\ResourceCentral\DB Scripts\UpgradeScripts)
  •           Copy 4 SQL scripts (in attachment) to this folder to replace the existing script files
  •           Open RC Configuration Tool, click [Update Database] again, the database will be updated to the latest version.

 

Properties

Applies to: All versions of RC before RC 3.8 SR1

Reference: TFS #87804

Knowledge base ID: 0204

Last updated: September 14, 2016


Attachments 
 
 ScriptFor2008R2.zip (41.01 KB)