Unable to Publish Data Provider When A Copy Is Made

Products

• Clarity PPM On Premise

Issue/Introduction

After upgrading to 16.3.3, Data Provider copies are not able to be published.

Steps To Reproduce
1. Go to the Reporting Workspace > Data Providers
2. Select any provider, e.g. Investments and make a copy of it.
3. On the instance copy > Click Publish

Expected:There should not be an error. This was not an issue in 16.3.2.

Actual:Toast error message appears:

This data provider cannot be published.

Please correct the following items and republish.

• Not all selected objects were joined in the Joins tab

The error excerpt in APP log is:

ERROR 2025-08-28 12:51:31,562 [http-nio-80-exec-63] ppm.rest (clarity:user:session:PPM_REST_API) (d105e738-c3d7-4c2a-8a03-8ecffc85a5c4)
com.ca.ppm.rest.exception.APISystemException:
SQL error code: 4121
Error message: Cannot find either column "ppm_dwh" or the user-defined function or aggregate "ppm_dwh.DWH_X_CRV_CURVE_CONV_FACTOR_FCT", or the name is ambiguous.

 

Environment

16.3.3

Cause

DE175112

Resolution

On further review DE17511 the issue could not be replicated in 16.3.3 and the manual workaround to run the SP with valid DBLINK name would create the missing DWH SQLCurve functions. 

Workaround:

On MSSQL database Execute the DWH database SP DWH_CFG_CURVE_DEF_SP with the valid dblink

exec DWH_CFG_CURVE_DEF_SP 'PPMDBLINK.niku.niku'

This will create the missing SQLCurve objects.

Reference to a related issue addressed in 16.4.1 for MSSQL environments: Creating a Data Provider Receive Invalid object name 'PPMDBLINK.niku.ENTITY'