E-SEC/DB2 Issue With Deadlocking On PSLOCK Table When Saving Roles in PT 8.5x (Doc ID 1372612.1)

Last updated on JANUARY 12, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.50 to 8.52 [Release 8.4]
Information in this document applies to any platform.
***Checked for Relevance 15-04-2013***

Symptoms

Customer were not experiencing this issue in prior tools release, but now when trying to make any changes to a role that has several users assigned to it (i.e. 20,000 plus) the following SQL error occurs:

A Fatal PeopleCode SQL error occurred.

SQL error in Exec. (2,280) FUNCLIB_PTSED.OPRID.FieldFormula
Name:UpdateOprVersion PCPC: 2751 Statement 28
Called from:FUNCLIB_PTSED.OPRID.FieldFormula
Name:UpdateUPMVersions Statement: 34
Called from:ROLEMAINT.GBL.SavePostChange Statement:23

This is issuing a version update on PSOPRDEFN table for all users of this Role.
This is causing the DB2 dead locks.

Changes to roles with users less than 20,000 seems to work just fine.

The problem also happens when running Dynamic Role Rules, it fails when executing roles rules that have over 20,000 users in the role.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms