T52-2021 BIOVIA Desktop Connector 2021 SP1, Standalone Desktop Connector database – Oracle Only

Program

BIOVIA Desktop Connector 2021 SP1

Operating System

Microsoft Windows Server (64 bit), 2016 and 2019

Background

The DesktopConnectorService_Database_Oracle.zip archive, included in the Desktop Connector and Notebook distribution packages contains scripts for creating and upgrading a standalone Desktop Connector service database. In these scripts a required GRANT EXECUTE ON DC_GETSERVICEID TO ELNUSER was omitted and this will prevent users form using the upgraded desktop connector.

For an upgrade the script "~\Upgrade\2021_SP1\Procedures\DC_GETSERVICEID.SQL" also has errors.

Workaround

New 2021 SP1 installation

Execute the statement to add the grant.

GRANT EXECUTE DC_GETSERVICEID TO ELNUSER;

Upgrade to 2021 SP1

1. Upgrade the database as described in the Messaging Service Administration Guide

2. To correct the DC_GETSERVICEID procedure, run the “new install” version of the script (.\Procedures\DC_GETSERVICEID.sql)

3. Execute the statement to add the grant

GRANT EXECUTE DC_GETSERVICEID TO ELNUSER;

BIOVIA Support

If you have any questions, please contact BIOVIA Support.