Re: How to migrate user preference in discoverer

Posted by ErmanArslansOracleBlog on Aug 26, 2020; 2:01pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/How-to-migrate-user-preference-in-discoverer-tp8677p8693.html

It is documented in Oracle Support and you said that you did exactly what is documented..

Ok, I will try a little bit more..

Look we have 2 facts ->

*You can change the default preference values that Discoverer end users are presented with by changing the values in the pref.txt file. For the changes to take effect, you must 'apply' the preferences. For more information about changing default preference values

*You can change an individual user's preferences using the Discoverer preferences command line utility. Changes that you make are stored in the reg_key.dc file (for more information about changing individuals users' preferences

Anyways, Did you check the Oracle® Business Intelligence Discoverer Configuration Guide 10g Release 2 (10.1.2.1) ?

I don't know the history of your source instance, so maybe the user prefences were not changed there.. maybe the default values were changed there. I mean maybe the pref.txt in your source was changed and this way you got the user preferences updated in your source..

If thats the case, your focus should be activating the changes in pref.txt in your target env
And if so , you may need to use applypreferences script.

Here is the statement from the Configuration gude;

After editing the pref.txt file, you must run the applypreferences script to
apply the preference changes you have made, then stop and restart the Discoverer
Service .

Also look at the definition of pref.txt  -> This file stores the Discoverer middle tier preferences, and is used to generate the reg_key.dc file. If you manually edit the pref.txt file, you must run the applypreferences script to apply the preference changes you have made, then stop and restart the Discoverer preferences server component.

So running applypreferences script may be a good idea in any case. ( on the target server ofcourse) -- ofcouse backup your reg_dc file before running the script)