OBIEE Blog

You have an OBIEE 10.1.3.4.1. instance and a lot of folders and requests for the Administrator user.
You upgrade to 11.1.1.3.0, using the ua.bat tool. It finishes as complete and there are no errors in the the Upgrade Assistant (ua) log files:

 $OBIEE_HOME/upgrade/logs

For example
 C:OBIEE_11gOracle_BI1upgradelogs

In OBIEE 11.1.1.3.0, when you log in as Administrator and go to the Catalog option, you are not able to see any folder or request.

Cause

The upgrade process, ua.bat, is not transferring the folders and request for the Administrator user.

This is due to the bug below

What were you trying to do?
---------------------------
Upgrade both repository and web catalog from 10.1.3.4.1 to 11.1.1.3.0.

What should have happened?
--------------------------
You should be able to see all folders and request you had in 10.1.3.4.1 after
upgrading to 11.1.1.3.0.

What actually did happen?
-------------------------
For the Administrator account, after running the ua.bat for upgrading and
finishing without error, when you log in with this account, it does not
display  any folder or document for the Administrator user in 11.1.1.3.0,
there are a lot of folders and request in 10.1.3.4.1.

What are the symptoms of the problem?
-------------------------------------
You have a web catalog in 10.1.3.4.1. When you log in as Administrator in
this version you see a lot of folders and request for that user.

  You upgrade to 11.1.1.3.0 using the ua.bat utility. It finishes fine,
completed without error. In the upgrade log file you can find some warnings
that I am not sure they are related to this issue. You log in as
Administrator in 11.1.3.0 and you cannot see any folder or request.

What changes have been made to the technical environment recently?
------------------------------------------------------------------
None.
-------------

Suggested workaround is the following:
In 10.1.3.4.1.
 ===============

 1) In Administration Tool, create a new user, 'new_account', under Manage-Security (if you are using other Security option, add the new user there).

 2) Using Catalog Manager, copy the content of the Administrator user into the new one.
 For instance:

 /-users-administrator
 into

  /-users-new_account

 3) Upgrade the Web Catalog using the ua.bat:

In 11.1.1.3.0.
 ==============

 4) Using Catalog Manager, copy the content of the 'new_account' user into the Administrator one.
 For instance:

 /-users-new_account

 into

 /-users-administrator

 5) Connect to OBIEE as Administrator and check you are able to see all folders and requests.