We have a daily SQL Server Agent Job that's failing intermittently. Between May 27th and Jun 16th, it has failed twice.
The error message we receive (listed below) references "The file could not be decrypted." The step, however, is an Analysis Services step that builds a cube; the message seems to have no relevance in this context.
We've been unable to locate any references online for this message that speak to anything other than Biz Talk or connecting to Excel spreadsheets, neither of which are in play here.
Message (Edit to Bold the relevant error message):
Executed as user: CORPORATE\sqlagent.
Microsoft.AnalysisServices.Xmla.XmlaException: Internal error: The
operation terminated unsuccessfully.The following system error
occurred: The specified file could not be decrypted. Errors in the
high-level relational engine. A connection could not be made to the
data source with the DataSourceID of 'Data Warehouse', Name of 'Data
Warehouse'.Errors in the OLAP storage engine: An error occurred while
the dimension, with the ID of 'Time', Name of 'Day' was being
processed.Errors in the OLAP storage engine: An error occurred while
the 'Calendar Month' attribute of the 'Day' dimension from the
'CustomerExperienceCenter' database was being processed. Server: The
current operation was cancelled because another operation in the
transaction failed. 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
Microsoft.SqlServer.Management.Smo.Olap.SoapClient.SendCommand(String
command, Boolean withResults, String properties) at
OlapEvent(SCH_STEP* pStep, SUBSYSTEM* pSubSystem, SUBSYSTEMPARAMS*
pSubSystemParams, Boolean fQueryFlag). NOTE: The step was retried the
requested number of times (1) without succeeding. The step failed.