Error: Unable to access Oracle Data Integrator repository. You will not be able generate or execute load plans.

Oracle Data Integrator (ODI) Logo

Upon logging to the Oracle Business Intelligence Application’s Configuration Manager system I was greeted with an error message stating the following: “Unable to access Oracle Data Integrator repository. You will not be able generate or execute load plans.”

 

Upon some triage I was able to determine a couple of possible root causes to my issue.

 

  1. Not using the BIAdmin user created during the install process, or, the BIAdmin user account was not created.
  2. Current session was initiated with a set of credentials that haven’t been granted the BIA_ADMINISTRATOR_DUTY  role on weblogic security
  3. Additional roles are missing or not assigned to the credentials initiating the current session

 

After reviewing all possible options and confirming I am using a valid account with the proper roles and permissions I asked my system administrator to restart the server, this fixed my issue. I should have started there but at least I came out of the experience with a better understanding of the roles that control security in my installation of OBIA 11.1.1.7.0.

 

Last resort, if all else fails:

* Make sure after you have regenerated and moved the security files that the file odi.conf is updated to refer to jps-config-jse.xml.

How to define an index on a source or target table in ODI

Oracle Data Integrator (ODI) Logo

 

 

 

 

 

 

 

 

 

 

The topic of indexes in Oracle Data Integrator (ODI) is an easy one once you learn your way around in ODI studio. Indexes are defined under Design > Models > [your model] > [Table] > [Constraints]. They are independent of the column definitions for the most part although they do reference valid column definitions.

 

  • The first step to create metadata for an index is to add a new constraint and name it:image

  • On the Columns tab define the list of columns to be indexedimage

  • Ensure that the index is active and marked for creation on the database on the Control tabimage

  • Review all additional options on the Flexfields tab, for some of the options such as Index Type you do need to manually type your selection.
    image

 

 

After you have defined an index on metadata you need to run a new load for the index to be created on the database.

 

My Tools:

Oracle Business Intelligence Applications (OBIA) 11.1.1.7.0

Oracle Data Integrator 11g (ODI Studio, ODI Server, no clustering)

 

Customizing your DOS prompt

Being back on a windows shop I find the DOS prompt sort of gets in my way, I have customized it so that it will display my current path and then let met type on a new line with this command:

PROMPT Ignacio’s rocking at $P$G$_

The different formatting options for the command are:

$A & (Ampersand)
$B | (pipe)
$C ( (Left parenthesis)
$D Current date
$E Escape code (ASCII code 27)
$F ) (Right parenthesis)
$G > (greater-than sign)
$H Backspace (erases previous character)
$L < (less-than sign)
$N Current drive
$P Current drive and path
$Q = (equal sign)
$S (space)
$T Current time
$V Windows XP version number
$_ Carriage return and linefeed
$$ $ (dollar sign)

To make your changes permanent go to My Computer > Properties > Advanced > Environment Variables and create a new variable called PROMPT.

If you find this post useful please or Share our site!

Being back on a windows shop I find the DOS prompt sort of gets in my way, I have customized it so that it will display my current path and then let met type on a new line with this command…

How to Make sure an index is defined as unique in odi

Oracle Data Integrator

Indexes are defined as constraints on the Model view in ODI Studio. To make a field unique follow one of the two alternatives listed below.

 

PRIMARY KEY

 

Define the Index as a Primary Key constraint object on the Models area within the design view

Description view on primary key index definition in ODI

 

Add the unique columns on the Columns tab

image

 

 

In the Control tab make sure the constraint is active and marked to be defined in the database for both flow and static control checkboxes

 

 

 

image

 

Review that the correct settings are configured in the Flexfields tab

Flexfields view on Primary Key Index in ODI

 

ALTERNATE KEY

 

Define the constraint object for your table as an alternate key in the ODI models area

Defining a unique index in Oracle ODI

 

Add the unique columns on the Columns tab

image

 

In the Control tab make sure the constraint is active and marked to be defined in the database for both flow and static control checkboxes

 

image

Review that the correct settings are configured in the Flexfields tab

Flexfields view on unique index in ODI

How To: Download, install, configure and verify you have the latest version of Opatch

On this post we will discuss all the steps necessary to ensure you have the correct version of the OPatch patching utility for oracle software running on your system. If you find this post useful please or Share our site!

Environment Variables:

Set your ORACLE_INSTANCE path to a valid OBIEE 11g instance

Set your ORACLE_HOME path to the OBIEE 11g home (Oracle_BI1)

Validating Your Environment:

OPatch is installed by default, locate it go to the ORACLE_HOME path for your OBIEE installation:

\Oracle_BI1\OPatch

To verify your current session is correctly configured verify the installed version by running the following command:

opatch version

Minimum Required Versions:

OBIEE 11.1.1.5.0 -> OPatch version 11.1.0.8.3 or higher (do NOT use OPatch 12.x)

OBIEE 11.1.1.6.0 -> No OPatch packages available as of March 12, 2012

Downloading a Newer Version of OPatch:

To find and download the appropriate version of OPatch for yor system please go to ORacle Support and find the knoledge base article below:

Note 224346.1 – Opatch – Where Can I Find the Latest Version of Opatch?

Installing OPatch:

To install OPatch once you have downloaded the appropriate version follow the steps below:

  1. Rename your current OPatch directory (ORACLE_HOME\OPatch)
  2. Copy the zip file to your ORACLE_HOME
  3. Unzip the zip file
  4. Verify that the upgrade succeeded

    cd OPatch
    opatch version

File System Access:

OPatch will update the local Oracle Inventory so the user account running OPatch must have acces to the location of the OUI Inventory, to verify this you can run the following command:

opatch -lsinventory

Patch Directory Location (PATCH_TOP):

If you have a centralized location where you store code / releases it is a good idea to create a directory called PATCH_TOP to store patches as they are applied to each environment (DEV, QA, STAGE, PRD).

On this post we will discuss all the steps necessary to ensure you have the correct version of the OPatch patching utility for oracle software running on your system.

Configuring the windows host file to correctly use the loopback adapter for Oracle product installations

This procedure is required when installing Oracle products such at the Oracle Database or Oracle Business Intelligence Enterprise Edition on a host machine that uses DHCP.  Follow the steps to configure a loopback adapterand then:

  1. Open the host file under c:\windows\system32\drivers\etc using notepad
  2. Identify your computer’s host name by right clicking on My Computer, selecting properties and clicking on the computer name tab Identify your computers host name by right clicking on My Computer, selecting properties and clicking on the computer name tab
  3. On the first line of your host file add a link between the static IP address you assigned your loopback adapter and your computer’s host name, for example: # IP                 hostname.domain        hostname 10.10.10.35    virtualXP.acme.com virtualXP
  4. On the second line associate the same static IP with the localhost default alias, for example: 10.10.10.35 localhost.localdomain    localhost

Once you have completed these steps you can proceed with the next steps in your Oracle product installation. If you find this post useful please or Share our site! This procedure is required when installing Oracle server products such at the Oracle Database or Oracle Business Intelligence Enterprise Edition on a host machine that uses DHCP.  Follow the steps to configure a loopback adapter and then the steps outlined on this article…

How to stop / start individual OBIEE 11g System Components from the OPMN

obia-tech-components-wd
Sometimes I have a configuration change to make or need to restart a specific system component in one of my servers, here is a list of stop / start commands for each of the system components:

BI Service:

opmnctl stopproc ias-component=coreapplication_obis1

opmnctl startproc ias-component=coreapplication_obis1

Javahost:

opmnctl stopproc ias-component=coreapplication_obijh1

opmnctl startproc ias-component=coreapplication_obijh1

Presentation Service:

opmnctl stopproc ias-component=coreapplication_obips1

opmnctl startproc ias-component=coreapplication_obips1

Scheduler Service:

opmnctl stopproc ias-component=coreapplication_obisch1

opmnctl startproc ias-component=coreapplication_obisch1

Cluster Service:

opmnctl startproc ias-component=coreapplication_obiccs1

opmnctl stopproc ias-component=coreapplication_obiccs1

If you find this post useful please or Share it!

Sometimes I have a configuration change to make or need to restart a specific system component in one of my servers, here is a list of stop / start commands for each of the system components…

How to: Install the Oracle Web Tier / Oracle HTTP Server

This post will guide you through the steps to deploy Oracle Web Tier 11.1.1.2.0. This instance will later be upgraded to 11.1.1.5.0 by applying PatchSet 1 (12395155) and configured to serve as a front end for WebLogic as part of an Oracle Business Intelligence environment. If you find this post useful please or Share it!

Pre-Install Tasks

Implementation

  • Run the setup.exe file to start your installation
  • Click next on the welcome screen

    Click next on the welcome screen

  • Select the Install and Configure option and click next

    Select the Install and Configure option and click next

  • Verify that all pre-requisite tests are successfull and click next

    Verify that all pre-requisite tests are successfull and click next

  • Specify the location of your oracle middleware home and the name of your new web tier oracle home directory

    Specify the location of your oracle middleware home and the name of your new web tier oracle home directory

    Note: The WebLogic server must already be installed in the same middleware home you specify.

  • Select to configure instances of Oracle HTTP Server and Oracle Web Cache, also select to associate these components with your weblogic domain

    Select to configure instances of Oracle HTTP Server and Oracle Web Cache, also select to associate these components with your weblogic domain

  • Enter the host name and port of your weblogic domain and then enter the domain’s admnistrator credentials

    Enter the host name and port of your weblogic domain and then enter the domain's admnistrator credentials

  • Confirm the instance name, location and component names and click next

    Confirm the instance name, location

  • Enter a password for the administrator of your new web cache instance

    Enter a password for the administrator of your new web cache instance

  • Allow the installer to perform automatic port configuration using the default port numbers for services

    Allow the installer to perform automatic port configuration using the default port numbers for services

  • Provide your Oracle Support credentials, this will register this instance so that it will be available for support and, if specified, allow you to receive security updates via e-Mail

    Provide your Oracle Support credentials, this will register this instance so that it will be available for support and, if specified, allow you to receive security updates via e-Mail

  • Review theconfiguration presented in the summary screen is correct and click Install to begin the process.

    Review the configuration presented in the summary screen is correct and click Install to begin the process.

  • Review the information on the completed install progress screen, make a note of the install log location and click next.

    Review the information on the final summary screen, make a note of the install log location and click next.

  • Review the information presented in the final summary screen, make a note of component urls and click finish to finalize the initial install and configuration process

    Review the information presented in the final summary screen, make a note of component urls and click finish to finalize the initial install and configuration process

Configuring a new loopback adapter in windows


  1. Start > Control Pannel> Add  Hardware
  2. Click next on the Welcome screen
    Click next on the Welcome screen
  3. When ask if you have connected your hardware, specify yes
    When ask if you have connected your hardware, specify yes
  4. In the next dialog select Add new hardware device
    In the next dialog select Add new hardware device
  5. On the following screen select Network Adapters
    On the following screen select Network Adapters
  6. Select Microsoft > Microsoft Loopback Adapter from the list
    Select Microsoft > Microsoft Loopback Adapter from the list
  7. Select next in the following screen to install your loopback adapter
    Select next in the following screen to install your loopback adapter
  8. Click finish to complete this section of the installation process
    Click finish to complete this section of the installation process
  9. Find your newly created adapter by going to Start > Control Panel > Network Connections
    Find your newly created adapter by going to Start > Control Panel > Network Connections
  10. Right click your new connection and select Properties
  11. Select the Internet Protocol on the second section of the screen and click properties
    Select the Internet Protocol on the second section of the screen and click properties
  12. In the IP properties dialog configure a static IP address following the example belowIP Address: 10.10.10.35 Subnet Mask: 255.255.255.0
    In the IP properties dialog configure a static IP address following the example belowIP Address: 10.10.10.35 Subnet Mask: 255.255.255.0

Once you have configured a static IP address you will have completed the configuration of your new loopback adapter.

For instructions on configuring your hosts file to correctly use your loopback adapter when installing Oracle products see this post.

If you find this post useful please or Share our site!

This short reference article will guide readers through the configuration process for a loopback adapter, this is a pre-requisite for most Oracle server software installs…

ODI Error: ora-00001–unique constraint ( pk_pop ) violated

SYMPTOM:

 

image_thumb1

odi-10182: Uncategorized exception during repository access

ora-00001: unique constraint ( pk_pop ) violated

 

CAUSE:

 

There is another interface with the same name on the repository.  Interface names are unique and independent of their folder location. In my case I had an interface with the same on a different folder.

 

SOLUTION:

 

Rename or delete your duplicate interface.