Custom Report Fails with Arithmetic overflow error converting expression to data type int

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

When running a custom report or accessing a Data Provider-based portlet in Clarity PPM, the system returns "Report Timed Out. Please add more filters and try again"'

The error stack includes: SQL Error: 8115 along with the complete SQL query:

SQL error code: 8115
Error message: Arithmetic overflow error converting expression to data type int.
Executed:
/*[reporting|data_provider|DP00000044]*/
   Select count(1) as grped_obj_insts_count____aggr , sum(odf_sql___sql00000022____investment_key) as odf_sql___sql00000022____investment_key____aggr_sum,.....

Environment

Clarity 16.4.0

Resolution

The report logic is incorrectly applying Aggregation (SUM) to a unique identifier or "Key" field (e.g., investment_key, project_id, or task_key). Aggregation should only be applied to metrics (Hours, Cost), not keys.