Chat now with support
Chat with Support

Stat 6.2 - Upgrade Notes

Upgrade the Stat database

After you have created a copy of your Stat® production database (test database), you are ready to begin the test upgrade.

To upgrade the Stat database:
1
Make a backup of the test database (copy of production).
2
Depending on your DBMS platform, do one of the following:
•
For Oracle®, the scripts can be run using SQL*Plus or Toad™ for Oracle.
•
For SQL Server®, execute the appropriate upgrade scripts using Toad for SQL Server or SQL Query Analyzer. Do not use other third-party tools.

Please note the following:

•
Refer to each of the database script sections to determine which scripts need to be run to support the version or versions of PeopleSoft that you support.
•
Disable or remove any custom defined database triggers against the Stat schema.
•
Before executing each script, read the instructions located at the beginning of each script. Each script must be edited to replace certain variables prior to its execution. These variables include database names, file locations, user ids and passwords.
•
Each script will create a log file. Oracle database scripts create a file with the same name as the script. SQL Server scripts write a log to the screen. This log may be copied and pasted into Notepad or a similar program. The SQL SERVER script contains instructions on how to send the output to a log rather than the screen.
•
• Make sure to review each log for errors before moving to the next script.
Oracle scripts

The upgrade scripts for Stat 6.2.0 running on Oracle® are located in <target directory>\Scripts\Oracle\Upgrade.

* 
IMPORTANT: To upgrade to Stat 6.2.0, you must be using Stat 5.7.x, 5.8.x, 6.0.x , or 6.1.x.
To upgrade to Stat 6.2.0 running on Oracle:
1
For Stat 5.7.x PeopleSoft users only, locate the script UORA580ps854-855.sql under Upgrade_to_5.8 folder.
a
Find and replace [DATABASENAME] with the name of the database.
b
Find and replace [PWD] with the password of the Oracle user STAT.
c
Find and replace [SPOOLPT] with the directory for the Session Log.
d
Run the script.
2
For Stat 5.7.x only, locate the script UORAv570-580.sql under Upgrade_to_5.8 folder.
a
Find and replace [DATABASENAME] with the name of the database.
b
Find and replace [PWD] with the password of the Oracle user STAT.
c
Find and replace [SPOOLPT] with the directory for the Session Log.
d
Run the script.
3
For Stat 5.7.x and 5.8.x only, locate the script UORAv580-600.sql under Upgrade_to_6.0 folder.
a
Find and replace [DATABASENAME] with the name of the database.
b
Find and replace [PWD] with the password of the Oracle user STAT.
c
Find and replace [SPOOLPT] with the directory for the Session Log.
d
Run the script.
4
For PeopleSoft users only, locate the script UORAps854-856.sql under Upgrade folder.
a
Find and replace [DATABASENAME] with the name of the database.
b
Find and replace [PWD] with the password of the Oracle user STAT.
c
Find and replace [SPOOLPT] with the directory for the Session Log.
d
Run the script.
5
Locate the script UORAv600-620.sql. under Upgrade folder.
a
Find and replace [DATABASENAME] with the name of the database.
b
Find and replace [PWD] with the password of the Oracle user STAT.
c
Find and replace [SPOOLPT] with the directory for the Session Log.
d
Run the script.
6
Recompile any invalid PL/SQL modules in the database by running the script utlrp.sql located in <ORACLE_HOME>/rdbms/admin directory.
SQL Server scripts

The upgrade scripts for Stat 6.2.0 running on SQL Server are located in <target directory>\Scripts\MSSQLServer\Upgrade.

* 
IMPORTANT: To upgrade to Stat 6.2.0, you must be on Stat 5.7.x, 5.8.x, 6.0.x , or 6.1.x.
To upgrade to Stat 6.2.0 running on SQL Server:
1
For Stat 5.7.x PeopleSoft® users only, locate the script UMSS580ps854-855.sql under the Upgrade_to_5.8 folder.
a
Find and replace [DATABASENAME] with the name of the database.
b
Run the script.
2
For Stat 5.7.x users only, locate the script UMSSv570-580.sql.
a
Find and replace [DATABASENAME] with the name of the database.
b
Run the script.
3
For Stat 5.7.x and 5.8.x only, locate the script UMSSv580-600.sql under Upgrade_to_6.0 folder.
a
Find and replace [DATABASENAME] with the name of the database.
b
Run the script.
4
For PeopleSoft users only, locate the script UMSSps854-856.sql under the Upgrade folder.
a
Find and replace [DATABASENAME] with the name of the database.
b
Run the script.
5
Locate the script UMSSv600-620.sql. under Upgrade folder.
a
Find and replace [DATABASENAME] with the name of the database.
b
Run the script.

Upgrade a staging database (PeopleSoft only)

•
If running on Oracle®, execute StageORA856.sql, if not previously run.
•
If running on SQL Server®, execute StageMSS856.sql, if not previously run.
•
If running on DB2® execute StageDB2-ZOS-856.sql (for mainframe), or StageDB2-UNIX-856.sql (for AIX®/UNIX®), if not previously run.

PeopleSoft on Oracle

1
Locate the StageORA856.sql script.
2
Replace the following variables:
•
[OWNER/PWD@DATABASENAME] Replace with the correct values for the PeopleSoft® schema owner/password and staging database.
•
[SPOOLPT] Replace with the directory for the session log.
•
[PTAPP] Replace with the tablespace for the staging table
•
[PSINDEX] Replace with the tablespace for the staging table indexes
3
Run the modified script via Sql*Plus or Toad™ in the PeopleSoft staging database as the PeopleSoft schema owner

PeopleSoft on SQL Server

1
Locate the StageMSS856.sql script.
2
Find and replace the variable [DATABASENAME] with the name of the database.
3
Using Enterprise Manager, go into SQL Server® Analyzer from Tools on the menu bar.
4
Log in as sa or a login that is a member of the sysadmin fixed server role or the database owner.
5
Open the modified scripts.
6
After running each script, copy the output of the script results to a file, and save the file for review.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating