Chat now with support
Chat with Support

Stat 6.0 - System Administration Guide

Overview of Stat Administration Administrative Utilities Stat Security General Maintenance Tables
System Maintenance Service Domain Maintenance Department Maintenance Country Maintenance Customer Maintenance Object Type Maintenance PeopleSoft Environment Connection Maintenance Pre/Post Migration Steps Parameters Oracle Applications Configuration Oracle Applications Connection Maintenance Generic Application Connection Maintenance Schema Object Parameters Maintenance Data Object Maintenance PeopleSoft Search Configurations Stat Report Definition Maintenance Version Control Management Connection Maintenance
Service Domain-Specific Maintenance Configuring the Stat Central Agent Email Configuration Object Security Appendix: Sample Service Domain Configuration Appendix: User Class Rights Appendix: Creating a Staging Database Appendix: Database Tuning Appendix: Oracle Applications File Type Directory Appendix: Ports and Firewalls Appendix: Stat Web Services Appendix: Troubleshooting Chart Appendix: stat.conf Configuration Appendix: Custom Report Files

CSRWorkflowStatusQueueMemberType Bean

Appendix: Troubleshooting Chart

Appendix H provides detailed explanations of some error messages you may receive while using Stat, along with possible solutions. The information is categorized according to the application component or function that the errors concern. For problems not listed in this section, please contact Quest Technical Support.

Stat Database


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.

Stat Central Agent


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 file in $STAT_HOME/config. For example, you can grant user John the permission by appending his computer's IP address (e.g. to the list. You can add multiple IPs to the list and use a comma to separate them.

Related Documents