Troubleshooting
Problem
When InfoSphere MDM version 11.6.0.4 is installed with MDM Statistics feature, when database type is ORACLE and user selected an option “Connect to Oracle databases using service name instead of database name”, replacements for database connection URL for MDM Statistics property files is having wrong syntax.
Symptom
The following error occurs when the database type is ORACLE and user selected an option Connect to Oracle databases using service name instead of database name.
In <MDM_INSTALL_DIR>/KafkaProcessor/properties directory, files statistics-connect-distributed.properties and statistics-transaction-connector.properties have wrong replacements for database connection URL.§
Cause
During MDM Installation while performing replacements in Statistics property files, user selection for using SID(database name) or SERVICE NAME is not taken into consideration.§
Environment
This problem occurs when InfoSphere MDM v11.6.0.4 is installed with Oracle as database and user selected an option to Connect to Oracle databases using service name instead of database name.
Resolving The Problem
To resolve this issue, complete the following steps:
a. Go to <MDM_HOME>/KafkaProcessor/properties directory.
b. Edit file statistics-connect-distributed.properties and for field statistics.connect.db.connectionURL, replace ‘:’ with ‘/’ before database name.
c. Edit file statistics-transaction-connector.properties and for field db.connectionUrl, replace ‘:’ with ‘/’ before database name.
Example:
Before:db.connectionUrl=jdbc:oracle:thin:@<<db.host>>:<<db.port>>:<<db.databaseName>>
After:db.connectionUrl=jdbc:oracle:thin:@<<db.host>>:<<db.port>>/<<db.databaseName>>
Note: If SID is provided : need to be used and if service name is provided, / should be used.
Was this topic helpful?
Document Information
Modified date:
27 April 2022
UID
swg22011462