Clarity PPM: Synchronize Portfolio Investments Job Error (PG Environment)

book

Article ID: 194307

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

In the PostgreSQL implementation, the job Synchronize Portfolio Investments fails after saving portfolio changes. 

ALERT:Synchronize Portfolio: Unknown error

The APP log error shows:

Portfolio Sync failed: java.lang.RuntimeException: com.niku.union.persistence.PersistenceException: 
SQL error code: 0
Error message: ERROR: missing FROM-clause entry for table "pfmxxxxxxxxxxxxxxxxx"
  Where: PL/pgSQL function trigger_fct_temp_pfm_rank_edits_t1() line 8 at EXECUTE
SQL statement "insert into temp_pfm_rank_edits(portfolio_id, plan_id, user_id, instance_id, rank, is_new, temp_rank, created_date, created_by, last_updated_date, last_updated_by)
           SELECT ranks.portfolio_id, ranks.plan_id, ranks.user_id, ranks.instance_id, ranks.rank, ranks.is_new, 0, ranks.created_date, ranks.created_by, ranks.last_updated_date, ranks.last_updated_by
             from (SELECT row_number() over ( order by rank, last_updated_date asc, temp_rank asc) as new_rank
                , r.*
                from pfm_rank_edits r where r.portfolio_id=v_portfolio_id and r.plan_id=v_plan_id and r.user_id=v_user_id and rank > 0) ranks
                order by rank, last_updated_date asc, temp_rank asc"
PL/pgSQL func
 
 

Cause

This is reported as DE54669 and is under investigation.

Environment

Release : 15.8

Component : CA PPM SAAS APPLICATION

Resolution

DE54669 is being reviewed by Engineering team.