Skip to Content
0
Former Member
Dec 08, 2010 at 12:43 PM

issue while restoring backed up Appset. It is getting failed at OLAP databa

57 Views

Hi,

I am getting below issue while restoring backed up Appset. It is getting failed at OLAP database phase. Please help me to resolve the issue.

#2.0 #2010 12 08 18:02:26:870#-8:00#ERROR#OLAPServerHandler##EPM-BPC-MS##45d0c96e-77a3-49c3-9fbb-2a73b40d7197###Olap9Manager : CreateDimension#########Plain##

==============[System Error Tracing]==============

[System Name] : OLAPServerHandler

[Message Type] : ErrorMessage

[Job Name] : Olap9Manager : CreateDimension

[DateTime] : 12/8/2010 6:02:26 PM

[UserId] :

[Exception]

DetailMsg : {Microsoft.AnalysisServices.OperationException: Errors in the high-level relational engine. The data source view does not contain a definition for the 'IS_INPUT1' column in the 'dimP_ACCT' table or view.

Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'BP_Consolidation', Name of 'P_ACCT' was being processed.

Server: The operation has been cancelled.

at Microsoft.AnalysisServices.AnalysisServicesClient.SendExecuteAndReadResponse(ImpactDetailCollection impacts, Boolean expectEmptyResults, Boolean throwIfError)

at Microsoft.AnalysisServices.AnalysisServicesClient.Process(IMajorObject obj, ProcessType type, Binding source, ErrorConfiguration errorConfig, WriteBackTableCreation writebackOption, ImpactDetailCollection impact, XmlaWarningCollection warnings)

at Microsoft.AnalysisServices.Server.Process(IMajorObject obj, ProcessType processType, Binding source, ErrorConfiguration errorConfig, WriteBackTableCreation writebackOption, XmlaWarningCollection warnings, ImpactDetailCollection impactResult, Boolean analyzeImpactOnly)

at Microsoft.AnalysisServices.Server.SendProcess(IMajorObject obj, ProcessType processType, Binding source, ErrorConfiguration errorConfig, WriteBackTableCreation writebackOption, XmlaWarningCollection warnings, ImpactDetailCollection impactResult, Boolean analyzeImpactOnly)

at Microsoft.AnalysisServices.ProcessableMajorObject.Process(ProcessType processType, ErrorConfiguration errorConfiguration, XmlaWarningCollection warnings)

at Osoft.Services.Platform.YukonAdmin.Olap9Manager.CreateDimension(String strOLAPDimName, String strDimType, String[] strProper, String strDesc, String strLevels, Int32 intMaxHier, Int32 intProcessOption, String dimTablePrefx, String strCube, Boolean bFormula, String[] strFormulaLevels, String strCommand, String& strMsg, Boolean bOnlySharedDim)}

==============[System Error Tracing End ]==============

Environment: MS BPC 7.5 SP03

SQL 2008

Thanks,

Suraj