My Oracle Support Banner

E-UPG: PeopleTools Only Upgrade has Step "Reviewing Select PeopleTools Objects" Failed with the Following: "... Invalid column name 'PTRECUREVERY'... invalid transaction handle instance passed from SamDestroy..." (Doc ID 2608640.1)

Last updated on NOVEMBER 12, 2019

Applies to:

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

Symptoms

When attempting to compare Project PPLTLS84CUR for step "Reviewing Select PeopleTools Objects" as part of the Upgrade to PT 8.57, the following error occurred:

Recurrence Definitions Application Upgrade Compare started: 2019-11-07-12.51.16 (62,6)

System Error: File: E:\PT857P08B_1907010952-retail\peopletools\src\osmgr\mgrgensql.cpp
SQL error. Stmt#: 2161 Error Position: 0 Return: 8607 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'PTRECUREVERY'. preparePE (62,16)

System Error: UNMONDAY, RUNTUESDAY, RUNWEDNESDAY, RUNTHRUSDAY, RUNFRIDAY, RUNSATURDAY, RECURDAYSPCL, PTRECUREVERY, BEGINDTTM, ENDDTTM, REPEATUNIT, DURATION, DURATINOUNIT, INITIATEWHEN, RECURDESCR, RECUR_USECURRDATE FROM PS (62,16)
Internal Error: invalid transaction handle instance passed from SamDestroy 0: 35551 vs 0

Recurrence Definitions Compare Created: c:\temp\PPLTLS84CUR\Upg24RecurrenceDefinitions.prt (75,9)


The issue can be reproduced at will with the following steps:
1. Start PeopleTools upgrade to PT 8.57 using Change Assistant.
2. Run the step "Reviewing Select PeopleTools Objects" in Change Assistant

Changes

 

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
Changes
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.