IBM Support

Syntax issue on MDM statistics propeerty files

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.

[{"Product":{"code":"SSWSR9","label":"IBM InfoSphere Master Data Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"11.6.0.4","Edition":"Standard Edition","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
27 April 2022

UID

swg22011462