Troubleshooting
Problem
Unable to migration Planning Analytics Database. Errors occur: Dimension could not be Compiled - Blank element found in dimension
Symptom
Planning Analytics Database Migration Fails with error:
22588 [] INFO 2024-02-09 18:15:04.903 TM1.Dimension Loading dimension dimension_name
22588 [] INFO 2024-02-09 18:15:04.904 TM1.Dimension Loading dimension dimension_name:hier_name
22588 [] INFO 2024-02-09 18:15:04.904 TM1.Dimension Loading dimension dimension_name:Leaves
22588 [] ERROR 2024-02-09 18:15:04.905 TM1.Dimension A leaf element with name 'ELEMENT_NAME' already exists for dimension ''
22588 [] WARN 2024-02-09 18:15:04.905 TM1.Dimension Dimension could not be Compiled "ELEMENT_NAME", Dimension "dimension_name:Leaves"
22588 [] ERROR 2024-02-09 18:15:04.905 TM1.Dimension Blank element found in dimension "dimension_name:Leaves" - Ignored.
22588 [] INFO 2024-02-09 18:15:04.903 TM1.Dimension Loading dimension dimension_name
22588 [] INFO 2024-02-09 18:15:04.904 TM1.Dimension Loading dimension dimension_name:hier_name
22588 [] INFO 2024-02-09 18:15:04.904 TM1.Dimension Loading dimension dimension_name:Leaves
22588 [] ERROR 2024-02-09 18:15:04.905 TM1.Dimension A leaf element with name 'ELEMENT_NAME' already exists for dimension ''
22588 [] WARN 2024-02-09 18:15:04.905 TM1.Dimension Dimension could not be Compiled "ELEMENT_NAME", Dimension "dimension_name:Leaves"
22588 [] ERROR 2024-02-09 18:15:04.905 TM1.Dimension Blank element found in dimension "dimension_name:Leaves" - Ignored.
Resolving The Problem
- In this example, ELEMENT_NAME exists in dimension_name as a consolidated element
- For an unknown reason, the element still exists in the Leaves hierarchy of dimension_name
- Review the problematic element and update the model accordingly
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEAI8G","label":"Planning Analytics as a Service"},"ARM Category":[{"code":"a8m3p000000GoaQAAS","label":"Planning Analytics-\u003EPlanning Analytics as a Service Specific-\u003EDatabase Migration Tool"}],"ARM Case Number":"TS015336451","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
11 March 2024
UID
ibm17135624