Tag Archives: catalog

FOLDERS AND REQUESTS ARE NOT DISPLAYED AFTER UPGRADING TO 11.1.1.3.0.

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.

The OBIEE Dashboard Is Empty After Upgrading From 10g To OBIEE 11g

Applies to:

Business Intelligence Interactive Dashboard – Version: 11.1.1.5.0 [1308] and later   [Release: 11g and later ]
Information in this document applies to any platform.

Symptoms

Recently upgraded Oracle Business Intelligence Enterprise Edition (OBIEE) from 10g to 11g (OBIEE 11.1.1.5).
All upgrade steps were completed as described in the Upgrade Guide for Oracle Business Intelligence
11g; including upgrading the web catalog and repository (RPD).
The repository was checked and there were no errors.
When logging in to OBIEE Presentation server as a user with OBIEE Administrator role, the 11g dashboard is empty and expected content is not present.

Changes

Upgraded from 10g to 11g.

Cause

Insufficient permissions on ‘shared folders.’
The permissions on catalog folder ‘shared folders’ were available only for ‘Authenticated user’ and ‘Presentation Server Administrators’.

Solution

Login to OBIEE Presentation server as WLS or biadmin user and select Administration link ->
add relevant application role e.g. ‘BI Administrator role’ and grant at least read and traverse permissions to the ‘shared folders.’
Also ensure that you tick the check boxes to apply permissions to all items within the folder and sub folders.