Stat 7.0 - System Administration Guide

PeopleSoft Staging Database:

There exists more than one staging script. What values do I need to enter in the script for the tablespaces?

Confer with your DBA as to which tablespaces he or she created in the PeopleSoft AUD environment (staging database)

Receive the following error when archiving large sets of objects:
“Select error: ORA-03232: unable to allocate an extent....”

Have your DBA re-size the temporary segments in the database to a minimum size of 1 MB initially and increase by increments of 1 MB if problem recurs.

Receive the following error when starting the Stat Central Agent on AIX:

“The parameter or environment lists are too long”

The default buffer size on AIX is 6, which may be too low. To change the buffer size to 10, enter the following:

chdev -1 sys0 -a ncargs= 10

If 10 is still too low, try increasing the buffer size in increments of 10 until the problem is resolved.

Receive the following warning even when logging is turned off for the server:

“WARN [TxConnectionManager] Prepare called on a local tx. Use of local transactions on a jta transaction with more than one branch may result in inconsistent data in some cases of failure”.

This warning is generated because JDBC datasource does not support two phase commit and does not support XA. This warning can be ignored.

Receive the following error when saving the Stat configuration page:
“Access denied”

To prevent unauthorized access to the configuration page, the Stat administrator needs to edit the stat-config.properties file in $STAT_HOME/config. For example, you can grant user John the permission by appending his computer's 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.

Could not find agent identifier for environment code.

The environment code name that is entered in the stat.conf file on the Stat OraApps computer has to exactly match (case sensitive) the Environment Cd value under Maintenance | General | Oracle Applications Connect.

Select Maintenance | General | Oracle Applications Connect and double-click the ENV in question or highlight it and click the Servers tab. The name of the server that is entered in Stat needs to be an exact match to the actual hostname of the host computer. To check the hostname, login to the host and type “hostname” at a command prompt. Then compare that hostname with the name that is entered in Stat. They need to be exactly the same.

If hostname does not work then enter the ip address.

Stat Central Agent connection unavailable

ERROR - IOException : No more data to read from socket

This is a port error. Possibilities include:

ERROR - Stat's working directory does not exist on server

FATAL - Fatal: Stat validation of environment failed. Unable to start Stat Oracle Agent