Q2.01 |
What settings are important for the DB schema used? |
|
The data for a PPM client is saved in a separate DB schema of the database type used. For detailed information about how to configure the DB schema and the connection data, please refer to the PPM Database Systems user guide. |
|
|
Q2.02 |
How do I change database access data? |
|
Edit the client-specific configuration file <installation directory>\ppmmashzone\server\bin\work\data_ppm\config\<client>\Database_settings.properties and adjust the key values URL, USER, and PASSWD accordingly. Adjustment of the database type specified in the DATABASE_TYPE key is also supported. Use the comments in the file for brief information. If you want to specify the database password in encrypted form, use the PPM command line program runpassencryptor with the -mode db and -password <new password> parameters. |
|
|
Q2.03 |
When starting the PPM server, the database error java.lang.ClassNotFoundException is displayed. What is the reason for this? |
|
The required database drivers must be copied manually after PPM installation and before client installation to the directory <installation directory>\ppmmashzone\server\bin\work\data_ppm\drivers. If the client already exists you can install a database driver via ACC (enhance <client name> with dbDriver local file <path to driver jar file>). For further information about the database connection, please refer to the PPM Database Systems user guide. |
|
|
Q2.04 |
When starting the PPM server, the message DB error: Connection not established. (1006) [17002/null] (1034) is displayed. Why? |
|
The Oracle database listener is not available. Check the Host and Port entries for the JDBC connect string (URL=, line 83) in the client-specific configuration file Database_settings.properties. |
|
|
Q2.05 |
When starting the PPM server, the message DB error: Connection not established. (1006) [-4499/null] (1034) is displayed. Why? |
|
The DB2 database is not available. Check the Host and Port for the JDBC connect string (URL=, line 83) in the client-specific configuration file Database_settings.properties. |
|
|
Q2.06 |
When starting the PPM server, the message DB error: Error reading Isolation-Level (1500) [-99999/null] (1034) is displayed. Why? |
|
The database and JDBC driver version for the IBM DB2 database do not match. |
|
|
Q2.07 |
When starting the PPM server, the message DB error: Connection not established. (1006) [0/08S01] (1034) is displayed. Why? |
|
The Oracle database listener is not available. Check the Host and Port for the JDBC connect string (URL=, line 83) in the client-specific configuration file Database_settings.properties. |
|
|
Q2.08 |
How do I identify the database and JDBC driver version used by the PPM server? |
|
When starting, the PPM server outputs messages stating which database and JDBC driver versions are used. Examples:
I: ...: [SRV] Database version used: Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production I: ...: [SRV] JDBC driver used: Oracle JDBC driver (10.2.0.4.0).
I: ...: [SRV] Database version used: SQL09013. I: ...: [SRV] JDBC driver used: IBM DB2 JDBC Universal Driver Architecture (3.4.65).
I: ...: [SRV] Database version used: 8.00.2039. I: ...: [SRV] JDBC driver used: Microsoft SQL Server 2005 JDBC Driver (1.1.1501.101). |
|
|