Errors in the OLAP storage engine: The attribute key cannot be found:


  • Product:  SQL Server 2005 Analysis Services,  SQL Server 2005 RDBMS

    Problem:  When trying to perform a “process full” against a Analysis Cube the following error is returned:

    Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_FactCase, Column: PatientKey, Value: 125395; Table: dbo_FactCase, Column: CustomerKey, Value: 310. Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: Fact Case of Dimension: Dim Case from Database: OrametrixDWCubes, Cube: CaseCube, Measure Group: Fact Case, Partition: Fact Case, Record: 59769.

    Attempted solutions:

    Verified that the the keys exist in the underlying relational database and the table records are complete.

    • No nulls for keys on any fact table or dimension in the underlying relational database.  We are using surrogate keys in all tables per Kimball method.
    • Underlying relational database is straight star schema – no snowflake design.
    • Reprocess full on all dimensions first and then process on the affected cube generates the same error message.
    • Allowing for continued processing despite errors  it will complete but with errors for those unidentified attribute keys.


    This process has been running nightly for years.  On the rare incident when this has occurred in the past – reprocessing and deploying the cube has fixed the problem.

    Thursday, June 14, 2012 7:13 PM


All replies