Symptom
After changing partitions to MOLAP mode, the deployment process fails during the Process stage due to an internal error.
Resolution
This error means there's invalid data in the MOLAP partition.
There are two types of invalid data:
- The dimension member doesn’t exist in the model hierarchy.
- The dimension member doesn’t exist in the dimension at all.
Member not in model hierarchy
Go to the target model and check all the MOLAP partitions individually. You’ll see a yellow exclamation icon.
Tip: Select the Show data errors checkbox to help quickly identify invalid data within the partition.
To fix this error, you need to add the member back to the hierarchy used by the model.
Member not in dimension
Go to the target model and check all the MOLAP partitions individually. The second type of error will display as a red icon.
Tip: Select the Show data errors checkbox to help quickly identify invalid data within the partition.
Fixing this error can be complicated. You'll need to remove all the invalid records, so data loss will occur. Confer with business users before deleting anything. Also, you may need to find out what causes the issue and fix it from the root.
Most times the root cause is either:
- Members have been mistakenly removed from the dimension.
- Invalid members have been inserted into the partition through a SQL rule.
We highly suggest following our best practices for data integration to reduce the likelihood of having invalid data in the system.