Monday, November 19, 2012

"Exception occured when saving user preferences to the catalog access denied for user to path /users//_prefs/userprefsxmlstore

Hi Friends,

I recently stumbled upon two issue

1) OBIEE 11g: Error: "Exception occured when saving user preferences to the catalog access denied for user to path /users/<username>/_prefs/userprefsxmlstore.

When one of my user is trying to setup Delivery preference as shown below.


2) When users login to OBIEE they are not able to see their "My Folders" etc.


I navigated to the "Catalog">Root>users>  and observed that upgrade assistance not able to copy the same user folder permissions from 10G to 11g(Bug)....


Solution 1:  Delete the user folders .... When users login again System will recreate the folder again.

 Drawback of this method is if user's have any reports  in their my folders in10G. They will get deleted.

Solution 2  :1) Using catalog Manager , Go to each user's folder,
                  2)Right click-Permissions: Full access to to the user and apply it recursively.
                  3) Right click-Properties, and set the Ownership to the user and apply it recursively.

All my two issues were resolved.

Happy upgrading and Happy holiday's Friends.....


Thanks
Venkat











No comments:

Post a Comment