IBM Support

InfoSphere MDM database schema name is missing from the Statistics Collection properties files

Troubleshooting


Problem

When the InfoSphere MDM database user and schema user are different, the schema name has to be specified when obtaining the database connection. This detail is missing from the properties files corresponding to the Entity and Transaction Statistics Collection feature.
 

Resolving The Problem

To resolve this issue when the Statistics Collection feature is used in distributed mode:

  1. Open the file <MDM_INSTALL_HOME>/KafkaProcessor/properties/statistics-connect-distributed.properties.
  2. Add the following property and then save the file.
                  statistics.connect.db.schema = <SCHEMA NAME>
  3. Restart the Statistics Collection applications statistics-connect-distributed.sh and statistics-connectors-provision.sh.

 

To resolve this issue when the Statistics Collection feature is used in standalone mode:

  1. Open the file <MDM_INSTALL_HOME>/KafkaProcessor/properties/statistics-transaction-connector.properties. 
  2. Add the following property and then save the file.
                  db.schema=<SCHEMA NAME>
  3. Open the file <MDM_INSTALL_HOME>/KafkaProcessor/properties/statistics-entity-connector.properties.
  4. Add the following property and then save the file.
                db.schema=<SCHEMA>
  5. Restart the Statistics Collection application statistics-connect-standalone.sh.

 

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSWSR9","label":"IBM InfoSphere Master Data Management"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.6.0.4, 11.6.0.5, 11.6.0.6, 11.6.0.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
27 April 2022

UID

ibm10732415