My Oracle Support Banner

Long SQL Request Crashing In The Dashboard Widgets (Doc ID 2526036.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Insurance Policy Administration J2EE - Version 11.1.0.2 and later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.