Analysis service error

Question

Did anyone notice this error while refreshing the azure analysis services?

Error Details<br/><p style='color:red'>[{"message":"Retry attempts for failures while executing the refresh exceeded the retry limit set on the request.","type":"error"},{"code":"0xC112001C","message":"<ccon>Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.</ccon>;<ccon>The wait operation timed out</ccon>. The exception was raised by the IDbCommand interface.","type":"error","location":{"sourceObject":{"table":table1","partition":"datetimeinyears"}}}]</p><hr/>

Answer 1

Hello Bharath,

Welcome to the Microsoft Q&A platform.

The error message "Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding" indicates that the execution timeout expired, and the wait operation timed out. This error can occur when the server is not responding or when the server is taking too long to respond.

Please check if there are any firewall issues on the Azure Analysis Services.

and If the refresh is timing out before it can complete, you may need to increase the timeout value for the refresh operation. You can do this by modifying the refresh settings for your model in Azure Analysis Services.

A similar thread has been discussed here for the error: "The exception was raised by the IDbCommand interface"

I hope this helps. Please let me know if you have any further questions.