My Oracle Support Banner

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

Last updated on FEBRUARY 01, 2019

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.50 to 8.52 [Release 8.4]
Information in this document applies to any platform.


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.




To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.