My Oracle Support Banner

E-PRCS: PSMSTPRC Service not Releasing the Version Store in Tempdb in SQL Server at Daylight Savings Time Change Filling TempDB (Doc ID 2889842.1)

Last updated on JANUARY 25, 2024

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.58 and later
Information in this document applies to any platform.

Symptoms


PSMSTPRC.exe service, at daylight savings change, not releasing the version store in tempdb causing tempdb to reach max size and not allow other SQLs to run that use tempdb.
 

The issue can be reproduced with the following steps:
1. Process requests submitted normally during daylight savings change

2. Leave Process Scheduler up and running in SQL Server environment during time change


3. Observe tempdb reaching max size over time after daylight savings change caused by PSMSTPRC.exe service

 

Once the tempdb reaches the max size the following error is seen in the Master Scheduler log...

PSMSTPRC.5984 (0) [2022-03-16T01:19:15.969 <NAME>@<NAME>] - - - (3)
File:
E:\PT858P08B_2011180857-retail\peopletools\src\psschdlr\schedulerrecurs.cppSQL
error. Stmt #: 171 Error Position: 0 Return: 8601 - [Microsoft][ODBC
Driver 17 for SQL Server][SQL Server]Transaction aborted when accessing
versioned row in table 'dbo.PSPRCSQUE' in database '<DBNAME>'. Requested
versioned row was not found. Your tempdb is probably out of space. Please
refer to BOL on how to configure tempdb for versioning. (SQLSTATE 42000) 3958
Failed SQL stmt: SELECT R.PRCSINSTANCE ,R.ORIGPRCSINSTANCE
,R.RECURORIGPRCSINST,R.MAINJOBINSTANCE ,R.PRCSJOBSEQ ,R.PRCSJOBNAME
,R.PRCSNAME ,R.PRCSTYPE ,R.RECURNAME ,R.TIMEZONE ,R.PT_RETENTIONDAYS
,R.PTNONUNPRCSID ,R.PT_OVRDFROMEMAILID FROM PSPRCSQUE R ,PS_PRCSRECUR S WITH
(READUNCOMMITTED) WHERE ((R.RUNSTATUS IN ('9', '17') AND S.INITIATEWHEN =
1) OR (R.RUNSTATUS IN ('3','6', '7', '9','10','12', '17') AND
S.INITIATEWHEN = 0)) AND R.INITIATEDNEXT = 0 AND R.RUNLOCATION = '2' AND
R.RECURNAME > ' ' AND R.PRCSJOBSEQ = 0 AND R.RECURNAME = S.RECURNAME
PSMSTPRC.5984 (0) [2022-03-16T01:19:15.974 <NAME>@<NAME>] - - - (1)


 

Cause

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
Symptoms
Cause
Solution
References


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