My Oracle Support Banner

E-UPG UPGCUST Compare error: Internal Error: invalid transaction handle instance passed from SamDestroy (Doc ID 1984564.1)

Last updated on DECEMBER 06, 2019

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

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


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