E-COMP: System Error End of fetch Received when Running Compare Report on project that contains Records

(Doc ID 2279666.1)

Last updated on APRIL 26, 2018

Applies to:

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

Symptoms

On : 8.55 version, Compare Reports


When running a compare report of a project between databases that contains a record object, app designer gives the following error and user has to close app designer and reconnect in order to continue using the application:

ERROR
------------
Upgrade message : System Error : File: E:\pt85507c-retail\peopletools\src\psprj\upgrade.cppSQL error. Stmt #: 9072 Error Position: 0 Return: 1 - End of fetch (SQLSTATE PS001),LOW) (62,16)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the compare report

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run compare report and identify differences between the databases.

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