The operation has been cancelled. at Microsoft.AnalysisServices.Xmla.XmlaClient.CheckForSoapFault(XmlReader reader, XmlaResult xmlaResult, Boolean throwIfError)
Full error text of above message while performing the backup of a Cube:
The operation has been cancelled. at Microsoft.AnalysisServices.Xmla.XmlaClient.CheckForSoapFault(XmlReader reader, XmlaResult xmlaResult, Boolean throwIfError) at Microsoft.AnalysisServices.Xmla.XmlaClient.CheckForError(XmlReader reader, XmlaResult xmlaResult, Boolean throwIfError) at Microsoft.AnalysisServices.Xmla.XmlaClient.SendMessage(Boolean endReceivalIfException, Boolean readSession, Boolean readNamespaceCompatibility) at Microsoft.AnalysisServices.Xmla.XmlaClient.SendMessageAndReturnResult(String& result, Boolean skipResult) at Microsoft.AnalysisServices.Xmla.XmlaClient.Execute(String command, String properties, String& result, Boolean skipResult, Boolean propertiesXmlIsComplete) at Microsoft.SqlServer.Management.Smo.Olap.SoapClient.ExecuteStatement(String stmt, StatementType stmtType, Boolean withResults, String properties, String parameters, Boolean restrictionListElement, String discoverType, String catalog) at Mi. The step failed.
I couldn't find any fix or link on the web too to resolve this error, it works intermittently and fails with the error above. Eventually found from the Microsoft PSS that the relevanent xmla.dll file should be dated as follows:
File: microsoft.analysisservices.xmla.dll
Version: 9.02183.0232,224
Date: 17-Aug-2006
For: X86 |
|
|
|
|
|
The X86 component is for 32 bit system for Analysis Services and you would see X64 for 64 bit systems. I believe there is a support hotfix available for a charge and this hotfix stops and then restarts the Analysis Services service.
If you have configured the server for HTTP access, you have to stop IIS and then restart it after the installation is finished. If you have installed SQL Server Analysis Services as a named instance, you must stop the SQL Server Browser service because the Msmdredir.dll component of the SQL Server Browser service is updated when you apply this hotfix.
Phew, this has fixed the problem.
**__________________________________**
SQL Server MVP, Sr. DBA & industry expert.
-
Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it. It is also a power and you will gain by sharing it.