ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
Synchronize Portfolio Investment error
Article ID: 224631
Updated On:
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)
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
Environment
Release : 15.9.3
Component : CLARITY PORTFOLIO MANAGEMENT
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
Feedback
Yes
No
Powered by
