Data Not Updating in Form

Author: Joyce Zhou

Symptom

When users update data in a Form and click Post, the data doesn’t get updated. It reverts back to what it was before updating. However, when you look into the fact table, the data is updated.

Resolution

This is a known issue on the SSAS server. The SSAS server sometimes goes into idle mode and cannot respond to changes on the SQL server. We see this issue on Azure machines, or when the server wakes up from sleep mode. To resolve this issue, simply re-deploy the application in the MODELER to wake up the SSAS server.