My Oracle Support Banner

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

Last updated on DECEMBER 04, 2018

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
checked for currency 4/19/18

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

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
Goal
Solution


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