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
    nowayout, Aug 27, 2007
    #2

  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.
    satya, Aug 27, 2007
    #3

  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
    nowayout, Aug 27, 2007
    #4

  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.
    satya, Aug 28, 2007
    #5

Share This Page