Synchronize Portfolio Investment error

Products

• Clarity PPM SaaS

Issue/Introduction

Synchronize portfolio investment job is failing for certain portfolios with the following error in the logs:

ERROR 2021-09-11 15:55:41,524 [Dispatch Synchronize portfolio investments : [email protected] (tenant=clarity)] niku.njs 
(clarity:[email protected]:44683312__3FB989F9-770A-448C-B305-F503838C8488:Synchronize portfolio investments) 
Error executing job: 5339350 error com.niku.union.persistence.PersistenceApplicationExceptionERROR 

2021-09-11 16:11:17,315 [Dispatch Synchronize portfolio investments : [email protected] (tenant=clarity)] union.persistence 
(clarity:[email protected]:44683364__BB74ABBE-2096-444A-AA3D-B9CEE0F91BD4:Synchronize portfolio investments) 
Exception on odf-pmd.project.select-list-conditional.map statement nullorg.postgresql.util.PSQLException: 
ERROR: syntax error at or near "OR"  Position: 28472

MS SQL Server :

com.niku.union.persistence.PersistenceApplicationException: java.sql.SQLException: [CA Clarity][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'OR'.

at com.niku.union.persistence.PersistenceController.handleSQLException(PersistenceController.java:2365)

Environment

Release : 15.9.3

Component : CLARITY PORTFOLIO MANAGEMENT

Cause

This started after some Portfolios were copied from a TEST environment.

The OBS Unit names used in the filters were incorrect and did not match existing OBS Units in Production

Resolution

Correct the OBS names in the Power Filters to match OBS Units in that environment

 

Open the Portfolio that is failing to Sync

Go to the "Contents Editor" tab

For each Investment Type Included, inspect the Power Filter and Evaluate if needed