FOLDERS AND REQUESTS ARE NOT DISPLAYED AFTER UPGRADING TO 11.1.1.3.0.

OBIEE 11g Upgrade Assistant (UA) Fails When Upgrading A 10g RPD File To OBIEE 11g
July 8, 2012
Values In OBIEE 10g Multiselect Prompt Are Not Sorting in Alpha-Numeric Order In Large LOVs
July 28, 2012
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_11g\Oracle_BI1\upgrade\logs

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:
$ORACLE_HOME/bin/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.

Leave a Reply