Does not return Warning message

This is a discussion on Does not return Warning message within the sqlserver-datawarehouse forums in Data Warehousing category; 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: ...

Go Back   Database Forum > Data Warehousing > sqlserver-datawarehouse

Database Forums

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 07-01-2008, 04:20 PM
Default 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
Reply With Quote
Reply


Thread Tools
Display Modes



All times are GMT -4. The time now is 04:17 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Integrated by bbpixel2008 :: jvbPlugin R1013.368.1

Search Engine Friendly URLs by vBSEO 3.1.0
vB Ad Management by =RedTyger=
In an effort to better serve ads to our visitors, cookies are used on Mydatabasesupport.com. For more information, check out our Privacy Policy.