This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 91%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKB%3C/text%3E%3C/svg%3E)
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.
It's complaining it's a connection error and that it's being forcibly closed. Is something limiting the number of concurrent connections? Can you change the processing to avoid the amount of parallelism that's happening during loading?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 66%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMR%3C/text%3E%3C/svg%3E)
In SSAS Tabular model we are randomly getting ODBC connection Error in job scheduler for some tasks but same ODBC connection is working fine for all other tasks in the same model.
Still we are getting same error, can someone pls advise to resolve this issue?
Is there any possibility if we upgrade the SSMS version?