Hello everyone,
In our application on a specific screen we have a view which is not responding with data at times. When we create a project in our application, we have a screen which displays some basic data, but this data is over the entire project and over different tables. To create four columns with the right data, we use a few “union all” statements.
The union all statements make sure four relatively complex queries are executed to create the following view:
This view sometimes fails to show its data, these columns are created by four queries on the respective tables and four times a union all. On the role where it goes wrong, only one of these columns is allowed to be shown, so could it be something like that, why it occasionally fails to load? Or is it because sometimes the query is too much for Indicium in combination with Azure to handle?
Does someone else have an occasionally failing screen on a query that is known to be quite slow at times? Because this happens, but when we do a quick refresh, all is well. This refreshing is relatively user unfriendly, so I hope someone can help to resolve this, whether its the query or something in Universal we may have configured incorrectly.
