IBM Support

Errors noticed when using Statistics feature on an Upgraded MDM instance

Troubleshooting


Problem

Certain errors are noticed in SystemOut.log when MDM Statistics feature is used. SYMPTOM: The below Exception is noticed in SystemOut.log DWLExceptionU E java.lang.ClassCastException: java.lang.String incompatible with java.util.Listat com.ibm.mdm.statistics.component.StatisticsComponent.handleInitializeStatistics(StatisticsComponent.java:780)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:95)at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)at java.lang.reflect.Method.invoke(Method.java:507)at com.dwl.base.DWLCommonComponent.processTransactionObject(DWLCommonComponent.java:3330)at com.dwl.base.DWLCommonComponent.executeTargetMethod(DWLCommonComponent.java:3069)at com.dwl.base.DWLCommonComponent.executeTx(DWLCommonComponent.java:2418)at com.ibm.mdm.statistics.component.StatisticsComponent.initializeStatistics(StatisticsComponent.java:732)at com.ibm.mdm.statistics.controller.StatisticsControllerImpl.handleInitializeStatistics(StatisticsControllerImpl.java:107)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:95)at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)at java.lang.reflect.Method.invoke(Method.java:507)at com.dwl.base.DWLCommonComponent.processTransactionObject(DWLCommonComponent.java:3330)at com.dwl.base.DWLCommonComponent.executeTargetMethod(DWLCommonComponent.java:3069)at com.dwl.base.DWLCommonComponent.executeTx(DWLCommonComponent.java:2418)at com.ibm.mdm.statistics.controller.StatisticsControllerImpl.initializeStatistics(StatisticsControllerImpl.java:81)at Proxya3372a53_2916_4429_be2c_6edcddcbf475.initializeStatistics(Unknown Source)at Proxya3372a53_2916_4429_be2c_6edcddcbf475.initializeStatistics(Unknown Source)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

Cause

Missing and incorrect database entries related to Statistics are found in MDM instances that have been upgraded from MDM v11.6.0.2 and below

Environment

The workaround has to be applied on MDM databases in MDM instances that have been upgraded from version MDM v11.6.0.2 and below and when the database used is DB2, DB2 for ZOS or Oracle.

Diagnosing The Problem

When the database used is DB2:
1. Login to db2 using command prompt.
2. Execute sql DESCRIBE TABLE INITIALSTATISTICS
The query returns CREATED_DT as a column

When the database used is Oracle:
1. Login to oracle using command prompt.
2. Execute sql DESC INITIALSTATISTICS
The query returns CREATED_DT as a column

Resolving The Problem

When the database used is DB2:
1. Login to db2 using command prompt.
2. Replace <SCHEMA> with schema name in delta_DB2.sql
3. Execute the file delta_DB2.sql
db2 –tvf delta_DB2.sql

When the database used is DB2 for ZOS:
1. Login to db2 using command prompt.
2. Replace <USER ACCOUNT> with owner or creator in delta_DB2ZOS.sql
3. Execute the file delta_DB2ZOS.sql
db2 –tvf delta_DB2ZOS.sql

When the database used is Oracle:
1. Login to oracle using command prompt.
2. Replace <SCHEMA> with schema name in delta_Oracle.sql
3. Execute the file delta_DB2.sql
@delta_Oracle.sql

[{"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":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
27 April 2022

UID

swg22012769