PeopleSoft 9.2 Upgrade: What is UPGCOUNT

by Prashant on March 3, 2014

in PeopleSoft Upgrade

UPGCOUNT is a delivered Application engine program which is used to generate a report showing the row count of PeopleSoft tables. UPGCOUNT is run as part of PeopleSoft application upgrade and can be run on demand too. During application upgrade, it is automatically invoked by change assistant and UPGCOUNT.LIS report file is generated with the list of PeopleSoft tables with their row count.

Running UPGCOUNT AE in Change Assistant

Step ‘Reviewing Table Row Counts’ executes application engine UPGCOUNT by invoking application engine executable PASE.exe.

image

Running UPGCOUNT AE from Application Designer

If you wish, you can also run this application engine from PeopleSoft Application Designer. Open the application engine UPGCOUNT in application designer, click on run button. Enter the desired parameter and run the application engine. Make sure to check the log path to get the UPGCOUNT.LIS report.

image

Running UPGCOUNT AE from command line

To run application engine from command line, use the following syntax
<PS_HOME>\bin\client\winx86\psae -CT Oracle -CD Database_name -CO User_Id -CP User_Password -R UPGCOUNT1 -AI UPGCOUNT -I 11 -TRACE 135

Also Read:  PeopleTools 8.54 Will Support 64-bit PeopleTools Development Client

{ 2 comments… read them below or add one }

Sharath July 26, 2014 at 9:07 am

Hi Prashant,

A very good evening to you. I have a question. Can you tell me what is the user the upgcount application engine program. Though it is run to check the count of Peopletools table but what do we need to understand after reviewing upgcount.lis file.
Can you please explain

Thank you,
Sharath

Reply

Prashant July 27, 2014 at 3:40 am

Hi Sharath
UPGCOUNT is primarily used during upgrades. You can run it pre and post upgrade to make sure that the count of tables is same.

Reply

Cancel reply

Leave a Comment

Previous post:

Next post: