Data Doesn’t Get Updated in Forms

By - Updated December 5, 2017


When users update data in forms and click post, data doesn’t get updated in forms.  It reverts back to what it was before updating.  However, when you look into fact table, data does get updated.


It is a known issue on SSAS server.  SSAS server somehow goes to idle mode and cannot respond to changes on SQL server.  We see this issue on Azure machines, or when the server just wakes up from sleep mode.  To resolve this issue, simply deploy the application in Modeler to wake up the SSAS server.