E-UPG UPGCUST Compare error: Internal Error: invalid transaction handle instance passed from SamDestroy

(Doc ID 1984564.1)

Last updated on AUGUST 08, 2016

Applies to:

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

Symptoms

On : 8.54 version, Change Assistant
 
When running Task 2-14-1: Running the UPGCUST Compare, it failed with the following message:

ERROR
-----------------------

Process Definitions Application Upgrade Compare started: 2015-02-25-10.15.37
File: E:\pt850-903-R1-retail\peopletools\SRC\psmgr\mgrgensql.cppSQL error. Stmt #: 2057 Error Position: 0 Return: 1722 - ORA-01722: invalid number
Failed SQL stmt:SELECT SEQNO, RECNAME, RECFIELDNAME, PRCS_IS_VAL_REQD, PACKAGEROOT, QUALIFYPATH, APPCLASSID, PT_APPCLASSMETHOD, PT_PRCSLBLTYPE, MESSAGE_SET_NBR, MESSAGE_NBR, LABEL_ID FROM PS_PRCS_RUNPARM WHERE PRCSTYPE = :1 AND PRCSNAME = :2 ORDER BY SEQNO
System Error : Process DefinitionsCrystal PDFOECONFRH
Process Definitions Compare Report Created : e:\ca\output\HCM91to92_PI9xml_hdv92_InitialPass\UPGCUST\Upg20ProcessDefinitions.prt
Internal Error: invalid transaction handle instance passed from SamDestroy 0: 39200 vs 0
Error - failure during Compare process.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the step "Task 2-14-1: Running the UPGCUST Compare" in Change Assistant

Cause

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