Apr 10 2013 0

OBIEE / ODI Lineage

On the site of Rittman Mead there is a post detailing OBIEE Lineage, ODI 11g New Mapping and Interface Features — Part 3 — OBIEE Lineage.

I followed the steps from this post as well as the steps described in chapter 19 of the document Oracle® Fusion Middleware Connectivity and Knowledge Modules Guide for Oracle Data Integrator 11g Release 1 (11.1.1).

During the installation I ran into some issues, basically the installer reported a successful installation while in fact nothing got installed.

Operating System:

  • Windows XP

Oracle software:

  • Oracle RDBMS (11.2.0.1.0)
  • Oracle Business Intelligence Enterprise Edition (11.1.1.6.0)
  • Oracle Data Integrator (11.1.1, Build ODI_11.1.1.6.2_GENERIC_121029.0825)

All the issues encountered could be solved and are described below. So hopefully this information will be helpful to others as well trying to get OBIEE Lineage installed.

Downgrading RPD

ISSUE: Version of the RPD was higher than was supported in my test environment.

SOLUTION: Since my test VM was still running an older version of OBIEE than is used on the development environment, the RPD needed to be downgraded. For downgrading the tool nqgenoldverrpd is available (%OBIEE_HOME%\bifoundation\server\bin\nqgenoldverrpd.exe).

The tool has the following syntax:

nqgenoldverrpd  [-P repository_password] -I input_repository_pathname
                -O output_repository_pathname -V version [-F]

example of usage (downgrade RPD to version 318)

nqgenoldverrpd -P pwd  -I rp1.rpd -O rp1_old.rpd -V 318

ODI-50066: THE GIVEN RPD FILE IS INVALID

ISSUE: The version of lineage that came with the initial download of ODI could not be installed. It was constantly presenting me the error ODI-50066: THE GIVEN RPD FILE IS INVALID when selecting a OBIEE repository.

SOLUTION: To fix this two patches had to be applied to the ODI installation (14037855 and 14493022).

Installing

ISSUE: The installer went through all the steps (you will see a progressing bar pop up a couple of times when RPD actions are performed) and reports successful installation at then end.

Digging into the commands used within the batch file installlineage.bat and executing them manually it turned out that if the password of my own repository is not the same as the password that is used for the artefact repository (odi_repository_archive_11g) the process fails.

SOLUTION: Changed the password of my own repository into Admin123, ran the installation.

Export Metadata from OBIEE and Refresh Lineage

ISSUE: During the step Consolidating the Lineage Metadata’ an error occurred Within our environment we have restricted the privileges granted to the Master Repository user. It has only been granted the privileges CONNECT and RESOURCE.

SOLUTION: Added more privileges to the Master Repository user

GRANT CREATE ANY INDEX TO "MR31_ODI_REPO";
GRANT CREATE ANY TABLE TO "MR31_ODI_REPO";
GRANT CREATE ANY VIEW TO "MR31_ODI_REPO";

Previous post
Mac Mini Mount For my ‘Company’ named Little Gem Software I am using a Mac Mini Server to host its website and handle all the background processes required to make
Next post
Kickstarter Goodies Over the last year I have backed several projects on Kickstarter, eight so far or actually nine. One project didn’t reach the funding goal
This blog is powered by Blot