Submitting a Request takes a Long time
Hi Community
I am facing a strange issue since last week.
Starting a Case from Living application page is taking a long time to submit.The delay in response is about 10 Seconds.
Earlier starting a case would take less than 1 Second as response from server would be immediate. Suddenly now its takes as long as 50 seconds to submit a case.
This is taking more time if there are documents that are attached . Without documents, case can be started in 10 seconds and with 3-4 attachments its taking around 50-60 Seconds to start a case.
After clicking the submit button , the page takes a long time to return 200 status code from the server.
This is causing a lot of Problems with requesters.
There are no errors logged in the Logs. Most errors were for generic events related to process.
Please let me know what parameters can i check.
Regards
Dibyajit Roy
Regarding those slow query logs in org.hibernate.SQL_SLOW, this is the default Bonita behavior when a database query lasts more than 1 second (by default). If this default value does not suit your needs, you can change it. See the dedicated documentation page.
It should indicate the query that is too slow, but unfortunately for Oracle, there is a known issue in Hibernate that prevents it to properly log the query that is slow. See https://hibernate.atlassian.net/browse/HHH-13741 for details.
Hope this helps
Hello,
Maybe the slowness simply comes from the fact that your attachments are large to upload.
What are the size of your attachements?
With the developer tools generally bundled with Firefox of Google Chrome, can you check the response time of the upload of the documents, in order to narrow the part of the "page" that is slow?
Thx
Comments
Hello Emmanuel
Thank you for your response.
We found out the size of the Documents were not the issue.
It seems there were concurrent sessions to Database which did not execute and ended in blocking sessions.
Finally when we reached 17 blocking session, the Database stopped responsing and Portal was down.
This is when we found the blocked sessions.
After clearing the sessions (both Active and old sessions) And restarting the server seemed to solve the issue.
But unfortunately we did not notice any error in Logs. We often got a org.hibernate.SQL_SLOW SlowQuery: 1174 milliseconds. SQL: 'oracle.jdbc.driver.OraclePreparedStatementWrapper@535296d7'
this was not clear about the issue.
Thankfully the system is working better now.