OBIEE BUNDLE PATCH 11.1.1.7.140114 (11.1.1.7.4) is available


Bugs fixed in this patch:

14808620: ONLY THE FIRST PRESENTATION VARIABLE IS PASSED TO THE DATA MODEL ENGINE

16281542: ONLY FIRST REPORT’S TEMPLATE USED FOR ALL REPORTS WHILE PREVIEWING THEM

16297877: APP-FND-02938 MULTI-ORGANIZATION ROUTINE FAILED WHEN SELECT A RESP IN MYACCOUNT

16310357: BI PUBLISHER: REPORTS ARE SCHEDULED TO RUN EVERY 2 WEEKS BUT RUN EVERY WEEK.

16410081: REPORT JOB HISTORY 50+ OUTPUTS SHOW DISABLED XML DATA FOR ALL RECORDS AFTER PREV

16432999: XLIFFUTILITY NOT FINDING THE CORRECT STRING IN A SERIES OF FO:INLINE ELEMENTS

16456421: MEMORY PROBLEMS IN FOPROCESSOR WHILE HANDLING LARGE NESTED TABLE

16596837: BIP DATA MODEL FAILS TO LOAD DATA FOR A DATA SET BASED ON XML WITH UTF-8 CHARSET

16703527: ANCHOR TWO PIVOT TABLES SO THEY APPPEAR SIDE BY SIDE IN RTF TEMPLATE IS FAILING

16703847: ACC:IE8 ENTER DOES NOT SELECT FLOATMENU HIGHLIGHTED ENTRY

16738602: PERMISSION SETTING NOT DISPLAYED PROPERLY IF MOR THAN 31 ROLES

16799504: SENDING LARGE FILES TO ORACLE CLOUD SERVER REMOVES .PART EXTENSION

16883295: BI PUBLISHER PARAMETER NAMES TRANSLATION NOT RETAINED ON REPORT REFRESH

16927933: OPENING REPORT JOBS PAGE RESULTS IN “ERROR GETTING HISTORY DATA

16941726: RESENDING A REPORT AS FTP FROM THE JOB HISTORY PAGE FAILS

17012912: AFTER APPLYING OBIEE BP1 PATCH, BI PUBLISHER STOPS WORKING

17044556: APPS – UPLOADING DATA MODEL THROWS ERROR BUT UPLOADS ANYWAY WITH INVALID DATA

17170265: UNDEFINED DISPLAYED AFTER SELECTING DATA/TIME IN SCHEDULE PAGE

17188515: BI: URLXMLPSERVER->ADMINISTRATION->SERVERCONFIGURATION->APPLY THROWS ERROR 500

17205272: 348 DIFFS IN LATEST BIPUBLISHER MAIN LABEL (130721.0533)

17209639: PREFERENCES SET FROM ANALYTICS NOT TAKING EFFECT FOR BIP

17216456: JAVA.LANG.ARRAYINDEXOUTOFBOUNDSEXCEPTION WHEN SWITCHING TEMPLATES

17251779: PARAMETER SEARCH DOESN’T WORK CORRECTLY

17291016: PROBLEMS WITH USING ORACLE BIEE DATASOUCE IN BIP DATA MODEL

17395283: BIP REPORT JOB DOES NOT SHOW CORRECT STATUS

17467379: SCHEDULED BIP REPORTS STUCK IN RUNNING STATUS, CALLBACK FAILURE TO ESS

17510819: FO FILE WITH 2 LARGE NESTED TABLES CAUSES EXTRA SHEET FOR XLSX

17566480: BIP FA – SFTP DELIVERY FAILS DUE TO JAVA.LANG.NULLPOINTEREXCEPTION

17608990: ESS MANAGE JOBS SCHEDULE FREQUENCY SHOWS ERROR FOR EVERY REPORT SCHEDULE

17696750: SPINNING IN QUERY BUILDER FOR PARSING COMMA POSITIONS

BISERVER

Bugs fixed in this patch:

11884377: E_ADFGATEWAY_UIHINTSQUERYERROR MUST NOT BE A FATAL ERROR

14711397: NEED UTILITY TO UPGRADE PREVIOUSLY INSTALLED DATA DIRECT DRIVERS

16230685: SLEAF ON ESSBASE GIVES ERROR- TARGET DATASOURE DOES NOT SUPPORT THE FUNCTION

16291580: RSUM FUNCTION GIVING THE WRONG VALUE

16384360: CREATING ESSBASE REPORT RESULTS IN ODBC ERROR

16404175: ADMINTOOL VIEWMEMBER/UPDATEMEMERCOUNT FAILS ON LEVELS FROM MULTI-HIERARCHY DIM

16612385: INCORRECT DATA IS OUTPUT WHEN USING SJIS ORACLEDB DATA SOURCE ON HP-UX

16674418: PROBLEM TURNING OFF SUBQUERY FILTERS DISABLE_SUBQUERY_CACHE_SEED=1, DISABLE_SUB

16740955: GRAND TOTALS ARE INCORRECT WHEN FILTERS APPLIED ON PIVOT TABLE

16977559: INTERNAL ERROR QUERYING MULTIPLE DIMENSION SOCPE ALIASES ONLY ON THE SAME DIM

16997189: PHYSICAL QUERIES GENERATED BY BI SERVER HAVE A SYNTAX ERROR

17155043: RANK() FUNCTION FOR NULL VALUES BEHAVING DIFFERENTLY BETWEEN 10G AND 11G

17185641: ONLINE CHECKIN LOCK ISSUE: SUVERIFY(COLOCK_ISSET(VALUE)) FAILURE

17314851: FIX FOR BUG 17314851

17384730: ADD HOSTNAME TO NODE_ID COLUMN OF USAGE TRACKING TABLES OF OBIEE

17437777: ADF_BUNDLE VARIABLE IS NOT RESOLVED WHILE RUNNING QUERY FROM ISSUESQL URL

17456520: CRASH IN NQSSERVER (SEGMENTATION FAULT)

17550496: XSD FILE IN 11.1.1.7.3 IS OUT OF DATE

17537464: PREFLIGHT:REL8:SALESCOMP BI DASHBOARDS ARE NOT SHOWING UP DUE TO INCORRECT PARTY

17579731: OTBI:REL7UPG: CUSTOM GOALS CREATED/NOT CREATED REPORT ERROR

Presentation Services
Bugs Fixed By This Patch
14110065: PERCENTAGE VALUES EXPORTED TO EXCEL AS CUSTOM DATA TYPE

14115628: TABLE VIEWS ARE STRETCHED WHEN USING PRINTABLE PDF OPTION

14126454: SOME CELLS GOT MERGED AFTER EXPORTING REPORT FROM 11G TO EXCEL, 10G IS FINE.

14226889: REMOVE GDVARIANT FROM DL API AND USE NATIVE DATA TYPES

14278050: UNABLE TO APPLY CONDITIONAL FORMAT FOR COLUMN HAVING CASE STMT IN GRAPH PIVOTED

14478665: UNABLE TO EDIT ANALYSIS WITH SELECTION STEPS WHEN SELECTED VALUES ARE RELOADED

14527683: BUBBLE CHART WITH CONDITIONAL FORMATTING ON CASE STATEMENTS SHOWS ONLY ONE COLOR

14646338: WHILE EXPORTING TO EXCEL SCALE NUMBERS ON THE HORIZONTAL AXIS OVERLAP

14768894: AXIS TICKS AND INTERVALS NOT SHOWING ROUNDED DOLLAR AMOUNTS

14781615: UNION SORT IS NOT WORKING ON TABLE VIEW

14794470: ALIGNMENT ISSUE ON EXPORT DASHBOARD WITH CELLS HAVE BOTH IMAGE&TEXT TO EXCEL

15976799: ASSERTION FAILURE ERROR WHEN HAVING GROUP BY SET IN ADVANCED TAB

16025137: ODBC ERROR AFTER SETTING A DESCRIPTOR ID COLUMN

16031545: DISPLAY COLUMNS SHOULD BE AUTO FILLED WHEN EDITING PRESENTATION LEVEL

16064049: CHROME/SAFARI: NOT ABLE TO DND COLUMN IN PIVOT

16103936: GRAND TOTAL NOT DISPLAYED WHEN MULTIPLE GROUPS ARE USED IN ANALYSIS

16368595: CHARTS SOMETIMES DISAPPEAR WHEN UNDO DRILLS ARE CLICKED

16446150: CRASH IN PDF PRINT

16490855: HIGH RESPONSETIME IN SAWSERVER FOR 28K ROW/69COL EXCEL DOWNLOAD TEST

16545327: ERROR MESSAGE NOT SHOWING WHILE UPDATING COUNTS FOR SEGMENT IN OBIEE 11.1.1.6.7

16576787: EXCEL EXPORT: CELLS SHIFTING IF THE DIMENSION/S ARE USED IN PIVOT SECTIONS.

16613671: PRIVILEGES IN WEB CATALOG FOR USER POPULATION – CAN LIST USERS REAPPEARING

16656067: GRAPH NOT RENDERED CORRECTLY WHEN USING A CUSTOM LOCALE

16725115: EXCEL: TURN OFF THE WRAP TEXT FOR COLUMN NAME FOR A PIVOT TABLE HAVING IMAGE

16757820: EXCEL 2007: PLEASE ADD A LINE SPACE IF A EXCEL CONTAINS MULTIPLE VIEWS

16758207: ACCESS DENIED IN DASHBOARD EDITOR AFTER COPYING WEBCAT FOLDERS FROM DEV TO SIT

16769606: WRITEBACK FOR DATE/TIME FIELD FAILS: JAVASCRIPT ERROR ‘DATETIMEPARSER’ UNDEFINED

16775374: EXPORT TO EXCEL 2K7: REDUCE THE SAW TEMP FILE SIZE

16820210: INVALID ALIAS FORMAT ERROR TABLE_NAME.COLUMN_NAME REQUIRED CASE STATEMENT SPLIT

16848479: SELECTION STEP “OVERRIDE WITH PROMPT” OPTION NOT WORKING ON DASHBOARD LOAD

16855300: USER FOLDERS GETTING DELETED DURING CATALOG VALIDATION USING REPORT OPTION

16908177: RACE CONDITION IN VIEWSTATEMANAGER GETCURRENTSTATEPATH

16919851: TABLE VIEW WITH OTHER VIEW MERGES EXCEL COLUMNS

16921100: BI EXTENDER DOES NOT DELETE FOLDER FOR BI DISABLED SEGMENT

16932974: PROPERTIES OF A THE CUBE TABLE “ALIAS” IS GRAYED OUT IN 11.1.1.7

16936249: EQUALIZERPDS/ADMINTOOL DOES NOT UNEQUALIZE ALL ALIAS COLUMNS IN CERTAIN CASES

17025157: BIP REPORT PARAMETERS MISSING IN DASHBOARD WHEN IT IS EMBEDDED AS LINK

17044720: ONLINE ADMIN CONSISTENCY CHECK DOES NOT FIX HIDDEN ERRORS

17046235: DECISION FILE PRODUCED BY PATCHRPD AND ADMINTOOL ARE NOT THE SAME

17199003: SORT AND SHOW ALL ROWS HAS CHANGED BEHAVIOUR BETWEEN 10G AND 11G

17241840: NULL VALUES REPLACED WITH 0 THROUGH CONDITIONAL FORMATTING

17273335: HIERARCHY PROMPT DEFAULTS TO CATALOG VIEW IF SPECIFIC ITEMS ARE SELECTED.

17272558: 44% TIME IN FORMATENGINE::EVAL/REPORTFORMATTINGRULE::CHECKRULE()

17272572: TOO MANY CALLS TO GETDATAMETADATA() FOR OBIPS EXPORT

17284134: NEED TO OPTIMIZE REMAINING GETDATAMETADATA CALLS FOR EXCEL EXPORT

17291877: MODIFY THE POLLING CODE IN ORDER TO BYPASS APACHE CACHE

17291926: REMOVING SAXPOSTPROCESSOR FOR EXCEL EXPORT

17320304: REL8 WEBCAT UPGRADE FAILS WITH ANALYTICS DATA LOAD LEADS EXAMPLE SAX PARSER EXC

17336119: RUNNING NQSQUERYMETADATAOBJECTS TRUNCATING CONTENT IN OUTPUT

17346561: CREATE PATCH IS THROWING NUMBERFORMATEXCEPTION

17352466: ACTION LINKS ON KPI WATCHLISTS DO NOT SHOW AS UNDERLINED

17377225: NEED TO OPTIMIZE CONDITIONAL FORMATTING FOR EXCEL EXPORTS

17405023: 17% OF CPU WAS SPENT ON STRING:: EQUAL()

17419116: FOLDER CAPTION EXTRACT DOES NOT SKIP THE FOLDERS AS EXPECTED

17425640: USING OLD C CASTING STYLE CAUSES ISSUES IN QDRXML::LOADMEMBERS()

17433563: LOGICAL SQL ERROR FOR DESCRIPTOR ID COLUMN IN SEGMENTATION

17438493: PRESENTATION VARIABLES NOT USED IN SAVED FILTER AFTER DOING “INCLUDE COLUMN

17457243: TALEO:CREATING A DASHBOARD IN A FOLDER UNDER SHARED FOLDER OF CATALOG WARNS DISP

17462992: NUMBER IS SHOWING WITH DECIMALS IN THE EXCEL

17476445: LIMIT BY ALL PROMPTS NOT WORKING IF PREVIOUS ONE IS A PRESENTATION VARIABLE

17485342: BI SERVER FAILURE DUE TO CHANGE OF LEVEL IN PARTY ID COLUMN AFTER MERGE

17485955: TALEO : APP ROLE DENIED USER POPULATION IS THROWING ERROR ON AGENT PAGE

17491720: BI SERVER CRASH ON RUNNING BIAPPS TM QUERIES

17496492: CONSISTENCY CHECK DOES NOT FIX CORRUPT REPOSITORY AND ADMINTOOL CRASHES

17505778: SHARED FOLDER IN BI CATALOG IS EMPTY AFTER PATCHING

17538876: GO-URL ISSUE

17600644: OBIEE 7.1: GRAPH PIVOTED RESULT DISPLAYS DUPLICATE NAME FOR PIE CHART TITLE.

17622366: FILTER IS NOT BEING SET AFTER SORTING THE COLUMN

17601422: TOTAL BUTTON DISAPPEAR WHEN COLUMN SELECTOR IS USED.

17636632: OPEN DOES NOT SHOW JAVASCRIPT VIEW

17656090: CONDITION REQUESTS USE EXCESSIVE DIRECTORY I/O

17753959: SHOW DATA AS – GRAND TOTAL INCORRECT

17833915: PIVOT COLUMN WITH ‘SHOW DATA AS OF ROW’ SHOWS WRONG VALUES IN EXCEL 2007

Ignore the readme.txt files in the Oracle BI EE Suite Bundle Patch component patches. The readme.html file in patch  17886497 contains all the installation instructions and list of bugs fixed.

Remember to upgrade the BI Administration Clients with the 17922577 patch content that comes in the bundle patch (not relevant for Windows servers).
Thanks,

~KKT~

Migrating ODI 11g to 12c


Migrating Oracle Data Integrator (ODI) from version 11g to 12c is not straight forward as exporting and importing it into a new repository.   An administrator needs to upgrade the 11g version of the repository to the 12c version so the new features can be incorporated into into the code.

Prerequisites For An ODI 11g to ODI 12C upgrade

Clone

A clone should be made of each original master and work repository on 11g.   The Upgrade Assistant does not support repositories distributed on different instances of ODI.

The ODI 12c version now uses unique IDs that follow the GUID convention. This avoids collision during the import of ODI objects and allows for simpler management and consolidation of multiple repositories within any given project.

Backup

Create a backup for each master and work repository (11g).  The backup will enable administrators to restore to the initial (pre-upgrade) state, if necessary.

Support

Before the upgrade of schemas, make sure the database supports the newer version.  (Note: ODI 12c supports database versions 11.2.0.3 R2 and above.)

Version Upgrade

Only repositories from versions of ODI 11.1.1.6.0 and above can be upgraded to ODI 12c.  If the scenario is one where we have to upgrade ODI 10g to ODI 12C, we must first upgrade ODI 10g to ODI 11.1.1.6.0 before performing the ODI 12c upgrade.

After successfully installing ODI 12c using the odi_121200.jar file, Opatch needs to be applied from the odi_1212_opatopatch.rar file available from the same folder downloaded from Oracle Technology Network (OTN).

  • Before running a Opatch, shut down all Oracle and ODI services.
  • Call the OPtach.bat file available in <Oracle_Home>\OPatch directory    “opatch napply <download_folder>\odi_1212_opatch”

1

 

  • Once Opatch is successful, call upgrade utility “ua.bat” from <Oracle_Home>\oracle_common\upgrade\bin folder.

 

Installing ODI 12C

Download the 12c ODI generic version from oracle downloads. I have downloaded 12.1.2 generic version which is the current version when this post is written.

ofm_odi_generic_12.1.2.0.0_disk1_1of1.zip

Extract this zip file. we can see the main jar for installation and patches zip file to apply the patches. Extract the patch zip file. ODI 12c installation has 2 steps.

Install ODI 12c jar

2 Run the jar file in command prompt for installation. we need to run this jar with admin rights in windows (run as administrator option). Also ODI 12c is certified above 1.7.0_15 or above. Be sure to use latest JDK 1.7.

In windows, to run the command with admin rights, type cmd in run and use cntrl-shift-enter to launch it. select yes in the confirmation for running the commands with admin privilege in the cmd window.
type the command java -jar odi_121200.jar (make sure java executable is from jdk 7 latest version)

3 4Provide oracle home for the installation

 

5Select enterprise installation option. Complete the wizard to complete the installation.

6Upgrading ODI repository from 11g to 12c

 

Before upgrading the repository, please make sure of the following so that you dont lose your repository if there are any errrors during upgrade.
1. All affected data is backed up (middleware home, oracle home, master and work repository schemas and data)
2. Datbase version is certified to work with ODI 12c
3. Certification and system requirements are met.
To run the upgrade, Go to <Oracle_Home>/oracle_common/upgrade/bin directory and run the ua command.
7Select schemas to upgrade repository.
8Select ODI for schema for repository upgrade.
9Check the prerequiresites and check them to agree that you have completed them.
10Provide sysdba user and master repository schema details.
11Select all options for upgrading.
12Provide supervisor user details
13Please note down the upgrade key detail for future reference and work with support for any issues.14 Complete the wizard to complete the upgrade. It will take some time to do the upgrade and confirm the upgrade is successful.

Lets connect to the repository using the new 12c ODI client.

ODI client  odi.exe  or odi64.exe can be found in <Oracle_Home>/odi/studio. Lauch the exe for odi studio client.

Oracle has made the look and feel same for Jdeveloper 12c and ODI 12c client. It is evident that OFM is standardized across tools and infrastructure in 12c.

If asked for import earlier version configs, select yes to carry them to 12c client. You will asked to create wallet for storing passwords. Provide a password of your choice for wallet password. It will be prompted for this wallet password while connecting to repository.
Please feel free to add comments or to ask any questions
Thanks,
~KKT~