Discoverer Preferences Issue

Scope:

Oracle Discoverer - Version: 10.1.2.1 to 10.1.2.2

Issue:

After Discoverer 10g server has been started, users are unable to run any Discoverer reports. From user browser screen, they see a message "Request Progress - processing your request" without any futher activity.



opmnctl status shows all processes are up and running.

Analysis:

On checking the system performance, we see that the Discoverer Preference Server process dis51pr is consuming very high CPU. On investigating further, we stumble upon a bug “6388696 - DISCOVERER TAKES MORE THEN AN HOUR TO START WORKING AFTER STARTUP”.

The bug states that the Preference server takes a really long time to initialize as it reads all the preferences from the file .reg_key.dc. In our case, this file was more than 3 GB!!

Solution:

As always suggested by support, since we were on the base version, the permanent fix was to apply the cumulative patch. But we chose to go with the workaround, which is to clear the preferences.

Steps to follow:

1. Stop services using opmnctl stopall
2. Back up .reg_key.dc file
3. Run dis51pr –clean
4. Apply preferences
5. Start services using opmnctl startall