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
KB0220 - Script to update database for use of RealTime Service 6.4.27+ on older versions of Resource Central

 

Summary

RealTime Service 6.4.27+ can work properly with Resource Central (RC) 4.0 SR1+.

But when it works with older versions of RC such as RC 3.8 HF10, RC 4.0 RTM, RC 4.0 HF 1 and HF2, an error usually arises that says something like this:

Error processing appointment for user room006 - room006@psteam.com: 't5', start:9/22/2017 11:30:00 AM, end:9/22/2017 12:00:00 PM, created:9/22/2017 7:47:02 AM, modified:9/22/2017 7:47:03 AM, recurring:False : Invalid column name 'PrivateMeeting'.

In order for it to work with those older versions of RC, the following script is needed:

GO

IF NOT EXISTS(SELECT * FROM sys.columns WHERE Name = N'PrivateMeeting' and Object_ID = Object_ID(N'Reservations'))

ALTER TABLE [dbo].[Reservations] ADD PrivateMeeting BIT NOT NULL DEFAULT 0

GO

Run this SQL script to add “PrivateMeeting” column to Reservations table in RC database.

 

Properties

Applies to: RC 3.8 RTM (3.8.0001.0256) to RC 4.0 HF1 (4.0.0001.0376)

Reference: TFS #133575

Knowledge base ID: 0220

Last updated: Nov 22, 2017