Synchronize portfolio investments job is failing post changes in OBS structure

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

The Synchronize portfolio investments job is failing for Portfolios having power filters under Contents Editor, post an activity of OBS re-structure

STEPS TO REPRODUCE:

1. In classic Clarity UI access a Portfolio and create a power filter referencing OBS, under the Contents Editor
2. Change the OBS structure in Clarity, referencing the OBS referred to in Step 1
3. Access the Portfolio and click on the Sync Now button, this shall launch the Synchronize portfolio investment job for this portfolio

Expected Results :-

The Synchronize portfolio investments job should complete for the portfolio

Actual Results :-

The Synchronize portfolio investments job fails with the following errors:

ERROR [Dispatch Synchronize portfolio investments : (tenant=clarity) (BG Job Thread)] persistence.PersistenceController (Synchronize portfolio investments) () Error happened with error code:xxxxx

ERROR [Dispatch Synchronize portfolio investments : union.persistence (Synchronize portfolio investments) () Exception on odf-pmd.project.select-list-conditional.map statement null
org.postgresql.util.PSQLException: ERROR: syntax error at or near "OR"

Environment

All supported Clarity releases

Resolution

The OBS structure which was being referenced in the Portfolio's power filter has become invalid due to the changes in the OBS structure. The power filter status shall now show as "Invalid", as a corrective step the power filter needs to be regenerated using the correct OBS structure, following which the Sync job shall work