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 :
Release : 15.9.3
Component : CLARITY PORTFOLIO MANAGEMENT
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
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