DB link creation fails with special character in Clarity password

Products

• Clarity PPM On Premise

Issue/Introduction

Database link creation fails if the Clarity schema password contains a special character, such as a '!', '@'...

Steps to Reproduce

1. Configure a Clarity and DWH Oracle schemas to use password 'niku'.
2. As part of the Clarity configuration, create the database link:
   > admin db create-db-link

Expected and Actual results: Database link is successfully created.
> admin db create-db-link
Configuring DBLink...
dwhurl:jdbc:oracle:thin:@hostname:port:clarity tenantdbHost:hostname userid:schema password:*******
ServiceId is enabled. DB Link creation initiated in Standalone Instance
CALL CMN_DBLINK_SP('dblink','hostname',port,'servicename','schemaname','niku',0,0)
1 of 1 SQL statements executed successfully

3. Change the password of the PPM schema to contain a special character, like 'changeme!'
4. Create the database link:
   > admin db create-db-link

Expected results: Database link is successfully created.

Actual results: Database link creation fails.
> admin db create-db-link
Configuring DBLink...
dwhurl:jdbc:oracle:thin:@hostname:port:clarity tenantdbHost:hostname userid:schema password:*******
ServiceId is enabled. DB Link creation initiated in Standalone Instance
CALL CMN_DBLINK_SP('dblink','hostname',port,'servicename','schemaname','changeme!',0,0)
Failed to execute:  CALL CALL CMN_DBLINK_SP('dblink','hostname',port,'servicename','schemaname','changeme!',0,0)
Error occurred: C:\1622\clarity\.setup\scripts\db.xml:3698: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended
ORA-06512: at "schema.CMN_DBLINK_SP", line 46
ORA-06512: at line 1

Check admin.log or use -verbose for more information.

Environment

Clarity 16.2.1

Cause

DE81032

Resolution

This issue has been fixed in Clarity 16.2.3.