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.
Executed:
/*[reporting|data_provider|DP00000025]*/
 select q.* ,(select ppm_dwh.DWH_CRV_SUM_TOTAL_FCT(sqlc.crv_actual_cap_cost) from dwh_inv_investment_crv_facts sqlc where sqlc.investment_key = q.inv____investment_key) as inv____actual_cst_cap__tsscalar,(select ppm_dwh.DWH_CRV_SUM_TOTAL_FCT(sqlc.crv_bdgt_benefit) from dwh_inv_investment_crv_facts sqlc where sqlc.investment_key = q.inv____investment_key) as inv____budget_benefit__tsscalar,(select ppm_dwh.DWH_CRV_SUM_TOTAL_FCT(sqlc.crv_fcst_cap_cost) from dwh_inv_investment_crv_facts sqlc where sqlc.investment_key = q.inv____investment_key) as inv____fcst_cst_cap__tsscalar,(SELECT ppm_dwh.DWH_CRV_SUM_TOTAL_FCT(I.CRV_EAC_LABOR)/
   (case when 'NONE' = 'hours' then 1
   when 'NONE' = 'days' then 1
   when 'NONE' = 'fte' then INV.CRV_EAC_LABOR_FTE
   when 'NONE' = 'pct' then ppm_dwh.DWH_X_CRV_CURVE_CONV_FACTOR_FCT('NONE',I.CRV_EAC_LABOR,null)
   else 1 END)

On MSSQL database:

Execute the DWH database SP 

exec DWH_CFG_CURVE_DEF_SP 'PPMDBLINK.niku.niku'

This will create the missing objects.

 

Environment

16.3.3

Cause

DE175112

Resolution

This is under investigation