Re: How to migrate user preference in discoverer
Posted by soumya on Aug 29, 2020; 2:10pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/How-to-migrate-user-preference-in-discoverer-tp8677p8704.html
Hi Erman,
Good evening.
We have finally resolved the user preference issue! The user preference was not replicated because of different database sid. The target dataabase which we were connecting is a clone of source database but has a different sid. Now .reg_key_dc file has entry like oracle database sid \ <username>
Source database
[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\WebDisco 10\Userpreferences\prodtest\SYSADMIN\Database]
Target database
[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\WebDisco 10\User Preferences\prod\SYSADMIN\Database]
Now here if we connect to the source database from the cloned discoverer instance we can see the user's preference correctly. Where as if we connect the target database from target discoverer instance we are not able to see because the reg key has entry which is validated for prod database only not for prodtest.
I thank for heartily for all the help. Keep up the good work.
Regards,
Soumya