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(3.2, 23%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
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. Also, our programmer said there is no timeouts from Postgresql for long running queries.
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
Hi @Artemiy Safronov , welcome to Microsoft Q&A! Could you please check the msmdsrv.log to get more error details? The file location is C:\Program Files\Microsoft SQL Server\MSAS15.SQLSERVER2019\OLAP\Log. For more information, please refer to Log operations in Analysis Services.
Hi @Artemiy Safronov , we have not get a reply from you. Any update for this thread?
Hi, well, I found a solution. Logs did not provide crucial information about the error, but it helped to understand the type and category of an error.
So, the solution was to add “commandTimeout”:”PT1H” for 1 hour timeout as a conditon while connecting to database 
Good to know that the error has been solved. Could you please do "Accept Answer" for this thread? By doing so, it will benefit for community members who have this similar issue. Your contribution is highly appreciated. Thank you!