| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
|
| According to the below article there should be 2 error messages on the Attribute Key not found in fact table. http://support.microsoft.com/kb/922673/ I am trying to parse the Error message 2 using AMO script to retrive the dimension name. 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: TableName, Column: ColumnName1, Value: Value1. Table: TableName, Column: ColumnName2, Value: Value2. Error message 2 Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: generated attribute X of Dimension: DimensionName from Database: DatabaseName, Cube: CubeName, Measure Group: MeasureGroupName, Partition: PartitionName, Record: RecordNumber. But it seems like Error message 2 is not always returned and I am unable to parse the error as there is no warning message. Does anybody know how the Error 2 is generated? Thanks, Nagy |
![]() |
| Thread Tools | |
| Display Modes | |