ODBC Connection Error- SSMS

2024-03-05T05:40:44.61+00:00

We are getting ODBC/Connection Error for few of the jobs which are running in SSAS. while some other jobs are running fine with the same ODBC Connection.

Error:

Message

Executed as user: NA\ps498921. Microsoft.AnalysisServices.Xmla.XmlaException: The JSON DDL request failed with the following error: Failed to execute XMLA. Error returned: 'OLE DB or ODBC error: [Cloudera][ImpalaODBC] (120) Error while retrieving data from in Impala: [08S01] : SSL_read: error code: 0; 08S01.The current operation was cancelled because another operation in the transaction failed.A connection could not be made to the data source with the Name of 'Hadoop'.A connection could not be made to the data source with the Name of 'Hadoop'.OLE DB or ODBC error: [Cloudera][ImpalaODBC] (170) Query was canceled from another thread.; S1008.OLE DB or ODBC error: [Cloudera][ImpalaODBC] (170) Query was canceled from another thread.; S1008.'.. 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.ExecuteStatement(String statement, String properties, String& result, Boolean skipResult, Boolean propertiesXmlIsComplete) 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). The step failed.

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,284 questions
{count} vote

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.