Chat now with support
Chat with Support

Stat 6.0 - Install Notes

Installing Stat
Prepare for installation Unpack the 6.0.0 installer Install the Stat database Create a staging database (PeopleSoft Only) Install the Stat Client Configure the Stat database Update the System Maintenance table Install the Stat Central Agent Install the Stat Oracle Agent (Oracle E- Business Suite only) Configure the SYSTEM user account Update the PS Object Mover Instructions (PeopleSoft Only) Implement Stat

Install the Stat Central Agent

The Stat® Central Agent is a Java®-based application that contains the business logic for Stat and the UI for Stat Web client.

The following instructions apply to both Windows® and Unix® platforms. Be sure to adjust your path and environment settings to suit your platform. After installation, the startup may report errors. These are often caused by port conflicts. To resolve such conflicts, see Resolving Port and Firewall Conflicts.

Before you install the Stat Central Agent, you may want to log in to the Stat Client and perform certain configuration tasks, such as setting up service domains, defining users, and establishing connections between Stat and your native application environments and ftp file servers. It is not necessary that you configure Stat before installing the Stat Central Agent, but if installing on Windows®, this will allow you to test connectivity parameters. For PeopleSoft® users running on any platform except DB2®, this entails specifying the appropriate values in the Host Name, DB Listener Port, and (if running PeopleSoft on Oracle®) Service Name fields in the PeopleSoft Environment Connection Maintenance table. For more information, see Implement Stat and the book, Stat 6.0.0: System Administration, Chapter 4, General Maintenance Tables.

NOTE: If you are running PeopleSoft on a DB2 platform, see Installing DB2 Support for the Stat Central Agent for additional information.

Installing the Stat Central Agent on the standalone platform

Stat® provides a platform on which you can install the Stat Central Agent, referred to as the standalone platform.

You need to have a Java® Development Kit (Java SDK) 7 or 8 installed and a system variable called JAVA_HOME
that points to the JDK installation root directory (e.g., C:\Program Files (x86)\Java\jdk1.7.0_25\bin).

If you are running Windows® or Solaris and Java® is not installed, or if you have an older version of Java installed, go to http://www.oracle.com/technetwork/java/javase/downloads/index.html and download the appropriate version. If running HPUX, go to http://www.hp.com/go/java/.

CAUTION: If running on a 64-bit environment, make sure the JDK installation root directory does not include spaces. The Stat Central Agent cannot run if it does.
2
Click Install Stat Central Agent.
Autorun opens the stat_server folder, which contains the subfolder, standalone.
3
Open the standalone folder, locate the file stat_standalone.zip, and unzip 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 the unzip utility on Unix.
NOTE: Do not unzip the file stat_standalone.zip file to a directory that contains an exclamation point character (!). For Unix, use the -a modifier to unzip the file.
NOTE: Do not add a backslash character (\) to the end of the STAT_HOME variable.
To run the Stat Central Agent as a Windows Service instead, see Configuring the Stat Central Agent as a Windows Service. We recommend that you first configure and test the agent before creating the service.
These issues are documented in Configuring the Stat Central Agent on the Standalone Platform. Note that while you can address some configuration issues after you have completed installing the Stat Central Agent, you should address others before you proceed to the next step in the installation. These particular issues are documented in the subsection Before Starting the Stat Central Agent.
6
Use run.bat or run.sh to start the Stat Central Agent NOT as a service.
Windows: <STAT_HOME>\app\bin\run.bat
Unix: <STAT_HOME>/app/bin/run.sh
NOTE: If you have port conflicts during startup, the server will display one or more error messages. For instructions on resolving port conflicts, see Resolving Port and Firewall Conflicts.
In the server console, you will see the line, Stat Configuration Assistant is ready.
8
Open your internet browser and go to http://<stat_server_host_machine>:8080/stat-config.

CAUTION: If you are not running the agent from the local computer (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.
9
In the Type/Vendor field, select the database platform you are using. Options include Oracle or SQL Server.
10
Enter appropriate information for the Stat database: Host Name, Port, DB/Service Name, Login ID, and Password.
11
For SQL Server users who have installed multiple instances of SQL Server, specify which instance the Stat Central Agent is running on in the Properties field. Also for users who have ssl enabled for SQL Server, include ssl=require in the Properties field. If you have more than one property, you can use semicolons between different properties. For example, if you are using an instance and also have ssl enbled, you can specify ssl=require;instance=database_instance_name; in the Properties field.
This field flexes to TNS Entry for Oracle users.
14
Click Save.

Configuring the Stat Central Agent on the Standalone Platform

Refer to the following sections for information on the number of ways you can configure the Stat Central Agent on the standalone platform:

NOTE: Before making any configuration changes, be aware of the following:
<STAT_HOME>/app/bin/service/service.bat is used to start the service. It calls run.bat. See section Configuring the Stat Central Agent as a Windows Service for more information. It is recommended that you validate that the agent will start without the service before invoking the service operation.

Before starting the Stat Central Agent

The following are configuration issues you may need to address while installing the Stat® Central Agent but before starting it for the first time. After reviewing and addressing these issues, you can resume the installation as documented in the section Install the Stat Oracle Agent (Oracle E-Business Suite only).

If you have custom report definitions to carry over to 6.0.0, copy the <STAT_HOME>\report\custom\format folder from its 5.8.x location, and paste it to the new 6.0.0 <STAT_HOME> directory. Then remove any files with a .jasper extension for the Custom folder.

To authorize access to the configuration page, you as a Stat administrator need to edit the stat- config.properties file in <STAT_HOME>/config. The privilege to modify the configuration is administered using the IP address of the computer. You can grant user permission to change the configuration by adding the computer IP address to the list of the property auth.user.ip (IPV4 and IPV6 formats are supported). For example, you can grant user John the permission by appending his computer IP address (e.g. 192.168.244.130) to the list. You can add multiple IPs to the list and use a comma to separate them. After you complete editing the stat-config.properties file, change its permission so no other users can view or edit it.

Generic applications and Oracle E-Business Suite users may see a table or view does not exist error message in the Stat Central Agent log file after migrating a database object. This error is due to a query against a test table that is normally present in PeopleSoft® installations, and while it does not affect the migration, to avoid receiving this message, open the stat.properties file in <STAT_HOME>/config and locate the following variable, TestTableName=PSOBJGROUP. Set this variable to the name of a table in the database you are working in, for example, TestTableName=DUAL.

The default timeout setting for connections between the Stat Central Agent and your environments is 15 minutes. If you want to increase or decrease the time amount, open the stat.properties file, locate the variable CONNECTION_IDLE_TIME=15, and change the setting to the number of minutes you want. For more information, see Connection Pool Idle Time.

If you have installed the Stat Central Agent on a HPUX computer, you may need to adjust the default max_thread_proc setting to allow for Java® processing. For more information, go to: http://www.hp.com/go/java/ or search the HP online documentation for max_thread_proc.

If you have installed the Stat Central Agent on Unix®, you may experience problems displaying graphical objects (such as workflow diagrams, reports and email) in the Stat Web Client. These errors are generated because the graphics libraries installed with the Stat Central Agent on Unix are implemented using XWindows/Motif graphics libraries, which require access to an X server. To resolve this issue, you need to download and install the X Virtual Frame Buffer (Xvfb), a free virtual server that provides the same graphical resources as a X11 Windows Server®. Installing the Xvfb is platform-specific. For more information, please contact the Support Portal at http://quest.com/support/.

If the Stat Central Agent was started on Unix with telnet, closing the telnet session may cause the Stat Central Agent to shut down. To keep the Stat Central Agent running after closing Telnet, go to <STAT_HOME>/app/bin and execute nohup run.sh & to run the process in the background.

Related Documents