ORA-00904 Invalid identifier error while running Time Slicing Sync Job

Products

• Clarity PPM On Premise

Issue/Introduction

Clarity upgraded to 16.3.3.1 and the following error is found in the bg log while running the Time Slicing Sync Job. 

ERROR[pool-7215-thread-1] blobcrack.SqlCurveCrack (clarity:none:none:none) () Exception on thread process()
com.niku.union.persistence.PersistenceException: 
SQL error code: 904
Error message: ORA-00904: "ODF_CA_PROJECT"."ODF_NK_Z_NLAB_COST": invalid identifier

Environment

Clarity 16.3.3 Patch 1 (16.3.3.1)

Cause

The ORA-00904 error stack indicates that the Oracle database does not recognize the column 'ODF_CA_PROJECT'.'ODF_NK_Z_NLAB_COST' when the query is executed. While references to this column exist in tables like ODF_ATTR_METADATA and ODF_CUSTOM_ATTRIBUTES, it is notably absent from ODF_NK_FIELDS.

Resolution

Recreate the TSV attribute (attribute ID = Z_NLAB_COST) under the Project Object.