DB user name with hyphen causing clarity upgrade to fail

Products

• Clarity PPM On Premise

Issue/Introduction

Upgrade to 16.2.2 fails with error 'Possible Dependency Error - function' if the DWH DB username has hyphen.

Steps to Reproduce:

1. Have an environment on 16.1.3 with MS SQL Database
2. Create a DB schema and DB user as below on MS SQL DB
   • DWH DB name = ppm_dwh
   • DWH username = ppm_dwh-xxx
3. Start the upgrade from 16.1.3 to 16.2.2

Expected Results:

Upgrade should be successful

Actual Results:

Upgrade fails with below error

 Process - function: DWH_CRV_SUM_DATE_FCT.xml
 Process - function: DWH_CRV_SUM_JULIAN_DATE_FCT.xml

Possible Dependency Error - function: DWH_CRV_SUM_DATE_FCT.xml
Invalid column name 'ppm_dwh'.

SQL Text:

-------  function code comes here  ---

Possible Dependancy Error - function: DWH_CRV_SUM_JULIAN_DATE_FCT.xml
Invalid column name 'ppm_dwh' " 

SQL Text:

----- function code comes here ------

Workaround:

Create a new DB username without hyphen and perform the upgrade. DB link creation is required after upgrade if the username is changed.

Cause

Due to DE116215

Resolution

DE116215 is under review