Stat 6.2 - Upgrade Notes

Before starting the Stat Central Agent Resolving port and firewall conflicts Stopping the Stat Central Agent Configuring the Stat Central Agent as a Windows service Installing DB2 support for the Stat Central Agent Configuring the Stat Central Agent character map Setting up support for AES256 ciphers for SFTP Configuring the Web Client to use HTTPS Modifying connection pool idle time Installing multiple servers on the same host

Testing database and server connections

Upgrade the Stat Oracle Agent (Oracle E- Business Suite only) Additional Changes

Assign user class rights

Appendix: Upgrade Checklist

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.

Update PeopleSoft Object Mover instructions

For PeopleSoft® users, log into Stat® 6.2.0 using the special Stat SYSTEM account to update the PeopleSoft Object Mover instructions. The Stat object that archives PeopleSoft objects requires a set of instructions in order to operate. To do this, select Maintenance | General | Update PS Object Mover Instructions. For more information, see the Stat System Administration Guide, Chapter 2, Administrative Utilities.

Upgrade the Stat Central Agent

Topics:

•

Upgrading the Stat Central Agent

•

Configuring the Stat Central Agent

•

Testing database and server connections

Upgrading the Stat Central Agent

The upgrade to Stat® 6.2.0 completely replaces the existing directory tree installed at the location defined by <STAT_HOME>.

IMPORTANT: Do not copy files from earlier installations to the new 6.2.0 installation.

For Stat 6.2.0, you need to have Java Development Kit (aka Java SDK) 8 installed, and optionally a system variable called JAVA_HOME that points to the JDK installation root directory (e.g., C:\Program Files (x86)\Java\jdk1.8.0_191).

If you are running Windows® or Solaris and have an older version of Java installed, go to http://www.oracle.com/technetwork/java/javase/downloads/index.html and upgrade to the appropriate version. The previous service wrapper has been replaced with a delivered server.bat. You will need to re-apply custom modifications.

IMPORTANT: There should be no Stat Central Agent running against your previous test database during the upgrade process.

To upgrade the Stat Central Agent:

Create a new <STAT_HOME> folder for the Stat 6.2.0 agent and optionally create an environment variable for <STAT_HOME>.

Instead of creating a system variable for <JAVA_HOME> and <STAT_HOME>, enter these values directly in <STAT_HOME>/app/bin/standalone.conf (for Unix) or <STAT_HOME>\app\bin\standalone.conf.bat (for Windows).

•

For Windows, uncomment and change these 2 lines in <STAT_HOME>\app\bin\standalone.conf.bat.

rem set "JAVA_HOME=C:\opt\jdk"

REM set STAT_HOME=<>

•

For Unix, uncomment and change these 2 lines in <STAT_HOME>\app\bin\standalone.conf.

#JAVA_HOME="/opt/java/jdk"

# export STAT_HOME=<>

Backup your previous <STAT_HOME> if you are planning on using the same name.

NOTE: The new folder must be empty.

For example, if you installed the Stat Central Agent in C:\Stat, move that directory to C:\stat_old, and create a new directory for C:\Stat (<STAT_HOME> will still point to the correct location).

We suggest making a backup of C:\Stat rather than deleting it so it is possible to refer to old log files or your original configuration files. For example:

•

Windows:

c:\> move c:\stat c:\stat_old

c:\> mkdir c:\stat

•

Unix: (assuming <STAT_HOME> points to /usr/local/stat and suitable file system permissions):

#> cd /usr/local

#> mv stat stat_old

#> mkdir stat

Open the Autorun program, either from the Stat cd or from the upgrade folder downloaded from Supportlink.

Click Install Stat Central Agent.

Autorun opens the stat_server folder, which contains the subfolder, standalone.

Open the standalone folder, locate the file stat_standalone.zip and unzip it to the desired location on the host computer where you want to install the Stat Central Agent.

An example for Windows might be c:\stat; on Unix®, this might be /usr/local. The location you choose for the installation is referred to as <STAT_HOME>. Use Winzip® to unpack the file on Windows or use the unzip utility on Unix.

IMPORTANT: Do not unzip the file stat_standalone.zip to a directory that contains an exclamation point character (!).

If copying the installation files to a Unix system, be sure the file transfer settings are set to binary and not ascii. Use the -a modifier to unzip the file.

The <STAT_HOME> directory should contain the following subdirectories:

•

•

•

•

•

•

Configure the Stat Central Agent as required by your environment.

Because this is a new installation, you need to re-apply any configuration changes you want to retain from your previous release of Stat. See Configuring the Stat Central Agent for more information.

Note that while some configuration changes can be made after you have completed installing the Stat Central Agent, other changes should be made before proceeding to the next step in the installation. See Before starting the Stat Central Agent.

NOTE: Service.bat is used to start the service by calling run.bat. See Configuring the Stat Central Agent as a Windows service for more information. Quest® Software recommends that you validate that the agent will start without the service before invoking the service operation.

Use run.bat or run.sh to start the Stat Central Agent not as a service.

If you have configured the Stat Central Agent to run as a Windows service, use the Windows Service interface to start the agent. Otherwise, this is the typical command to start the server:

•

Windows: <STAT_HOME>\app\bin\run.bat

•

Unix: <STAT_HOME>/app/bin/run.sh

NOTE: If you have port conflicts during startup, the server displays one or more error messages. For instructions on resolving port conflicts, see Resolving Port and Firewall Conflicts.

NOTE: If you receive a Connection Refused error when your Stat Windows Client is trying to access the Stat Central Agent, you may need to start your Stat Central Agent with a -b parameter to specify the hostname of the agent. In this case, edit your run.bat (run.sh for Unix) and add -b=<hostname>, where <hostname> is the hostname for the machine running the Stat Central Agent.

For example, in run.bat:

standalone.bat --server-config=standalone-full.xml -b=ALVWindows

For example, in run.sh:

./standalone.sh --server-config=standalone-full.xml -b=ALVLinux

Wait for the Stat Central Agent startup process to complete.

In the server console, you will see the line, Stat Configuration Assistant is ready.

Open your internet browser and go to http://<stat_server_host_machine>:8080/stat-config.

This opens the Configuration Assistant which guides you through the process of configuring the Stat database and the database type-mapping.

IMPORTANT: If you are not running the agent from the local machine (i.e. Telnet session), you must add the IP address to <STAT_HOME>/config/stat-config.properties or you will not have access to the Configuration Assistant. See Authorize Access to the Configuration Page.

In the Type/Vendor field, select the database platform you are using. Options include Oracle or SQL Server.

Enter the appropriate information for the Stat database: Host Name, Port, DB/Service Name, Login ID, Password.

For SQL Server users who have installed multiple instances of SQL Server, specify which instance the Stat Central Agent is running on in the Instance field.

This field flexes to TNS Entry for Oracle users.

For RAC environments, paste the TNS entry for the Stat database in this field. Remove any spaces and any line feeds or carriage returns from the TNS string so that it is one long line.

Choose the logging setting for the UI Logging Level and for the Stat Central Agent application. The default is INFO.

Optionally, specify a session timeout parameter.

The default value is 20 minutes. You can specify any value from 1 minute to 2880 minutes, but be aware that setting higher values may negatively affect performance.

Click Save.

Stat verifies that the Stat database parameters you entered are correct.