Errors in the OLAP storage engine: The attribute key cannot be found:
-
Thursday, June 14, 2012 7:13 PM
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.
All Replies
-
Thursday, June 14, 2012 7:21 PM
Should be no need to reploy, just wait for the next data load to complete. It's a data problem.
It's an issue with a record existing in the fact table with no corresponding record in the dimensional table.
-
Thursday, June 14, 2012 8:56 PMAny suggestions on how to locate the offensive record?
-
Friday, June 15, 2012 7:29 AM
Hi,
You have some tools to identity bad records. if you right clik the fact table and choose "Explore Data" option you will have four different exel like tabs/tools you can use along with the info of the error message to discrimintate the faulty records :
(table/pivot table/chart/pivot chart)
Philip,
- Edited by VHteghem_Ph Friday, June 15, 2012 7:37 AM
-
Thursday, June 21, 2012 4:48 AMModerator
Hi ppeters86,
This issue occurs because a fact table for a cube has one or more records that contain an attribute key, and this attribute key does not exist in the corresponding dimension table. I recommend you that refer to the article below:
Error messages when you try to process a database or a cube in SQL Server 2005 Analysis Services: "The attribute key cannot be found" and "The record was skipped because the attribute key was not found"Regards,
Bin LongBin Long
TechNet Community Support
- Marked As Answer by Elvis LongMicrosoft Contingent Staff, Moderator Monday, June 25, 2012 10:43 AM
.png)
