Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
SQL
ce
clients
clustering
connect
datamining
datawarehouse
dts
fulltext
jdbcdriver
msde
mseq
newusers
notificationsvcs
odbc
olap
programming
replication
reportingsvcs
security
securitytools
server
setup
sqlxml.viewmapper
tools
xml
  
 
date: Tue, 1 Jul 2008 12:20:03 -0700 (PDT),    group: microsoft.public.sqlserver.datawarehouse        back       


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

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us