Chat now with support
Chat with Support

Stat 6.3 - 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.

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:

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

IMPORTANT: To upgrade to Stat 6.3.0, you must be using Stat 5.7.x, 5.8.x, 6.0.x, 6.1.x, or 6.2.x.
1
For Stat 5.7.x only, locate the script UORAv570-580.sql under Upgrade_to_5.8 folder.
2
For Stat 5.7.x and 5.8.x only, locate the script UORAv580-600.sql under Upgrade_to_6.0 folder.
3
Locate the script UORAv600-630.sql. under Upgrade folder.
4
Recompile any invalid PL/SQL modules in the database by running the script utlrp.sql located in <ORACLE_HOME>/rdbms/admin directory.

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

IMPORTANT: To upgrade to Stat 6.3.0, you must be on Stat 5.7.x, 5.8.x, 6.0.x, 6.1.x, or 6.2.x.
2
For Stat 5.7.x and 5.8.x only, locate the script UMSSv580-600.sql under Upgrade_to_6.0 folder.
3
Locate the script UMSSv600-630.sql under Upgrade folder.

Upgrade existing PeopleSoft Archive Sets

Stat 6.3.0 comes with improved archiving and migration technique for PeopleSoft Proprietary objects. Package comes with PsConvert utility that will upgrade existing PeopleSoft Archive Sets into a new format. After successful conversion, it will remove old Stat Shadow tables from Stat repository.

1
Locate PsConvert utility under /utilities/PsConvert in installation package
4
Once you are in the PsConvert directory, then type in psconvert to locate commands for Stat db on Oracle vs. SQL Server.
a
Enter the command below for Stat db on Oracle:
psconvert jdbc:oracle:thin:@//enter_stat_hostname:enter_port_number/enter_db_name STAT ENTER_STATUSER_PASSWORD
For example: psconvert jdbc:oracle:thin:@//ALVSTATPROD:1521/ST630 STAT STAT

Install the Stat Client

Before installing the Stat® Client, please note that the user performing the installation or de-installation needs to be logged in as an Administrator locally on that server/workstation due to enhanced security on Windows®.

The Stat Client can be installed locally or it can be installed to a single network location. For detailed instructions, see the Stat Install Notes document. You can open this document from the Stat Autorun program by clicking View Install Notes.

1
Click on Install Stat Windows Client to launch the InstallShield Wizard for Stat 6.3.0.
2
Complete the steps for installing the Stat Client locally. See the Stat Install Notes document for more information.

Create a new record for the database

Use the Stat® INI Editor to create a new record for the upgraded database. For more detailed instructions, see the Stat System Administration Guide, Chapter 2, Administrative Utilities.

IMPORTANT: System administrators must enter the STATLOGIN password in the Encrypted Login Password field, either by entering an encrypted password from another stat.ini file or by clicking Change Password and entering the STATLOGIN password.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating