Sales
Denmark +45 7944 7000
Europe +45 7944 7000
North America +1 (202)-536-4165
Support
Denmark +45 7944 7002
North America +1 (202)-536-4165

Database update error encountered when upgrading to Resource Central 3.8 SR1

Modified on Thu, 22 Aug at 11:28 PM

 

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

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article