Customer has a series of 6 dashboards, each dashboard has a large amount of widgets, most of which have sql as the source. This includes Piev2, gauge, sql tables.
These dashboards report data for different departments; they contain the same amount of sql queries and report similar data. The data is extracted from our uim database.
This database data is updated monthly. Following the update most of these dashboards take a long time to load when accessed, after 24 hours they usually load, however more recently some load and others haven't.
Increase the dashboard dataSession timeout under the dashboards section in the wasp.cfg, e.g.,
<timeouts>
metricDS = 30000
qosDS = 30000
dashboardDS = 30000
sqlDS = 30000
probeDS = 30000
dataSession = 10000
slaDS = 30000
listDS = 30000
</timeouts>
For example, try 20000 or 30000 if that is an acceptable length of time. Note that the time is in milliseconds.
Refer to: Troubleshooting dashboards