Chat now with support
Chat with Support

Please note, you may experience access issues between 6am - 7am Eastern time on Saturday, May 28 2022 due to planned maintenance

Stat 6.1 - Upgrade Notes

Configuring the Web Client to use HTTPS

This functionality is supported for the standalone platform only. It is recommended that you first configure the Stat™ Central Agent without https and validate that it can be started and is functional before switching to https.

2
Delete <STAT_HOME>/app/standalone/tmp.
4
Once you have the keystore, move it to <STAT_HOME>/app/standalone.
a
Go to <STAT_HOME>/app/ standalone/ standalone-full.xml and turn on SSL.
c
g
Uncomment the block by moving the trailing --> to the end of this line:
At this point users can log in as http://servername:8080/stat or as https://servername:8443.
b
Move <STAT_HOME>/app/standalone/deployments/stat-agent.ear to a location outside of the <STAT_HOME> folder for backup purposes.
c
Locate the stat-agent.ear file in stat-agent-https.zip from this distribution package and copy it into <STAT_HOME>/app/standalone/deployments.

Modifying connection pool idle time

This feature allows the site to define the length of time before the Stat™ Central Agent connection pool times out database connections. The default is 15 minutes. However, Java® could take up to twice as long to actually disconnect from the environment.

IMPORTANT: Shorter times could adversely affect agent performance.
1
Open <STAT_HOME>/config/stat.properties.
2
Locate the parameter CONNECTION_IDLE_TIME=15, and modify the time.

Installing multiple servers on the same host

Stat™ currently supports installing up to four Stat Central Agents on the same host machine (provided there are no port conflicts). Additional Stat Central Agents are installed basically the same way as the first server, except you will need to install the additional servers to separate directories, define separate system variables, modify the startup files, and assign the servers to different port profiles.

If you need to install more than four servers on the same computer, contact Technical Support.

NOTE: You can install only one Stat Central Agent per Stat Repository.
1
Unzip the contents of stat_standalone.zip to a location on the host computer that is different from the location where the first Stat Central Agent is installed. This location will be referred to as <STAT_HOME2>.
2
Create an environment system variable called STAT_HOME2 with a value of <STAT_HOME2> from the above step.
For Windows, go to <STAT_HOME2>\app\bin, open the file standalone.conf.bat in a text editor, and locate the line:
Change the value "%STAT_HOME%" to "%STAT_HOME2%".
Change the value for –Djboss.socket.binding.port-offset from zero to a proper value.
For Unix, go to <STAT_HOME2>/app/bin, open the file standalone.conf in a text editor, and locate the line:
Change the value $STAT_HOME to $STAT_HOME2.
Change the value for –Djboss.socket.binding.port-offset from zero to a proper value.
The value for port-offset assigns a new offset of ports to the second Stat Central Agent. See Resolving port and firewall conflicts for information on choosing the proper value for port-offset and resolving port conflicts.

Upgrading the Stat Central Agent on Oracle WebLogic 11g/12c

As an alternative to the recommended Stat® standalone platform, the Stat Central Agent can be installed on Weblogic 11g or Weblogic 12c (v12.1.x-v12.2.x).

2
Create a directory for named Stat in <WL_HOME>/user_projects/domains/.
NOTE: If you have port conflicts, see Resolving port conflicts (WebLogic).
3
Create a variable named <STAT_HOME> and set it to <WL_HOME>/user_projects/domains/stat.
4
Create a variable named <STAT_HOME2> and set it to <WL_HOME>/user_projects/domains/stat2.
5
On the installation media, go to the \stat_server\weblogic folder and unzip the file stat_weblogic.zip to <WL_HOME>/user_projects/domains/stat.
NOTE: For Unix®, use the -a modifier to unzip the file.
Next, you need to edit the startup script, startWebLogic.cmd located in <STAT_HOME>, so that it references the correct wlserver folder name and (optionally) a different JDK version.
You will need to modify <WL_HOME>/user_projects/domains/stat/startweblogic.cmd (or startweblogic.sh for Unix) to point <STAT_HOME> to this new location or to the variable described in step 4.
6
Edit startWebLogic.cmd as follows:
a
Locate the wlserver_10x or wlserver_12x folder under <WL_HOME>, and edit the line
set WL_HOME=%STAT_HOME%\..\..\..\wlserver_10 so that it specifies the exact folder name (e.g., wlserver_10.3).
NOTE: WebLogic names its wlserver folder based on the minor release installed.
b
(Optional) If you want to use a different 1.7.x JDK version, replace the line JAVA_HOME=..\..\..\jdk160_45 with the path for the new version (e.g., JAVA_HOME=C:\j2sdk170_25).
7
If you are using WebLogic 12.2.x and on Windows, edit the following lines in <WL_HOME>/user_projects/domains/stat/bin/setDomainEnv.cmd:
@REM call "%WL_HOME%\..\oracle_common\common\bin\commEnv.cmd"
@REM call "%WL_HOME%\common\bin\commEnv.cmd"
8
If you are using WebLogic 12.2.x and on Unix, edit the following lines in <WL_HOME>/user_projects/domains/stat/bin/setDomainEnv.sh:
# . ${WL_HOME}/../oracle_common/common/bin/commEnv.sh
# . ${WL_HOME}/common/bin/commEnv.sh
9
Copy the files wlclient.jar, wljmsclient.jar, and wlthint3client.jar to each workstation where the Stat Windows Client is installed.
These files are located in <WL_HOME>/wlserver_10.x/server/lib.
NOTE: For Oracle applications only, wlclient.jar and wljmsclient.jar must also be copied to each Stat Oracle Agent. See Upgrade the Stat Oracle Agent (Oracle E- Business Suite only).
If on Windows, run script startWebLogic.cmd.
c
Click Services and then Data Sources on the Domain Structure tree on the left side of the screen.
d
Click StatDataSource on the Configuration tab.
e
Click the Connection Pool tab.
f
Click Lock & Edit on the upper left portion of the screen.
h
Click Save on the Connection Pool tab.
NOTE: If you do not receive a green check mark with the message Settings Updated Successfully, edit your savings and try again.
i
Click Activate Changes under Lock & Edit.
You should receive a green check mark with the message All Changes have been activated. No restarts are necessary.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating