In recent months I faced a problem regarding daily automatic proccessing of our olap cube model. And the main problem is that this error message appears irregularly. That is, during the day, sometimes the processing is successful, sometimes an error crashes after 10 minutes
The error message goes as follows:
Microsoft.AnalysisServices.Xmla.XmlaException: The JSON DDL request failed with the following error: Failed to execute XMLA. Error returned: 'OLE DB or ODBC error: [DataSource.Error] PostgreSQL: Exception while reading from stream.OLE DB or ODBC error: [DataSource.Error] PostgreSQL: Exception while reading from stream.OLE DB or ODBC error: The command has been canceled..'.. 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)
I have tried to set various timeouts: RemoteQueryTimeout (from 600 to bigger numbers like 2000 or even 0 for no timeout), ExternalCommandTimeout, ExternalConnectionTimeou, ForceCommitTimeout
Nothing helped and the error is still here
Has anyone faced that kind of problem? To be honest, I no longer know what the problem is and how it can be solved
Thank you in advance
Well, I found a solution. The solution was to add “commandTimeout”:”PT1H” for 1 hour timeout as a condition while connecting to database
