search cancel

SQL Server DB - Upgrade script fails if passwords have two dollar symbols in them

book

Article ID: 253634

calendar_today

Updated On:

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

This behaviour is currently under review.