E-DB2 - Lock Timeout on Tables PSOPRDEFN and PSVERSION (Doc ID 796713.1)

Last updated on NOVEMBER 18, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.45 to 8.49 [Release 8.4]
Microsoft Windows (32-bit)
checked for currency 9/16/10
checked for currency 7/27/12
checked for currency 1/6/14
checked for currency 6/12/15
checked for currency 11/18/16

Goal

The customer encountered lock timeout issues on tables PSOPRDEFN and PSVERSION. When the lock timeout is detected, clients can't log in to the sysem. Sometimes, the lock will be released safely and the system will be returned to normal. But sometimes, the system will not come back until they restart the application server manually. This cannot be replicated, and happens intermittently.

In the logs, there are:
SERVICE=GetCertificate MSG_ID=0 REASON=server died
131658.SCSVR123!BBL.10280.7540.0: CMDTUX_CAT:1836: WARN: Server(10296) processing terminated with SIGKILL after SVCTIMEOUT

Solution

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