New UI Reports export fails with "Not Supported" or API-1005 curve calculation errors in Clarity PPM

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

When attempting to run or export the out-of-the-box (OOTB) reports eg.(Project Status Report (Sample) ) to PDF in Clarity PPM, report exports fail, widgets display as "Not Supported", or database and scalar curve calculation errors occur.

Specific error signatures observed in logs or export outputs include:

Unable to process the request: ERROR: column "team___allocation_curve__tsscalar" does not exist

com.ca.ppm.rest.exception.BadRequestException: API-1005 : Attribute(s) 'costplandetail____budget_forecast_var' specified in query parameters are not supported or secured.
com.ca.ppm.rest.exception.BadRequestException: API-1005 : Attribute(s) 'team____allocation_curve' specified in query parameters are not supported or secured.
com.ca.ppm.rest.exception.BadRequestException: API-1005 : Attribute(s) 'inv____labor_alloc' specified in query parameters are not supported or secured.


ERROR [DataProvider-Cache-Preloader] odf.out - Unable to parse DWH expression for calculated attribute: odf_calc_attr____scattr00004 expression: Subtract(resource____avail_curve,team____allocation_curve)
java.lang.Exception: Invalid attribute 'resource:avail_curve'
java.lang.Exception: Invalid attribute 'timesheet:actuals'

 

 

Environment

Clarity 16.4.2

Cause

The Include SQL Curve Data option in System Options is disabled. Without SQL Curve data enabled, report processing engines cannot evaluate per-period curve metrics (such as team____allocation_curve, resource____avail_curve, or costplandetail____budget_forecast_var)

Resolution

• Enable SQL Curve Data Option (Administration > System Options > Enable Include SQL Curve Data
• Execute Data Warehouse Full Load
• Flush Clarity Cache