API-1019 when creating data provider with Custom Investment

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

I want to report on Clarity Custom Investment attributes so I have enabled the attribute for Data Warehouse but when adding the custom object to a Data provider or creating a new Data Provider, I receive the following 

This data provider cannot be published.

Please correct the following items and republish.

API-1019 : Could not process the request due to internal error.

ERROR 2026-03-06 14:28:28,618 [http-nio-8080-exec-959] ppm.rest (clarity:###.#@##.com) com.ca.ppm.rest.exception.APISystemException: 
SQL error code: 0 Error message: ERROR: missing FROM-clause entry for table "dwh_odf_###_####_ln" Position: 20459

Environment

Clarity 16.4.0

Resolution

In the New Reporting rather than selecting the whole attribute in one go, rather add the attributes to the 'Selected' fields one at a time to help identify the ones with issues.

Exclude attributes with issues from Data warehouse and run load data warehouse (full Load) job.

After the job completes, include the attributes again in Data Warehouse and run the load data warehouse (full Load) job again.