Troubleshooting
Problem
Attempts to load classifications result in wrong hierarchy when using IBM Maximo Asset Management Integration Framework or Maximo Enterprise Adapter.
Symptom
After loading a classification set containing a parent / child relationship, the hierarchy is incorrect when shown in the DrillDown option. The classification parent is correct in the Classification application.
Cause
In the CLASSSTRUCTURE table there is a field used to build this Hierarchy in the DrillDown option.
The CLASSSTRUCTURE.HASCHILDREN field is set to 1 (true) when the classification is a parent Classification. Also it is set to 0 (false) when the classification has no child classification.
This problem happens when HASCHILDREN is not properly set when loading the Classification data.
By default this field is not INCLUDED in the MXCLASSIFICATION Object Structure.
Diagnosing The Problem
Query the CLASSSTRUCTURE table and verify if the HASCHILDREN is properly set
Resolving The Problem
To resolve this issue you have to re-import all classifications and set the HASCHILDREN as per the Classification hierarchy.
Before running the import process, the HASCHILDREN has to be included in the Object Structure.
1 - Go to > Integration > Object Structure > Select the Object you are using.
2 - Select Action > Exclude / Include Fields
3 - In the Source Object List, select CLASSSTRUCTURE
4 - In the Persistant Fields sub-tab, look for HASCHILDREN and UNCHECK the EXCLUDE checkBox. This will include the field in the schema.
5 - Click the OK button.
6 - Select Action > Generate Schema / View XML > OK
7 - Click the OK Button
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21516924