Post Timesheets gets idle-in-transaction (PG)

book

Article ID: 222565

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise STARTER PACK-CLARITY PPM

Issue/Introduction

Post Timesheets gets idle-in-transaction (PG) when running after Time Slicing with deadlocks and Rate Matrix Extraction (RME)

STEPS TO REPRODUCE:

  1. Run Post Timesheets job after Rate Matrix hangs/fails

Expected Results: Post Timesheets to complete successfully 

Actual Results: Post Timesheets session gets marked as Idle. The session remains for 60 min and then gets removed as idle-in-transaction

Error message: 

ERROR 2021-08-24 04:22:19,466 [Dispatch Post Timesheets - Scheduled Posting Job : [email protected] (tenant=clarity)] niku.xql2 (clarity:admin:23271776__A5C7A63A-A0EE-4812-94CD-2D2651EC3AE3:Post Timesheets) SQLException with query: SELECT DISTINCT NPR.PROJECT_ID, NPR.RESOURCE_ID, NPR.TEAM_ID, NPR.FROM_DATE, NPR.TO_DATE, NPR.PROJECT_COST_RATE, R.RESOURCE_TYPE  FROM NBI_PROJ_RES_RATES_AND_COSTS NPR, SRM_RESOURCES R  WHERE NPR.PROJECT_ID = ?  AND NPR.TASK_ID = -1  AND R.ID = NPR.RESOURCE_ID  AND TEAM_ID = ?  ORDER BY NPR.PROJECT_ID, NPR.TEAM_ID, NPR.RESOURCE_ID, NPR.FROM_DATE
org.postgresql.util.PSQLException: FATAL: terminating connection due to idle-in-transaction timeout

Note it uses table NBI_PROJ_RES_RATES_AND_COSTS populated by Rate Matrix extraction

Environment

Release : 15.9.2, 15.9.3

Component : CLARITY TIME MANAGEMENT

Resolution

This is DE62324, Will Not Fix. Issue is due to Rate Matrix job sessions (DE59081)

Workaround (when appropriate):

  1. Set Time Slicing as Incompatible with Post Timesheets
  2. Set Rate Matrix as incompatible with Post Timesheets or move to another time