SQL Server Performance

Cube Back up error

Discussion in 'SQL Server 2005 Analysis Services' started by nowayout, Aug 27, 2007.

  1. nowayout New Member

    Hi all,
    I have back up job that runs to back up Cube daily but lately it is failing and gives error bellow:
    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.Sm:confused:lap.SoapClient.ExecuteStatement(String stmt, StatementType stmtType, Boolean withResults, String properties, String parameters, Boolean restrictionListElement, String discoverType, String catalog) at Mi. The step failed.
    But if i run that job manually it runs fine(successfully)
    What could be the problem!!
    thanks
  2. satya Moderator

    Sounds like a tools issue, may try from another client's machine with similar tools level. Also ensure the XML related drivers are installed properly.
  3. nowayout New Member

    What tools!! Because it did work in middle then started failing again!! if XML tool need to be updated then which one!!
    Thanks
  4. satya Moderator

    SQL client tools, post the job step definition to see whether proper path is mentioned and account has relevant privileges in thsi case.

Share This Page