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

The Options Tab

The Options tab displays information contained in the Options and Shared Profile sections of the Stat INI file. The database parameters displayed on this tab must be set at startup and are workstation specific.

In the Options tab, you can share database profile records if you want to use a file that resides on the network. This field displays the full path and name of the file you want to use in either a “drive:\directory\file” format or a UNC format (\\servername\share\directory\file).

The Local failover options indicate what action the Stat INI Editor takes if the shared profile (.ini file) is not found. Options include:

Yes – The application displays an alert message and then uses the local default INI file instead
No – The application halts and displays an alert message

Encryption Key Update

As a general security precaution, you may want to periodically change the encryption key for all the active passwords contained in the Stat database, including Stat user ID passwords, environment and file server passwords, and email server passwords. When the encryption update utility encounters a password for an inactive record that cannot be decrypted, it substitutes a randomly-generated string for the password and issues a warning. When it encounters a password for an active record that cannot be decrypted, it issues an error message and does not complete the update procedure.

2
Select Tools | Update Encryption Key.

Data Replicator

You can use the Data Replicator tool to copy data from one service domain to another, either within the same Stat database or between two Stat databases. This tool allows you to quickly populate new service domains with pre-existing data and to maintain consistency throughout your Stat environment. For example, if you create a new service domain in your Stat production database, you can use the Data Replicator to populate that service domain with data from an existing service domain in your Stat development database.

Access to the Data Replicator should be restricted to system administrators and is controlled by the following user class rights:

Note the following before using Data Replicator to copy either business rules or workflows:

1
Select Tools | Data Replicator.
General Tables – General tables usually affect an application across all service domains. For example, Customers and Departments.
Service Domain Specific – These tables are specific to individual service domains. For example, CSR Status.
Stat Central Agent – These tables allow you to configure and maintain the Stat Central Agent as well as email
Security Settings – These tables are used to manage security settings such as creating new user accounts and user classes
CSRs – These tables contain CSR information, excluding associated objects and archive sets
2
In the Destination field, click Connect.
4
In the Source field and select the service domain whose maintenance tables you want to copy.
6
(Optional) Select the Include Dependencies option if you want to copy the dependency data of each entity you select.
Certain entities include information defined in other entities, and you may want replicate all these tables together as a single unit. For example, the Customers maintenance table includes information defined in the Countries and Departments maintenance tables. The Include Dependencies option configures Stat to select these tables automatically when you select the Customers maintenance table. You can de-select any dependency table that you do not want to replicate.
7
(Optional) Select the Copy only active records option if you only want to replicate only records that are currently active in each entity you select.
To select all the entities, click Select All. To deselect all, click Select None.
9
Click Copy Data.
To view log entries that were generated during processing, select the Copy Log tab. Data Replicator saves the log file. You can change the location of the log file on the Copy Log tab.

Table Dump Utility

The Table Dump Utility is a troubleshooting tool that allows you to dump the contents of a table so that it can be emailed to the Quest Support staff. Support then evaluates the contents of the file in order to find the cause of the problem.

You should use this utility only as instructed by the Quest Support staff. If called for, a Support representative may give you a SQL statement to execute or send you an .sql file that you can upload into the utility. You then execute the statement or file and forward the resulting data (as a .psr file) to Support.

Access to this tool should be restricted to system administrators. It is important to note that the tool bypasses service domain security. This means you could dump data from any service domain, regardless of your security restrictions.

1
Select Tools | Table Dump Utility.
4
Click Execute.
5
Click Export. By default, Stat names the file “tabledmp.psr.”
8
Click Clear.
Related Documents