Tag Archives: 11g

Few 11g questions I found in the support log

A few useful things I found about 11G.

1.

Goal

In OBIEE 11g there is no link on the homepage for “Oracle Answers” like there was in the 10g version. Where is it or how to get it to appear?

Solution

BIEE 11g has been re-engineered in 11g, especially with the inclusion of WebLogic in the mid tier. A new look and feel is displayed from the 10g version. Now when connecting in 11g BIEE, you basically see Answers.

On the main 11g page, some of the latest Dashboards and Reports that have been created are displayed, plus there are still links to create a new report or open another dashboard.

So it is more a look and feel (cosmetic) change than anything else as the same functionality exists in both versions.

2.

Symptoms
In OBIEE Presentation Server log, you may see the following warning messages:

11g xml data incompatibility: object [some object type] at [the object path] requires upgrade. Admin needs to rerun upgrade, or remove the object, or fix the object’s xml manually. If problem persists, please contact technical support
Cause
========
Reason
========

Customers did not run catalog upgrade from the previous 11g version to the current version. Therefore, we have to upgrade it at run time in memory without saving it (if the catalog is upgraded through upgrade process, it will be upgraded and saved permanently in the catalog.) We give this warning message to warn customers that it is recommended to perform the catalog upgrade otherwise the application will need to perform the upgrade in memory.

Solution
The resolution for the issue has been documented. It is suggested to use the following:

Please refer to section: 3.8.10.2 Updating Oracle Business Intelligence Catalogs in
Oracle® Fusion Middleware Patching Guide 11g Release 1 (11.1.1.5.0). Here is the link to the documentation.

Oracle® Fusion Middleware Patching Guide 11g Release 1 (11.1.1.5.0)

The following bug has been logged to address the issue

Bug 12911878 – ERROR “11G XML DATA INCOMPATIBILITY” WHEN MOVING FROM 11.1.1.3 TO 11.1.1.5

Applies to:
Business Intelligence Server Enterprise Edition – Version: 10.1.3.4.1 [1900] to 11.1.1.5.0 [1308] – Release: 10g to 11g

3.

Symptoms
You are upgrading OBIEE 10g to OBIEE 11g using the Upgrade Assistant.  You have upgraded the repository successfully, but when you upgrade the web catalog, you get the following error:

[2011-03-09T13:38:25.565-05:00] [BIEE] [ERROR] [] [upgrade.BIEE] [tid: 13] [ecid: 0000IuRtnAxFw000jzwkno1DTwWL000004,0] javax.management.RuntimeMBeanException: Cannot refresh – Currently locked[[
at oracle.as.jmx.framework.standardmbeans.spi.OracleStandardEmitterMBean.doInvoke(OracleStandardEmitterMBean.java:897)

Cause
There is a lock on the web catalog in Enterprise Manager.

Solution
1. Search through Enterprise Manager and release any locks.
2. Stop and re-start Weblogic and the managed servers.
3. Start Upgrade Assistant and try upgrading the web catalog again.

Errors and warnings after upgrade to 11G from OBIEE 10g

If you are going to upgrade to from 10g to 11g soon, you should consider the following issue :

Why Does The OBIEE 11g Consistency Check Show Errors And Warnings After An Upgrade That Did Not Occur In 10g?

The goal is to understand why an OBIEE repository (RPD) that completed an error and warning free consistency check in 10g, results in many warnings or errors when the RPD is upgraded to 11g and a consistency check is executed.

A wide range of errors and warnings have been seen.  A few examples have been copied below; however, many other errors or warnings could show after the upgrade.

For example:

Error: The content filter of a source for logical table: Fact response details references multiple dimensions. [nQSError:15001] Could not load navigation space for subject area Test_Area

Error 38126 Object Type: Logical Level
Logical Level “XyZ”.”123″ .. has name with leading or trailing spaces

Error 15004 Object Type: Business Model
Internal Error: Missing functional dependency association for colum 5: X_TABLE.ROW_ID
[nQSError: 15001] Could not load navigation space for subject area Test_Area.

Error 38079 Object Type: Physical Foreign Key
Foreign Key “ABC.123″….
FKey#2 A comparison is being carried out between non-compatible types

Warning: Fact table is not joined to logical dimension table. This will cause the problems when extracting project(s).

Warning: Missing Functional dependency association for column:

Oracle’s reply was:

In general with each release, the consistency checker is enhanced  to improve the consistency rules and to correct consistency checks that may not have been occurring in a previous release, but should have been.  Therefore, it is common and expected for each major release upgrade that you will see additional consistency check errors or warnings that you did not see in a previous release.

The majority of consistency check  errors and warnings that show in 11g but did not show in 10g are legitimate and represent a RPD design issue. The goal of these warnings and errors is to enforce RPD design rules and each one should be investigated and addressed as these could cause additional issues.

It is also advisable if you are in ‘online’ mode to check the nqserver.log from the BI Server to ensure you are correcting all the errors associated with a particular Subject Area and/or consistency check issue.

The default location will be here (assuming default instance name).

[middleware_home]/instances/instance1/diagnostics/logs/OracleBIServerComponent/coreapplication_obis1

My advice is to make a good contingency plan, including roll-back possibility along with full regression testing (which can be tricky in OBIEE).

 

11G posts coming up soon

Good evening,

I hope everyone’s month is going well in the BI world. I’m having a real difficult time fighting word press blog spam. I’m currently using Akismet but please let me know if you find a better way to manage it. It’s so bad that I’m about to disable commenting system.

I’m going to start a whole section dedicated to version 11G. I’m thinking of covering version 11.1.1.5

I think topics such as Installation, Configuration, Deployment, New Modelling techniques, as well as Security. From what I see, it’s a very application (I suspect the whole codebase has been re-written). I’m going to try to follow a systematic approach and to make a good care of categorization.

Please let me know if you’d like me to cover any special area.

Sample 11g Application – very nice

Sometimes thoughts materialize – in this case, I was thinking – wouldn’t it be great if Oracle provided a configured instance of OBIEE 11G – with everything pre-configured so that it’d be easy to get evaluate it quickly without going through the pains of learning new application server (Weblogic) and installation steps.

It seems as I was heard. I’m grateful to several people making me aware of the new app:

If you want to learn and play with sample OBIEE 11g, you should download it from http://www.oracle.com/technetwork/middleware/bi-foundation/obiee-samples-167534.html

Installation is breeze. I’ve managed to installed everything in under 1 hour (downloading 25gb takes a few hours)

Again, I think it’s very thoughtful and smart move on Oracle’s part to provide this tool.