#
Errors in the OLAP storage engine - A processing indexes for the partition <partition_name> of the <measuregroup_name> measure group.
#
Problem
The processing of OLAP cubes, either in the daily processing or in manual execution of ProcessOlap, may run into this error. This may occur because of the error:
The attribute key cannot be found when processing: ...
An error like this occurs when the composite keys of the dimension does not match the data of the fact table in the OLAP cube. The error may not be visible in the Analysis Server console application logs, it is better to use SQL Server Management Studio (SSMS) to process the OLAP cube to see detailed information of the error.
To process using SSMS:
Open SQL Server Management Studio (SSMS).
Connect to Analysis Services.
Expand Databases and the OpeniT (name may vary) OLAP database.
Expand Cubes and right-click the Applications cube.
Select Process and click OK.
The Process Progress dialog will appear, displaying the processing details of each dimension and measure group.
Wait until the error occurs.
#
Resolution
Follow these instructions to solve the issue:
Open SQL Server Management Studio (SSMS).
Connect to Analysis Services.
Expand Databases and the OpeniT (name may vary) OLAP database.
Expand Cubes > Applications > Measure Groups > Partitions.
Select the Partition where the error is occurring.
Right-click the partition and select Properties.
Analysis Server Troubleshooting: OLAP - Ignore Error
The Partition Properties dialog will appear.
In the left pane, select Error Configuration.
Uncheck Use default error configuration, if checked by default.
Set the Processing error limit to Ignore errors.
Set Specific error conditions > Key not found to IgnoreError. Click OK.
Using the Analysis Server console application, execute the commands ProcessSQL and ProcessOlap.
Wait until the process finish.