Timeslice Job failure: select-updated-TSV-actcost

Products

Clarity PPM On Premise

Issue/Introduction

Time Slicing job failing with error

ERROR 2021-07-22 12:03:01,838 [Dispatch Time Slicing : bg@dendvb3vaclr01 (tenant=clarity)] niku.njs (clarity:admin:81136965__6AB7460B-E28D-43BC-9C64-265D431C0FAB:Time Slicing) Error executing job: 7377915 error The timeslice job has failed.
ERROR 2021-07-22 12:04:02,071 [Dispatch Time Slicing : bg@dendvb3vaclr01 (tenant=clarity)] union.persistence (clarity:admin:81136969__1952574C-DF35-4B5F-9D20-1CA9A4361D20:Time Slicing) Undefined statement set: odf-pmd.assignment.select-updated-TSV-actcost_curve.map ...

Additional error:

Error occurred trying to materialize object "task"
com.niku.union.odf.exception.ODFException: Error resolving derived attribute "tc_parent_program". There is no attribute with code "tc_parent_program" defined for object "project".

Environment

Release : 15.9

Component : CA PPM TIME SLICING

Cause

Error Undefined statement set: odf-pmd.assignment.select-updated-TSV-actcost_curve.map ...

has to do with the job cannot find the field prassignment.actcost

This was caused by the corruption on the assignment and task object.

This error:

Error occurred trying to materialize object "task"
com.niku.union.odf.exception.ODFException: Error resolving derived attribute "tc_parent_program". There is no attribute with code "tc_parent_program" defined for object "project".

shows the attribute which is missing and needed to be recreated on the task object.

Resolution

Resolution was to recreate the deleted attribute.