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:
- Open the file <MDM_INSTALL_HOME>/KafkaProcessor/properties/statistics-connect-distributed.properties.
- Add the following property and then save the file.
statistics.connect.db.schema = <SCHEMA NAME> - 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:
- Open the file <MDM_INSTALL_HOME>/KafkaProcessor/properties/statistics-transaction-connector.properties.
- Add the following property and then save the file.
db.schema=<SCHEMA NAME> - Open the file <MDM_INSTALL_HOME>/KafkaProcessor/properties/statistics-entity-connector.properties.
- Add the following property and then save the file.
db.schema=<SCHEMA> - 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"}}]
Was this topic helpful?
Document Information
Modified date:
27 April 2022
UID
ibm10732415