Does not return Warning message
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
date: Tue, 1 Jul 2008 12:20:03 -0700 (PDT)
author: naggy