Processing Of Azure Analysis Server Failed

Question

Hi,

we are trying to refresh the azure analysis server using the Azure Logic apps. While I am trying to process i am getting the following error

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":"Fact_PMF","partition":"Current and Future Years"}}}]</p><hr/>

Answer 1

@MAHESWAR KESS

Welcome to the MS Q&A platform.

The error code 0xC112001C 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 the below.

• Check if there are any firewall issues on the Azure Analysis Services.
• Check if the Logic App resource exceeds the throughput limits. If your Logic App resource exceeds these limits, your Logic App resource gets throttled. You can check this from the logic app monitoring section.
• Check if the server administrator permissions are set for the Service Principal you created. The Service Principal you create must have server administrator permissions on the server.
• 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.