[OBIA] Installing BI Applications 7.9.6.4 on BI EE 11.1.1.7.0

 

Installing BI Applications 7.9.6.4 on BI EE 11.1.1.7.0

This document describes how to install Oracle Business Intelligence Applications 7.9.6.4 on Oracle Business Intelligence Enterprise Edition 11.1.1.7.0. It discusses two issues and how to address them.

Issue Summary

This document discusses and addresses the following two issues:

Issue 1 - The Oracle Business Intelligence Application 7.9.6.4 installer fails on Oracle BI EE 11.1.1.7.0 with the error “NQSConfig.INI not found. Please make sure your environment is set up properly”.

Click Here To Download The Patch File

Issue 2 - The Oracle Business Intelligence Application 7.9.6.4 JAZN file is incompatible with BI EE 11.1.1.7.0. This causes authentication failures when a user tries to log in to the Analytics page.

Issue 1: BI Applications 7.9.6.4 installation fails on BI EE 11.1.1.7.0

The BI Applications 7.9.6.4 Installer has been certified with BI EE 11.1.1.6.4 and depends on the BI Administration Tool to generate the OracleBIAnalyticsApps.rpd based on the user’s selection of BI Applications modules.

With BI EE 11.1.1.6.4, Administration Tool could be run by directly invoking the admintool.exe in <ORACLE_HOME>/bifoundation/server/bin. However, with BI EE 11.1.1.7.0, Administration Tool requires specific environment variables to be set that are used internally. Directly invoking admintool.exe gives an error – “NQSConfig.INI not found. Please make sure your environment is set up properly”.

Resolution

Resolution Overview

The BI Server Utilities provides a script calledbi-init.cmd in 
<MW_HOME>\instances\instance1\bifoundation\OracleBIApplication\coreapplication\setup. 
This needs to be run before running Administration Tool in order to set the necessary environment variables.

Running this script first and then running the BIAPPS 7.9.6.4 Installer makes these variables available to Administration Tool and the Oracle BI Applications installation is able to complete successfully.  Details on how to run the BI Applications 7.9.6.4 installer on BI EE 11.1.1.7.0 are described below.
 

Resolution Steps

1. Open a Command Prompt

2. Navigate to  

<MW_HOME>\instances\instance1\bifoundation\OracleBIApplication\coreapplication\setup from the command-prompt and run bi-init.cmd

3. This opens  a new command window with all the necessary environment variables appropriately set.

4. In the newly opened command-window, navigate to the directory where Oracle BI Application 7.9.6.4 Installer has been extracted and run setup.exe

5. Continue with the rest of the steps as prompted by the Installer.

6.  Click Finish. 

 

Issue 2: OBIA 7964 JAZN file incompatible with OBIEE 11.1.1.7.0

The Oracle BI Applications Version 7.9.6.4 installer installs an invalid system-jazn-data.xml file. This file is missing Application Roles for Enterprise Asset Management Analytics and Manufacturing Analytics, and all Application Roles for Version 7.9.6.3. This prevents the implementation of Data level and Object level Security. 

This issue has been documented in the BI Applications 7.9.6.4  Release Notes Guide under section “Application Roles Missing From JAZN File For MFG, EAM, and Application Roles Exist in Release 7.9.6.3”

The correct JAZN policy store file has been provided in Patch 16321623 as documented in the Release Note. However the JAZN file included in this patch is in the BI EE 11.1.1.6.0 format and is incompatible with the BI EE 11.1.1.7.0 release. If you are installing BI Applications 7.9.6.4 on BI EE 11.1.1.7.0 or are upgrading to BI Applications 7.9.6.4 and have upgraded BI EE to 11.1.1.7.0 then you do not have to download and apply patch 16321623. Instead, follow the instructions noted in the section titled “Resolution” below.

Resolution

Resolution Overview

This technical note includes the JAZN policy store (language: English) compatible with the BI EE 11.1.1.7.0 release. This JAZN policy store file has to be deployed manually in BI EE after the BI Applications 7.9.6.4 installation is complete. Details on how to deploy the JAZN are described below.

NOTE:

This technical note does not include the JAZN policy store files for non-English languages. The JAZN policy store files for non-English languages are available in Patch 16753874 (BI APPS 7.9.6.4 ON BI EE 11.1.1.7.0: UNABLE TO LOGIN TO ANALYTIC PAGE (Patch)) under the Patches and Updates tab of My Oracle Support

Resolution Steps

To deploy the system-jazn-data.xml included in this technical note:

1.    Shutdown all processes in the BI EE system including the following:-

1.1. Administration Server and all managed servers in the cluster (if any)

1.2. All OPMN managed processes

2.    Backup and rename the existing $DOMAIN_HOME/config/fmwconfig/system-jazn-data.xml.

For example, if the BI EE root folder is named OracleBIEE11g, then the domain folder location (on Windows) might be C:\OracleBIEE11g\user_projects\domains\bifoundation_domain\config\fmwconfig.

3.    Copy the Oracle BI Applications system-jazn-data.xml file from this Tech Note and paste in location $DOMAIN_HOME/config/fmwconfig.

4.    Start all the processes in the BI EE system including the following:

4.1. Administration Server and all managed servers in the cluster (if any)

4.2. All OPMN managed processes

Note:

If you are upgrading from earlier BI Applications versions and if you have added custom application roles to the policy store in the existing installation from which you are upgrading then, you may have to migrate the custom application roles from the existing policy store. Please refer to section “Migrating Policies with migrateSecurityStore” in “Oracle ® Fusion Middleware Application Security Guide” for more details.