Microsoft KB Archive/922673

= Error messages when you try to process a database or a cube in SQL Server 2005 Analysis Services: &quot;The attribute key cannot be found&quot; and &quot;The record was skipped because the attribute key was not found&quot; =

Article ID: 922673

Article Last Modified on 7/31/2006

-

APPLIES TO


 * Microsoft SQL Server 2005 Analysis Services

-





SYMPTOMS
In Microsoft SQL Server 2005 Analysis Services, you try to process a database or a cube by using SQL Server Business Intelligence Development Studio or SQL Server Management Studio. However, the process operation fails, and you receive the following error messages:

Error message 1

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

Error message 2

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



CAUSE
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. This behavior may occur when you have not processed the corresponding dimension before you process the cube or when the underlying tables actually have mismatched data. If the &quot;Value:&quot; field in the message has no number after it, the fact table must contain null data.



RESOLUTION
To resolve this issue, you must verify that your data source points to the following locations:
 * The correct underlying data source instance, such as an instance of SQL Server 2005
 * The correct database.

Then, correct the underlying records that contain the problematic attribute key. To do this, use one of the following methods.

Use an existing attribute key
Update the records to use an existing attribute key by running a statement resembles the following: Update  dialog box or the Process Cube –   dialog box, click Change Settings'''.
 * 1) In the Change Settings dialog box, click the Dimension key errors tab.
 * 2) Click Use custom error configuration.
 * 3) In the Key not found list, change the default value from Report and continue to Ignore error.
 * 4) Click Ignore errors count.
 * 5) Click OK to close the Change Settings dialog box.
 * 6) Click OK to process the database or the cube.

Additionally, you can set the error configuration for the cube or the partition to ignore the error. For more information, visit the following MSDN Web site:

http://msdn2.microsoft.com/en-us/library/ms180058.aspx



STATUS
This behavior is by design.

Keywords: kbexpertiseadvanced kbtshoot kbsql2005bi kbsql2005as kbprb KB922673

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.