Database connection

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.
If the connection to the database cannot be established when starting the client server, corresponding error messages indicate the possible causes. Use PPM Customizing Toolkit (Edit client, Database settings dialog, Test database connection button) to check and adapt the correct database connection of the client.

 

 

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)
Connection not established. (1006) [-4499/null]
[ibm][db2][jcc][t4][2043][11550] Exception java.net.ConnectException: Error opening socket to server ...

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)
Error reading Isolation-Level (1500) [-99999/null]
DatabaseMetaData information is not known for server DB2/ ...

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)
Connection not established. (1006) [0/08S01]
Unable to establish TCP/IP connection with host. java.net.ConnectException: Connection refused
DB error: Connection not established. (1006) [17002/null] (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:

  • Oracle

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).

  • IBM DB2

I: ...: [SRV] Database version used: SQL09013.

I: ...: [SRV] JDBC driver used: IBM DB2 JDBC Universal Driver Architecture (3.4.65).

  • MS SQL Server

I: ...: [SRV] Database version used: 8.00.2039.

I: ...: [SRV] JDBC driver used: Microsoft SQL Server 2005 JDBC Driver (1.1.1501.101).