My Oracle Support Banner

E-CA: Peopletools Upgrade Error - ptgentabstats.sql File Not Found (Doc ID 2259007.1)

Last updated on OCTOBER 15, 2021

Applies to:

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

Symptoms

On :  8.55 version, Change Assistant

Using Change Assistant to upgrade Peopletools 8.54 to Peopletools 8.55.13, cannot find files during the execution of the upgrade job

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

Searching for file of scripts\ptgentabstats.sql in D:\ca_staging\softwareupdatePeopleTools_Only_Upgrade{-HRXXXX}IP\ – File Not Found.
Searching for file of scripts\ptgentabstats.sql in C:\PT8.55.13\ – File Not Found.
Searching for file of scripts\ptgentabstats.sql in D:\pum19\pt\ps_app_home\ – File Not Found.
Searching for file of scripts\ptgentabstats.sql in C:\PT8.55.13\ – File Not Found.
Searching for file of ptgentabstats.sql – Unsuccessful:File Not Found.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Install CA PT 8.55.13
2. Create the CA job for upgrading from PT 8.54 to PT 8.55
3. Run the job within CA

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot complete the Tools upgrade to PT 8.55.13.

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.