E-SEC/DB2 Issue With Deadlocking On PSLOCK Table When Saving Roles in PT 8.5x
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***
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
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.
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