Denmark +45 7944 7000
Europe +45 7944 7000
North America +1 (202)-536-4165
Denmark +45 7944 7002
North America +1 (202)-536-4165
Start a conversation

Database update error encountered when upgrading to Resource Central 3.8 SR1



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


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.



  •           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.



Applies to: All versions of RC before RC 3.8 SR1

Reference: TFS #87804

Knowledge base ID: 0204

Last updated: September 14, 2016

  1. 41 KB
  2. View
  3. Download
Choose files or drag and drop files