Who can tell me how to deal with the error when I was merging partitions?
There are two errors when I merged the two partitions (Total_Orders_2001,Total_Orders_2002) under the “Sales Orders” measure group in the Adventure Works DW (SQL sample).
The two errors are:
Errors in the OLAP storage engine: The attribute key cannot be found: Table: FactSalesSummary, Column: SalesOrderNumber, Value: SO45038.
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)
I tried to ignore attribute key error and the first error disappeared. But the second error still exists.
The error message was shown as bellow:
===================================
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)
Program Location:
at Microsoft.AnalysisServices.AnalysisServicesClient.SendExecuteAndReadResponse(ImpactDetailCollection impacts, Boolean expectEmptyResults, Boolean throwIfError)
at Microsoft.AnalysisServices.AnalysisServicesClient.MergePartitions(IEnumerable sources, Partition target)
at Microsoft.AnalysisServices.Server.MergePartitions(IEnumerable sources, Partition target)
at Microsoft.AnalysisServices.Partition.Merge(IEnumerable sources)
at Microsoft.SqlServer.Management.SqlManagerUI.OlapMergePartition.SendDataToServer()
at Microsoft.SqlServer.Management.SqlManagerUI.OlapMergePartition.OnRunNow(Object sender)
at Microsoft.SqlServer.Management.SqlMgmt.PanelExecutionHandler.Run(RunType runType, Object sender)
at Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.DoPreProcessExecutionAndRunViews(RunType runType)
at Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.ExecuteForOlap(PreProcessExecutionInfo executionInfo, ExecutionMode& executionResult)
at Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.Microsoft.SqlServer.Management.SqlMgmt.IExecutionAwareSqlControlCollection.PreProcessExecution(PreProcessExecutionInfo executionInfo, ExecutionMode& executionResult)
at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.RunNow(RunType runType, Object sender)
Who can tell me how to resolve it?
Any reponse is appreciated^_^
Thanks
Winnie
