Configuration settings can be reviewed or modified using the Properties tab in the TPGS Administrator. Mark the Show Advanced Properties checkbox to display all properties. These settings are stored in the Registry in the
HKEY\System\CurrentControlSet\Services\TPGS\Configuration key on the computer running the Group Server.
Only experienced administrators should use the Registry to modify configuration settings.
In the tables below, the Value column lists the recommended settings given heavy load conditions (1000 users or more).
[General key values]
Value Name Value Description
Allow Negative Actuals Yes/No Allow negative actuals when calculated. No - Disallow. Yes - Allow.
Cycle Seed Yes/No Controls whether or not to cycle the seed used for password encryption. A seed is a unique, random numeric value, used to make each encrypted password unique. Set to No when load testing, where login requests need constant encrypted password values.
Edit Subordinate Resources’ Timesheets
Yes/No Allow supervisor to modify subordinate resources’ timesheets.
Edit Work Product and Document Details
Yes/No Allow editing of public document path in the Work Product and Document Details dialog box in the timesheet client.
Enable Performance Counters
Sets Performance Monitor counters based on TPGS server activity.
Use the Windows Performance Monitor utility to view TPGS performance counters.
Enable Primary Resource to Edit Step’s UDF Values Counters
Yes/No If Y, overrides OBS access to edit step’s UDF values. Gives edit rights to primary resources.
If N, steps can be edited if user has OBS access to the project. The default value is N.
Greeting Sets the message that appears in the client when first connected to the TPGS server.
LDAP Connect Timeout 15 The maximum amount of time Group Server will allow for a connection attempt to an LDAP data store to succeed. This is only used if the Group Server is configured for LDAP authentication.
Log Transactions Records transactions for tracing to the event log Maximum Auto-Fetch Size
(bytes)
2048 Maximum size of blobs (notes/memos) in bytes that will be sent automatically in low bandwidth mode.
Maximum Request Size Largest client TCPIP request that will be accepted by TPGS server.
Port 9002 Sets the TCP/IP port number used by the Group Server to
commu-nicate with the Java client. This port must be opened to the Internet, or you can change this setting to specify another port that is open to the Internet. The default value is 9002.
Startup Wait Period (seconds)
0 Amount of time the TPGS service delays before starting. Use this setting if dependent services (such as a database server service) need time to start first.
User Inactivity TimeOut Period
600 Amount of time in seconds a connection can remain idle before being logged off. The default value is 600.
[General key values]
Value Name Value Description
[Database key values]
Value Name Value Description
ADO Connection TimeOut (seconds)
15 Amount of time to wait while establishing a connection before terminating the attempt and generating an error message.
ADO Command TimeOut (seconds)
30 Amount of time to wait while executing a command before termi-nating the attempt and generating an error message.
ADO RecordSet Cache Size 5 The number of records stored in memory at any given time.
ADO Stalled Check Period (seconds)
30 Frequency with which the connection is checked for stalled opera-tions.
Apply Session Setting Yes/No Determines whether to execute the SQL command specified in the Session Setting property. The default value is No.
Auto Translate Yes/No The Auto translate property of the SQL Server ODBC Driver for a SQL Server Unicode database.
Base Connections 25 (default=10) Default number of database connections that the TPGS server makes on startup.
Cache Refresh Interval (seconds)
60 Frequency of the TPGS server for refreshing cached data from the database.
Connect Retry Period (milliseconds)
30000 Amount of time to wait before retrying to connect.
Connection String ADO connection string used to connect to the database.
For example, for Oracle, use the connection string
“provider=OraOLEDB.Oracle; Data Source = pmdb.world”.
For example, for SQL Server or SQL Server Express, use the connection string “provider=SQLOLEDB; Data
Source=PMDBSRV\ENGLISH;Initial Catalog=TPPM60”, where
“PMDBSRV” is the database machine name.
Database Type Type of database ("Oracle” or “Microsoft SQL Server/SQL Express”) that the TPGS server uses for data.
DB Connectivity Check Yes/No Determines if database connectivity is tested periodically. and if connections are closed and restored upon database shutdown, restart.
DB User PRIVUSER User name with privileged access used to connect to the database.
The default value is PRIVUSER.
License Inactivity TimeOut (seconds)
900 Period that inactive licensed client connections are considered to be bad.
Log Invalid Login Attempts Yes/No Logs invalid login attempts to the event log. The default value is No.
Log SQL 0 Sets SQL tracing flags for tracing to the event log.
Max Search Result Records 100 Maximum number of records in search results.
Password Encrypted password of DB user account used to connect to the database.
Session Setting SQL command to be executed against every database connection created by Group Server.
Sync Period (seconds)
60 Period between updating the sync table in the database.
[Database key values]
Value Name Value Description
Synchronize ADO Connection Creation
Yes/No Blocks other requests while connecting to a database. The default value is Yes.
Temporary Connections 150 Number of database connections that the TPGS server can make as demand warrants. These settings determine how many connections the Group Server has to the database. If you are getting an error where HRESULT = 8004b002, this indicates the Group Server cannot handle the load and needs more database connections to process all requests. A value of 400 is recommended if more than 1000 timesheet users are accessing the Group Server, which will allow more connections so that TPGS can handle a larger load.
Consideration is also given to the Oracle Server machine.
Verbose Logging Yes/No Determines if verbose logging is enabled when sending error messages to the event log.
[Threading key values]
Value Name Value Description
Caching Threads 1 Number of threads that will handle cached transaction processing.
This is the minimum number of caching threads. Cache threads in the Group Server are
responsible for processing data where the data can be cached. The Group Server will create up to “Maximum Temporary threads per CPU” caching threads as needed.
Coalescing Jobs Busy Threshold
50 Number of coalesced jobs that determine when the coalescing processor is considered busy.
Coalescing Threads 1 Number of threads that will handle coalesced transaction processing. This is the minimum number of coalescing threads.
Coalescing threads in the Group Server are responsible for processing jobs which can be coalesced. Coalescing is the act of taking like requests (e.g., open, update timesheet) and coalescing them into a single SQL request to satisfy several clients concur-rently with one DB hit, thus greatly improving performance. The Group Server will create up to “Maximum Temporary threads per CPU” coalescing threads as needed.
Coalescing Timeout (milliseconds)
750 Frequency that coalesced requests are fulfilled.
Connection Check Period (seconds)
60 Frequency at which database connections are checked.
Connection TimeOut Period 300 Period of inactivity for which attached database [Database key values]
Value Name Value Description
License Manager Interval (seconds)
120 Frequency that the license manager is checked for concurrent users.
Message Threads Per CPU 3 (default=1) Number of threads that will handle socket connections from the client.
This is the minimum number of threads which accept messages from the client via a socket connection and create jobs to be processed in the Group Server. The Group Server will create up to
“Maximum Temporary threads per CPU” message threads as needed.
Maximum Coalescing Size 20 Maximum number of coalesced transactions that can be queued before they are processed.
Maximum Temporary Threads Per CPU (SMP)
15 Maximum number of threads that can be started by each processor.
MaxTempThreads=CPU>1?MaxTempThreads+(MaxTempThreads
*4/CPU Thread Inactivity TimeOut
Period (seconds)
180 Period of inactivity before a temporary thread is shut down.
Transaction Threads 1 Number of threads that will handle transaction processing. This is the minimum number of threads which create transactions in the Group Server.
Transactions created are either Caching, Coalescing, or Update.
The Group Server will create up to “Maximum Temporary threads per CPU” transaction threads as needed.
Update Threads 1 Number of threads that will handle update transaction processing.
This is the minimum number of Update threads. Update threads in the Group Server are
responsible for updating data. The Group Server will create up to
“Maximum Temporary threads per CPU” update threads as needed.
Watch Dog Period (seconds)
120 Frequency that the TPGS server checks for connection problems.
[Threading key values]
Value Name Value Description
[Security keys]
Keys Value Description
Accept Filters Filter #1, *.*.*.* TCP/IP client addresses that will be accepted.
Reject Filters Filter #1, *.*.*.255 TCP/IP client addresses that will be rejected.
[Install key values]
Value Name Value Description
HTML Path c:\inetpub\wwwroot\GroupServer Path to the HTML files.