System administration

Q5.01

A PPM user has forgotten the password. How do I change the password for an external PPM user?

 

Use the SYSTEM administration access to assign the user a new password in user management. In the Administrator Password input box, enter the password for the SYSTEM user.

 

 

Q5.02

How do I block particular users from the system?

 

Withdraw all of the user's function privileges (at least login, data calculation and data import) or change the user's password to a value that the user does not know.

 

 

Q5.03

How do I determine which users are currently logged on to the system?

 

In a command prompt for the relevant client, run the runppmadmin command with the -showusers option.
Example:

C:\>pushd SoftwareAG\ppmmmashzone\server\bin\agentLocalRepo\.unpacked\ppm-client-run-prod-95.1.0-RC8-trunk-20130404.122823-4-runnable.zip\ppm\bin

D:\SoftwareAG\ppmmmashzone\server\bin\agentLocalRepo\.unpacked\ppm-client-run-prod-95.1.0-RC8-trunk-20130404.122823-4-runnable.zip\ppm>runppmadmin -user system -password manager -showusers

The program displays a table showing you the sessions of all users currently logged into the PPM system on the default client.

 

 

Q5.04

Why does system initialization fail using runinitdb?
Log output includes:

E: 21.10.08 14:50:22: [STD] Error opening XML file "customsysmonxmlsysmon_locales.xml".

customsysmonxmlsysmon_locales.xml (The system cannot find the specified file) [java.io.FileNotFoundException]

 

The directory path <PPM installation directory>...\custom\sysmon\xml\sysmon_locales.xml in the configuration file Initdb_settings.properties is probably specified in MS DOS format. The Java Runtime Environment interprets the standard MS DOS \ (backslash) character as an Escape character. Replace the character with a double backslash or a single forward slash /.

 

 

Q5.05

What emergency user exists in the PPM system?

 

The PPM user SYSTEM is provided as an emergency user. It is always available – neither this user nor this user's unrestricted system privileges can be deleted.

 

 

Q5.06

What authentications are performed when a PPM user runs a PPM command line program (e.g., runppmconfig)?  

 

If a PPM user runs a PPM command line program, the system verifies that this user has the appropriate privileges to perform the requested action(s). The authorization concept of the PPM system is based on the following components:

  • Function privileges
  • Data access privileges
  • Process access privileges
  • Data visibility privilege (via user group association)

Example (missing function privilege): The user PARKER wants to export the user management for the PPM system in which he is registered to an XML file using the command line. The call for the example client umg_en looks like this:

C:\SoftwareAG\ppmmmashzone\server\bin\agentLocalRepo\.unpacked\ppm-client-run-prod-<version>-runnable.zip\ppm\bin>runppmconfig -user vogel -password vogel -mode export -users user.xml -client umg_en

As the user PARKER does not have the Configuration import function privilege, the following message appears in the command line:

I: 23.10.08 10:15:35: [IMP] Exporting configuration of component "users"...

E: 23.10.08 10:15:35: [IMP] You need the "Configuration import" function privilege.

S: 23.10.08 10:15:35: [IMP] Messages of component "IMP":

S: 23.10.08 10:15:35: [IMP] 1 error

No data exported. User PARKER must first obtain the required function privilege from the PPM system administrator.

 

 

Q5.07

When running PPM command line programs, does the log indicate restricted data access privileges of a PPM user (e. g., runppmcompress)?  

 

When running the command line aggregation, as well as function and process access privileges, the data access privileges of the relevant PPM user are also checked. Only those process instances for which the user has visibility privileges (data access privilege) will be aggregated. Data access privileges are defined for user groups in PPM user management. They are then applicable for all users assigned to that group.

Example: The user PARKER wants to aggregate all process instances of the Standard order process type for the period March 2008 using the command line. The call looks like this:

C:\SoftwareAG\ppmmmashzone\server\bin\agentLocalRepo\.unpacked\ppm-client-run-prod-<version>-runnable.zip\ppm\bin>runppmcompress -user vogel -password vogel -client umg_en -mode execute -ps ps.xml

Of the 68 process instances contained in the aggregation paramset (ps.xml), the user PARKER only has data access privileges for the 20 process instances with the value 3000 (Frankfurt) for the data access dimension Sales organization. Therefore, the user PARKER can only aggregate these 20 process instances. The following messages are displayed in the command line:

[...]

S: 23.10.08 11:05:48: [IMP] The following process sets will be aggregated:

S: 23.10.08 11:05:48: [IMP] 20 processes Order processing - Standard order; Sales organization=3000(Frankfurt).

I: 23.10.08 11:05:48: [IMP] The program was terminated without aggregating the processes.

I: 23.10.08 11:05:48: [SRV] Establishing connection between user PPMDB and jdbc:oracle:thin:@ppmdbsrv1:1521:PPM...

I: 23.10.08 11:05:48: [SRV] Database version used: Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production

With the Partitioning, OLAP and Oracle Data Mining options

JServer Release 9.2.0.8.0 - Production.

I: 23.10.08 11:05:48: [SRV] JDBC driver used: Oracle JDBC driver (9.2.0.8.0).

 

 

Q5.08

What happens if a PPM user with no user group association and thus no data access privileges wants to carry out editing actions using the command line?

 

PPM users can only be assigned data access privileges through their association with a group. If a user with no user group association and thus no data access privileges runs a command line program, a message indicates that the user does not have any data access privileges.

Example:

C:\SoftwareAG\ppmmmashzone\server\bin\agentLocalRepo\.unpacked\ppm-client-run-prod-95.1.0-RC8-trunk-20130404.122823-4-runnable.zip\ppm>runppmcompress -user vogel -password vogel -client umg_en -mode test -ps ps.xml

[...]

I: 23.10.08 11:36:22: [IMP] No data delivered by the query.

[...]

 

 

Q5.09

Why does a PPM user not see any data in the PPM user interface despite appropriate process access and function privileges?

 

As a PPM administrator, check whether the user is assigned to a user group and whether this group has data access privileges (all or restricted data access privileges).

 

 

Q5.10

How can restricted process access privileges affect actions carried out using the command line?

 

If a PPM user only has access privileges for particular process type groups / process types, as is the case for the user PARKER in the following example for only the Order processing\Cash sale process type, it is possible that no data will be available for certain actions:

C:\SoftwareAG\ppmmmashzone\server\bin\agentLocalRepo\.unpacked\ppm-client-run-prod-<version>-runnable.zip\ppm\bin>runppmcompress -user vogel -password vogel -client umg_en -ps ps.xml -mode execute

I: 23.10.08 13:25:30: [IMP] Aggregating in "execute" mode...

I: 23.10.08 13:25:30: [SRV] Establishing connection between user PPMDB and jdbc:oracle:thin:@ppmdbsrv1:1521:PPM...

I: 23.10.08 13:25:30: [SRV] Database version used: Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production

With the Partitioning, OLAP and Oracle Data Mining options

JServer Release 9.2.0.8.0 - Production.

I: 23.10.08 13:25:30: [SRV] JDBC driver used: Oracle JDBC driver (9.2.0.8.0).

I: 23.10.08 13:25:31: [IMP] The component(s) "EPC: Keyindicator, KeyindicatorCalculation, KeyindicatorCoreConfig, UserAdmin" has/have been locked by user PARKER

I: 23.10.08 13:25:32: [SRV] The caches have been cleared.

E: 23.10.08 13:25:32: [IMP] Unknown process type: Order processing - Standard order.

I: 23.10.08 13:25:32: [IMP] The component(s) "EPC: Keyindicator, KeyindicatorCalculation, KeyindicatorCoreConfig, UserAdmin" have/has been unlocked by user PARKER.

The PPM user PARKER can only aggregate the process instances of the Standard order process type contained in the paramset (ps.xml) if he has been granted access privileges for this process type by the administrator.

 

 

Q5.11

When importing data, I encounter OutOfMemory messages. What can I do?

 

Allocate more memory to the respective program. You can change the memory data in PPM Customizing Toolkit via Edit client (calling the client installation) on the Server settings page under JVM parameters of server programs > Configure JVM parameters.

Adapt the maximum system memory for

runxmlimport

, e.g., 1024 MB for a maximum of 1 GB system memory.

Subsequently, you must restart the system service of the PPM server (if set up) or the PPM server.    

 

 

Q5.12

How do I increase the system memory for the PPM server?

 

You can easily change the memory data in PPM Customizing Toolkit via Edit client (calling the client installation) on the Server settings page under Client server settings.

Subsequently, you must restart the system service of the PPM server (if set up) or the PPM server.    

 

 

Q5,121

How do I adjust system memory for the analysis server?

 

You can easily edit the data for minimum or maximum memory requirements in PPM Customizing Toolkit via Edit client (calling the client installation) on the Server settings page under Analysis server settings.

You must restart the analysis server afterwards.

 

 

Q5.13

Which periodical tasks exist for a PPM system?

 

The regular maintenance tasks of a PPM system are project-specific and coordinated with the customer. We recommend that you regularly perform the following actions:

  • Back up the client's database schema
  • Back up the client configuration (web, config, and custom directories under <installation directory>\ppmmashzone\server\bin\work\data_ppm)
  • Archive the imported source system data
  • Archive the log files of the analysis server and PPM server and command line programs

For further information, please refer to the documentations PPM Database Systems and PPM Data Import.