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.

Time Slicing failures post 15.9 Patch 1 (deadlock on fin_benefit_plan_details)

book

Article ID: 213177

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

The Time Slicing job is failing post upgrade to 15.9 patch 1. Error seeing in bg-ca.logs:

ERROR 2021-02-26 11:56:05,264 [Dispatch Time Slicing :
[email protected]<server>l (tenant=clarity)] niku.blobcrack (clarity:admin:42525144__7CFDBB82-3C78-47D4-8151-75235D5001E6:Time Slicing)
Exception during blobcrack processcom.niku.union.persistence.PersistenceDeadlockException: SQL error code: 0Error message:
ERROR: deadlock detected Detail: Process 22417 waits for ShareLock on transaction 3866427759; blocked by process 938.Process 938 waits for ShareLock on transaction 3866427819; blocked by process 22417.
Hint: See server log for query details. Where: while updating tuple (3,31) in relation "fin_benefit_plan_details"Executed: update fin_benefit_plan_details set odf_ss_benefit = 2 where id in (select id from fin_benefit_plan_details where odf_ss_benefit = ? limit 1000)
Derived from statement:
<?xml version="1.0" encoding="UTF-8"?><statement sortColumnPath="/data/header/sortInfo/@sortColumn" sortDirectionPath="/data/header/sortInfo/@sortDirection" slicePath="/data/header/pagination/sliceInfo/@slice"
sliceSizePath="/data/header/pagination/sliceInfo/@sliceSize" inputSource="map" xmlns="http://schemas.niku.com/2002/pmd"> <sql dbVendor="oracle"> <text>update fin_benefit_plan_details set odf_ss_benefit = 2 where odf_ss_benefit = ?
and rownum &lt;= 1000</text> <param name="sliceStatusFlag" path="sliceStatusFlag/@value" type="long" direction="IN" expressionListDelimiter=","/> </sql> <sql dbVendor="mssql">
<text>SET ROWCOUNT 1000 update fin_benefit_plan_details set odf_ss_benefit = 2 where odf_ss_benefit = ? SET ROWCOUNT 0</text> <param name="sliceStatusFlag" path="sliceStatusFlag/@value" type="long" direction="IN" expressionListDelimiter=","/> </sql>
<sql dbVendor="postgres"> <text>update fin_benefit_plan_details set odf_ss_benefit = 2 where id in (select id from fin_benefit_plan_details where odf_ss_benefit = ? limit 1000)</text>
<param name="sliceStatusFlag" path="sliceStatusFlag/@value" type="long" direction="IN" expressionListDelimiter=","/> </sql></statement>

Cause

Deadlock on fin_benefit_plan_details

Environment

Release : 15.9, 15.9.1

Component : CLARITY SAAS TIME SLICING

Resolution

Complete fix included in 16.0

Additional Information

See also: Time Slicing job failures - troubleshooting / known causes