Winnie.Wang


 

    When I want to merge two partitions in "Sales Orders" MeasureGroup in Adventure Works DW in Microsoft SQL Server Management Studio, an error happened like this:

Errors in the OLAP storage engine: The attribute key cannot be found: Table: FactSalesSummary, Column: SalesOrderNumber, Value: SO43659.
Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation.
 (Microsoft.AnalysisServices)

    Who can tell me how to resolve it

    Any response is appreciated.

 

Thanks^_^

Winnie




Re: Error in Merging partitions in AS 2005 Sample (Adventure Works DW)

Edward Melomed


You should change Error configuration to what you had during original processing of partitions.

Looks like you had error configuration settings to ignore some of the errors.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.







Re: Error in Merging partitions in AS 2005 Sample (Adventure Works DW)

Winnie.Wang

Thank you! Edward

I have changed the Error configuration to ignore KeyNotFound error. But the second error:

Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation.
(Microsoft.AnalysisServices)

still exist.

I have tried to change all the availible items in the Error configuration, but the error can not disappear.

What shoud I modify

Thanks^_^

Winnie






Re: Error in Merging partitions in AS 2005 Sample (Adventure Works DW)

Bala Atur

There is a bug in the product. It pertains to ROLAP dimensions and the merge partition operation. From the error message about the missing attribute key it sounds very much like you're hitting that problem. If this scenario is important to you - please request a QFE through our CSS folks and we'll take it from there...