Sometimes we get error while retrieving the list of values for a Discoverer report in the Application showing
500 Internal Server Error as shown below.
This can be resolved by following the below steps.
This can be resolved by following the below steps.
1)Select the preferences on the top right corner of the page.
2)Click on the preferences and a New window will be displayed as shown below.
Here change the value for Cancel list-of-values retrieval after.
(In my case i have changed it to 240 as the column contains very huge data for LOV's.)
3)Change the value and click on apply.
And the issue is resolved.
If the same issue occurs in the Discoverer Desktop (or) Discoverer Plus as shown below.
1) Go to Tools -> Options.
A pop-up will be opened as shown in below screenshot.
2)Click on the Query Governor Tab and change the value for Cancel value retrieval after.
3)Click on OK.
The issue is resolved.
Challa.
2)Click on the preferences and a New window will be displayed as shown below.
Here change the value for Cancel list-of-values retrieval after.
(In my case i have changed it to 240 as the column contains very huge data for LOV's.)
3)Change the value and click on apply.
And the issue is resolved.
If the same issue occurs in the Discoverer Desktop (or) Discoverer Plus as shown below.
1) Go to Tools -> Options.
A pop-up will be opened as shown in below screenshot.
2)Click on the Query Governor Tab and change the value for Cancel value retrieval after.
3)Click on OK.
The issue is resolved.
Challa.
No comments:
Post a Comment