Errors in the OLAP storage engine: An error occurred while processing the ” partition of the ‘MeasureGroup’ measure group for the ‘Cube’ cube from the MyDatabase database.

We received Errors in the OLAP storage engine: An error occurred while processing the ” partition of the ‘XYZMeasureGroup’ measure group for the ‘Cube’ cube from the CubeDatabase database.

When you get this error look for errors:

Errors in the OLAP storage engine: The attribute key cannot be found: Table: FactTable, Column: DimKey, Value: 1234.

Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: DimAttrKey of Dimension: Dim from Database: Database, Cube: Policy, Measure Group: XYZMeasureGroup, Partition: XYZPartition, Record: 112233.

Also the above errors in SSDT are with warning ! and not with error X.

We did ROLAP processing and this error was fixed.

Thanks to this blog.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s