Author: Joyce Zhou
After changing partitions to MOLAP mode, the deployment process fails due to internal error.
This error means there are invalid data in the MOLAP partition. The error message tells us that the error occurred in the OPEX-Accounts partition of the Actuals cube.
Then we can go to the Reporting model and check all the MOLAP partitions one by one. Checking the Errors Only checkbox can help you quickly identify if there is any invalid data within the partition.
There are two types of invalid data:
- The dimension member doesn’t exist in model hierarchy
- The dimension member doesn’t exist in the dimension at all
If it is the first case, you’ll see a yellow exclamation icon as shown above. Otherwise you’ll see a red icon. To fix the first type error, you just need to add the member back to the hierarchy that is used by the model.
The second type error can be more complicated. You'll need to remove all the invalid records, however be aware that this will cause data loss. You may want to talk with the business users before deleting anything. Also, you may need to find out what causes the issue and fix it from the root. Most time we find the cause can be:
- Members have been mistakenly removed from the dimension
- Invalid members have been inserted into the partition through a SQL rule.
We highly suggest following the Kepion Data Integration Best Practices in order to reduce the likelihood of having invalid data in the system.