we are running OSM 7.0.1 (PL12) and we are facing an issue with the worklist view in OSM GUI.
For users who didin´t create a customized search in the worklist view, the worklist is not coming up. after 10mins of loading the following error message "A comm error occured.
The Web Server may be down, too busy, or experiencing other problems preventing it from responding to requests."
Query view, which loads the same amount of records (200) in standard view is working fine.
For users who access the worklist view whit a customized search which for example only resulst in 10 records, the worklist view is working fine. so I assumed it´s related to the amount of records the worklist tries to load from the DB since this would also match the error message.
But the Query view is loading the same amount of records without any issue.
Thanks for any hint.
the problem is that the worklist page itself is not loading. it´s not the records whic hare not displayed but the complete worklist webpage is not showing up. due to this I´m also not able to edit the preferences.
Hi Lucas, if you activate the proxy query trace on the log4jAdmin web page, you see the worklist SQL printed in the log file.
Or, you can try to catch it using v$ views.
You can then try to execute and see if DB response is an issue.
Theoretically this is possible though the Query works fine returning the same number of rows, since don't forget this is a different SQL statement.
If DB reponse is the issue, the rest is DBA routine, execution plan, statistics, parameters, we all know that.
On the other hand if you run the SQL from e.g. SQL*Plus and it executes in no time, then your issue is something else.
In which case I would recommend to raise an SR.
Try this and post you findings back if you will.
it´s as you said. I turned on the "com.mslv.oms.dataaccesslayer.QueryProxy" in the Log4JAdmin GUI and saw the SQL in the .out log.
When I execute the SQL directly on the DB, it´s working fine.
So it looks like another issue than the DB.
Edited by: LucasT on Jul 19, 2012 4:10 PM