Hi,
There are dashboards that contains data coming from display tables in oracle.
These DBs are created on top of webi using LO and kept as On Demand that refreshes every 5mins as this dashboard displays realtime data for 24 hrs.
The problem is that when a dashboard is executed, after 2 hours it is hanging and it is not showing latest data.
It is throwing an error message like java sweeps error.
Can anyone explain the reason of why the dashboard is hanging and giving a java error after 2 hours.
Any performance tuning methods are there to rectify and do.
Rregards