API-1019 error publishing a MUX Reporting Data Provider

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

We created a new Data Provider by copying the OOTB Investment Data Provider in MUX Reporting module.
When publishing we get the API-1019 : Could not process the request due to internal error.

app-ca.log file shows the following error:

ERROR 2025-11-11 07:11:44,058 provider.DataProviderResourceProvider (clarity:myuser:mysession:PPM_REST_API) (90b34405-a41d-4049-afad-67d024d1791a) Error occurred while validating the query
com.niku.union.persistence.PersistenceException: 
SQL error code: 942
Error message: ORA-00942: table or view does not exist

Executed:
/*[reporting|data_provider|DP00000024]*/
   select q.* ,(select 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 DWH_CRV_SUM_TOTAL_FCT(sqlc.crv_fcst_oper_cost)  from dwh_inv_investment_crv_facts sqlc where sqlc.investment_key = q.inv____investment_key) as inv____fcst_cst_op__tsscalar,(select DWH_CRV_SUM_TOTAL_FCT(sqlc.crv_plan_benefit)  from dwh_inv_investment_crv_facts sqlc where sqlc.investment_key = q.inv____investment_key) as inv____plan_benefit__tsscalar,(select DWH_CRV_SUM_TOTAL_FCT(sqlc.crv_actual_oper_cost)  from dwh_inv_investment_crv_facts sqlc where sqlc.investment_key = q.inv____investment_key) as inv____actual_cst_op__tsscalar,(SELECT (I.crv_alloc_labor).curve_sum/

......

Environment

Clarity 16.3.3

Resolution

Please proceed as follows:

• Go to Classic > Administration > General Settings >System Options
• Uncheck the Include Sql Curve Data option
• On the DWH schema truncate these two tables: dwh_meta_columns and dwh_meta_tables
• Run the full Load DWH job

If it successfully runs, do the following:

• Check the Include Sql Curve Data option
• On the DWH schema truncate these two tables: dwh_meta_columns and dwh_meta_tables
• Run the full Load DWH job