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.

OBIEE 11g: Error: “Server not initialized. Please make sure the repository is ready” When Accessing BI Publisher from OBIEE 11g After Upgrading Repository from 10g to 11g

Applies to:

Business Intelligence Server Enterprise Edition – Version: 11.1.1.3.0 [1905] to 11.1.1.5.0 [1308] – Release: 11g to 11g
Business Intelligence Suite Enterprise Edition – Version: 11.1.1.3.0 [1905] to 11.1.1.5.0 [1308]   [Release: 11g to 11g]
Information in this document applies to any platform.

Symptoms

You have installed OBIEE 11g and upgraded the repository from 10g to 11g.  You log into OBIEE as Administrator and click on the Administration link and then the Manage BI Publisher link.  You get the error:
Server not initialized. Please make sure the repository is ready

Cause

You are missing the privileges Access to SOAP and Impersonate as System User from the  BIAdministrator and BISystem roles.

The BISystemUser communicates with the different components of the OBIEE and when BI Publisher is accessed from answers, it communicates with BI Publisher via SOAP.  The Access to SOAP privilege should be granted to the BISystem role.  Also the Impersonate as System User privilege should be granted to the BIAdministrator and BISystem roles.

Solution

1. Log in to OBIEE 11g with Administrator credentials (superuser in 10g rpd which was upgraded to 11g).

Note: The reason you need to log into OBIEE 11g with Administrator credentials, is because the error is seen only with an upgraded 10g repository.  Also the superuser in OBIEE 11g (the user created at the time of 11g install, the default name of which is weblogic) will not have access to the Administration link with the upgraded repository. See note 1262219.1 for how to add the missing Administration link in OBIEE 11g with the upgraded repository.

2. Click on Administration > Manage Privileges.

3. Assign BISystem or BIConsumer roles the Access to SOAP privilege.

4. Assign Impersonate as System User to BIAdministrator or BISystem role.

Starting OBIEE 11g Server Or Running Requests After Upgrade From OBIEE 10g Fails With Error: “ORA-12504 or ORA-12154″

Applies to Business Intelligence Suite Enterprise Edition – Version: 11.1.1.3.0 [1905] to 11.1.1.5.0 [1308]   [Release: 11g to 11g]

Symptoms

After upgrading to Oracle Business Intelligence Enterprise Edition (OBIEE) 10g to OBIEE 11g, when viewing a dashboard or creating a new analysis in Answers, the following error occurs:

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 17001] Oracle Error code: 12504, message: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA at OCI call OCIServerAttach. [nQSError: 17014] Could not connect to Oracle database. (HY000)
Or you might get the error:

[2010-11-16T06:02:38.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 004_ILDmfHpFw000jzwkno0002Xk0000qx] [tid: 4f353960] [nQSError: 17014] Could not connect to Oracle database. [[
[nQSError: 17001] Oracle Error code: 12154, message: ORA-12154: TNS:could not resolve the connect identifier specified
at OCI call OCIServerAttach.
[nQSError: 43093] An error occurred while processing the EXECUTE PHYSICAL statement.
[nQSError: 43113] Message returned from OBIS.
It looks like all the database connections have been broken.

Another symptom that may occur is that the BI Server does not start up and you get the following error in the nqserver.log:

[ecid: 00hxwa3cUNZ4aq_S9Q2FSx0001SO000000] [tid: 814] [36007] Loading repository E:\obiee11g\instances\instance2\bifoundation\OracleBIServerComponent\coreapplication_obis1\repository\11rpd.rpd.
[2011-01-06T20:20:52.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 00hxwa3cUNZ4aq_S9Q2FSx0001SO000000] [tid: 19b4] [nQSError: 17014] Could not connect to Oracle database. [[[nQSError: 17001] Oracle Error code: 12154, message: ORA-12154: TNS:could not resolve the connect identifier specifiedat OCI call OCILogon.

Changes

Upgraded from OBIEE 10g to OBIEE 11g.

Cause

In OBIEE versions prior to 11g, it uses the database client home tnsnames.ora file to resolve the tnsname. But OBIEE 11g uses the tnsnames.ora file installed within its installation home. The path is
[middleware home]/[oracle home]/Oracle_BI1/network/admin
By default, there are no database tns alias descriptors configured.

Solution

There are three ways to solve this problem:

1. If you just need one TNS alias, then copy the database connection descriptor from database tnsnames.ora file to the tnsnames.ora file under the BIEE directory:

[middleware home]/[oracle home]/Oracle_BI1/network/admin

2. You  may also copy the entire tnsnames.ora file

3. Another alternative is to set the TNS_ADMIN environment varaible which would point to the directory where a tnsnames.ora file is located. This would need to be set as a System Environment variable in Windows or in the command shell if starting from a command-line. For Unix/Linux, it would need to configured in the user profile that owns the software or set explicitly in the shell if starting from the command-line.