Calculated Field using virtual Field shows error
search cancel

Calculated Field using virtual Field shows error

book

Article ID: 417412

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity FedRAMP Clarity PPM SaaS

Issue/Introduction

Unable to create calculated field using virtual attribute and existing calculated fields created on virtual attribute are broken

Steps to Reproduce: 

  1. Login to Clarity using administrative rights
  2. Create an attribute of number type (example: Budget Cost (z_bugget)) under Project
  3. Now create a virtual attribute under Risk object referencing to the attribute (example: Budget Cost (z_bugget)) created under project
  4. Now create a calculated attribute under risk object using the virtual attribute as expression. 

Expected Results: The virtual attribute should be created

Actual Results: System Error Contact System Administrator while creating the virtual attribute and below error is see in the app ca log 

WARN  2025-11-06 06:12:27,029 [http-nio-8080-exec-1102] odf.view-generation (clarity:XXXX:XXXX-XX-XXX-XXX-XXXX:odf.updateCalculatedAttribute) (XXX-XXX-XX-XX-XXX) Reported Issue: 
SQL error code: 0
Error message: ERROR: column pk_id.z_budget does not exist
  Position: 220

Environment

Clarity 16.3.3

Cause

DE178443,DE174977

Resolution

Fixed in

  • Clarity 16.4.0 
  • Clarity 16.3.3 Patch 2 (16.3.3.2)