Dashboard Issues/Page Loading Issues

Issues

Cause

Diagnosis

Resolution

Issue in loading the Transaction Dashboard and other pages

1.The increase in memory/CPU usage.
2.Issues with the IO of the database.
3.Accumulation of records in au_transactionData table due to which query is taking longer to retrieve the data and getting timed out.
4.Logging level of microservices is set to INFO due to which a large amount of data is generated.

Checked the Dashboard for any Running transaction.

1.Clear the browser Cache.
2.Check Webrunner and Runtime logs to see which process to consuming the DB resources.and IO resources.
3.Boost the database's I/O performance.
4.Decrease wait timeout to reduce no. of active connection.
5.Restart the Runtime/WebRunner and check if any process or transaction is in a running state.
6.Change the logging setting to NOTICE so that the data generated will be less and faster to access the dashboard.

  1. Clean the record from the au_transactionData Table.