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

    Question

  • 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.

    History:

    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

Answers

All replies