Long SQL Request Crashing In The Dashboard Widgets
(Doc ID 2526036.1)
Last updated on NOVEMBER 01, 2021
Applies to:
Oracle Insurance Policy Administration J2EE - Version 11.1.0.2 and laterInformation in this document applies to any platform.
Symptoms
On : 11.1.0.2 version, General
ACTUAL BEHAVIOR
---------------
Long SQL request crashing in the dashboard widgets
When an user connects on the dashboard, the data for each widgets are loading from the database. Sql request linked to the 'Recently Created Activities' is crashing as there are too many parameters.
Result:
The data never load for this widget (for this user) and we have some slowdown on the server
EXPECTED BEHAVIOR
-----------------------
load the widget 'Recently Created Activities'. Potentially limit the number of parameters
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a consequent number of activity for one user during a short time
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |