Upgrade script fails if passwords have two dollar symbols in them

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Steps to reproduce this issue are as follows.

1. Create an environment based on SQL Server 2019 DB
2. Create a login to the PPM schema that has the following password:

   clarity$$123

3. Install 15.9.3 folder structure
4. Connect to the PPM DB using the NSA
5. Extract the media for 16.0.3
6. Extract install.jar. Place the third-party files in the same folder
7. Run install.bat
8. Provide the home directory of the 15.9.3 installation (from Step 3)

Expected Results: The upgrade script continues to prompt for new inputs.

Actual Results: The upgrade script fails with the following error.

_dbBackupCheck:
  CA PPM upgrade from 15.9.3 to 16.0.3 detected.
BUILD FAILED
C:\Users\Downloads\1603\gateway.xml:44: The following error occurred while executing this line:
C:\Users\Downloads\1603\install.xml:235: The following error occurred while executing this line:
C:\Users\Downloads\1603\install.xml:1454: The following error occurred while executing this line:
C:\Users\Downloads\1603\install.xml:1576: The following error occurred while executing this line:
C:\Users\Downloads\1603\install.xml:1617: java.sql.SQLInvalidAuthorizationSpecException: 
[CA Clarity][SQLServer JDBC Driver][SQLServer]Login failed for user 'someoneTesting'.

Cause

DE67281

Resolution

DE67281 will not be fixed.

Workarounds:

1. Avoid using DB passwords that contain the \$\$ literal
2. If it still has to be used, encrypt the passwords in the properties.xml file by logging in from the CSA.