Monday, 23 September 2013
Thursday, 19 September 2013
Saturday, 4 May 2013
List of Bug Fixes in OBIEE 11.1.1.7.0
List of Bug Fixes in
OBIEE
Rate
This
In OBIEE 11.1.1.7.0,
we have great visualizations including a great SmartView tool with tones of OBIEE and Essbase reports handling
capabilities within MS-Office and some tools/wizards to upgrade your prior version
objects. And also this 4th big major release fro oracle has so many customer
bug fixes that are really made us to rethink earlier to use a feature because
of its limitations.
Some of OBIEE bug fixes that Oracle published:
bug 7217747 - THE “DRILL” INTERACTION IS SELECTED AT RESULT COLUMNS
PROPERTIES OF UNION
bug 7902570 - HAVE A TOOL TO REPORT WHAT EMAIL ADDRESS WERE ENTERED BY USERS IN EMAIL DEVICE
bug 8198137 - GENERATE METADATA DICTIONARY FAILS A COMPLETE EXPORT ON BIG RPD (OUT OFMEMORY)
bug 8802091 - BE ABLE TO RETROACTIVELY SET WEB CATALOG FOR MORE THAN 4000 USERS.
bug 8969962 – EXPORT MULTIPLE ANSWERS REPORTS/DASHBOARDS INTO EXCEL ON SEPARATE SHEETS
bug 10137467 - ENABLE “ZOOM TO DATA RANGE “
bug 10199188 - CHARTS X AXIS LABEL IS BLURRED AT 45/60 ANGLE
bug 10316972 - Y AXIS SCALE IS REPEATING
bug 10647655 - COLUMN DATA FORMAT IS IGNORED ON WRITEBACK
bug 11780223 - DASHBOARD PROMPT PS VAR NOT PASSED TO BIP REPORT DISPLAYED AS LINK
bug 11815935 - NLS:THE SETTING FIRSTDAYOFWEEK IN LOCALEDEFINITIONS.XML DON’T AFFECT CALENDAR UI
bug 11824623 - DOUBLE PERCENT SIGN AND WRONG DATA IN PIVOT TABLE ON FRENCH LOCALE
bug 7902570 - HAVE A TOOL TO REPORT WHAT EMAIL ADDRESS WERE ENTERED BY USERS IN EMAIL DEVICE
bug 8198137 - GENERATE METADATA DICTIONARY FAILS A COMPLETE EXPORT ON BIG RPD (OUT OFMEMORY)
bug 8802091 - BE ABLE TO RETROACTIVELY SET WEB CATALOG FOR MORE THAN 4000 USERS.
bug 8969962 – EXPORT MULTIPLE ANSWERS REPORTS/DASHBOARDS INTO EXCEL ON SEPARATE SHEETS
bug 10137467 - ENABLE “ZOOM TO DATA RANGE “
bug 10199188 - CHARTS X AXIS LABEL IS BLURRED AT 45/60 ANGLE
bug 10316972 - Y AXIS SCALE IS REPEATING
bug 10647655 - COLUMN DATA FORMAT IS IGNORED ON WRITEBACK
bug 11780223 - DASHBOARD PROMPT PS VAR NOT PASSED TO BIP REPORT DISPLAYED AS LINK
bug 11815935 - NLS:THE SETTING FIRSTDAYOFWEEK IN LOCALEDEFINITIONS.XML DON’T AFFECT CALENDAR UI
bug 11824623 - DOUBLE PERCENT SIGN AND WRONG DATA IN PIVOT TABLE ON FRENCH LOCALE
Friday, 22 March 2013
Courses Offered: OBIA (BI Apps)
Courses Offered:
OBIA (BI Apps)
OBIEE 10g/11g INFORMATICA 9.1
ODI 11g DAC
PEGA Hyperion
PeopleSoft SQL/PLSQL
Oracle DBA Hadoop
BI Solutions
Contact : 9986981377 ,
9611895599
Wednesday, 13 March 2013
OBIEE 11g 11.1.1.6.9 is Available For BI Enterprise and Exalytics
OBIEE 11g 11.1.1.6.9 is Available For BI Enterprise and Exalytics
The Business Intelligence Enterprise Edition 11.1.1.6.9 patch set has been released and is available to download from My Oracle Support (https://support.oracle.com).
Per the patch readme:
This patch set is available for all customers who are using Oracle Business Intelligence Enterprise Edition 11.1.1.6.0, 11.1.1.6.1, 11.1.1.6.2, 11.1.1.6.2 BP1, 11.1.1.6.4, 11.1.1.6.5, 11.1.1.6.6, 11.1.1.6.7 and 11.1.1.6.8 .
Oracle Exalytics customers must only install this Oracle Business Intelligence patch set if it is certified for the specific Oracle Exalytics patch or patch set update that they are applying. For more information see Oracle Fusion Middleware Installation and Administration Guide for Oracle Exalytics In-Memory Machine and the Oracle Exalytics certification information.
The Oracle Business Intelligence 11.1.1.6.8 patch set is comprised of the following patches:
Patch 16287811 (1 of 7) Oracle Business Intelligence Installer. (generic)
Patch 16287778 (2 of 7) Oracle Real Time Decisions. (generic)
Patch 16237960 (3 of 7) Oracle Business Intelligence Publisher. (generic)
Patch 16287840 (4 of 7) Oracle Business Intelligence ADF Components. (generic)
Patch 16287854 (5 of 7) Enterprise Performance Management Components Installed from BI Installer 11.1.1.6.x. (port-specific)
Patch 16227549 (6 of 7) Oracle Business Intelligence. (port-specific)
Patch 16287884 (7 of 7) Oracle Business Intelligence Platform Client Installers and MapViewer (generic)
Note:
The Readme files for the above patches describe the bugs fixed in each patch, and any known bugs with the patch.
This patch is cumulative, and therefore, contains all of the fixes included in the earlier 11.1.1.6.2, 11.1.1.6.4, 11.1.1.6.5, 11.1.1.6.6, 11.1.1.6.7 and 11.1.1.6.8 patch sets.
However, lists of fixes from included patch sets need to be looked up in the respective patches' readme files, and are not included in the above patches' readme files.
The instructions to apply the above patches are identical, and are contained in the readme file for patch 16287811
Please bear in mind, that the readme states to apply patch 13952743 for JDeveloper, too.
Per the patch readme:
This patch set is available for all customers who are using Oracle Business Intelligence Enterprise Edition 11.1.1.6.0, 11.1.1.6.1, 11.1.1.6.2, 11.1.1.6.2 BP1, 11.1.1.6.4, 11.1.1.6.5, 11.1.1.6.6, 11.1.1.6.7 and 11.1.1.6.8 .
Oracle Exalytics customers must only install this Oracle Business Intelligence patch set if it is certified for the specific Oracle Exalytics patch or patch set update that they are applying. For more information see Oracle Fusion Middleware Installation and Administration Guide for Oracle Exalytics In-Memory Machine and the Oracle Exalytics certification information.
The Oracle Business Intelligence 11.1.1.6.8 patch set is comprised of the following patches:
Patch 16287811 (1 of 7) Oracle Business Intelligence Installer. (generic)
Patch 16287778 (2 of 7) Oracle Real Time Decisions. (generic)
Patch 16237960 (3 of 7) Oracle Business Intelligence Publisher. (generic)
Patch 16287840 (4 of 7) Oracle Business Intelligence ADF Components. (generic)
Patch 16287854 (5 of 7) Enterprise Performance Management Components Installed from BI Installer 11.1.1.6.x. (port-specific)
Patch 16227549 (6 of 7) Oracle Business Intelligence. (port-specific)
Patch 16287884 (7 of 7) Oracle Business Intelligence Platform Client Installers and MapViewer (generic)
Note:
The Readme files for the above patches describe the bugs fixed in each patch, and any known bugs with the patch.
This patch is cumulative, and therefore, contains all of the fixes included in the earlier 11.1.1.6.2, 11.1.1.6.4, 11.1.1.6.5, 11.1.1.6.6, 11.1.1.6.7 and 11.1.1.6.8 patch sets.
However, lists of fixes from included patch sets need to be looked up in the respective patches' readme files, and are not included in the above patches' readme files.
The instructions to apply the above patches are identical, and are contained in the readme file for patch 16287811
Please bear in mind, that the readme states to apply patch 13952743 for JDeveloper, too.
Tuesday, 12 March 2013
obia training
Courses we offer :
OBIEE 10g/11g
INFORMATICA 9.1
DAC 10g/11g
OBIA (BI Apps) 7.9.6.3
PEGA 6.2
.NET
REACH US AT:
BI Solutions
#727 , 1st Floor,
Rajagopala Reddy Building,
Chowdeshwari Layout,
OPP: Thulasi Theatre
Marthahalli, Bangalore - 37.
Contact no: +91 9986981377, 9611895599
REACH US AT:
BI Solutions
#727 , 1st Floor,
Rajagopala Reddy Building,
Chowdeshwari Layout,
OPP: Thulasi Theatre
Marthahalli, Bangalore - 37.
Contact no: +91 9986981377, 9611895599
Sunday, 10 March 2013
How to install OBIEE 11g patch 11.1.1.6.8
Late last year (December 2012) Oracle gave us the pleasure of releasing their newest OBIEE 11g patchset - OBIEE 11.1.1.6.6 and just when you finished got comfortable with version 11.1.1.6.4!
The guide below will outline how to apply the new OBIEE 11g 11.1.1.6.6 patchset assuming your starting point is a prior version on the 11.1.1.6.x platform.
As a reminder, note that the OBIEE 11g patchsets are cumulative - meaning the 11.1.1.6.6 patchset includes all patches from 6.5, 6.4 and down.
Step 1) Make sure you have the latest OPatch installed on your machine
Oracle uses the Opatch tool to apply patches to OBIEE 11g, and if you attempt to apply a patch with an outdated Opatch version, you get the following error:
You can download the latest version of Opatch by searching http://support.oracle.com for 'How To Download And Install The Latest OPatch Version [ID 274526.1]' or by clicking here
Step 1.1) Extract the opatch folder to your FMW_HOME/Oracle_BI1 folder. There is most likely an Opatch folder already in there - that is the old version. Archive it then remove it from the Oracle_BI1 folder and replace it with the Opatch folder you just downloaded.
Step 2) Back Up Critical Folders
Make sure to save the following folders in the event of a failure when applying the patch set:
The entire weblogic domain must be shut down prior to applying the patch set
Step 4) Confirm Key Environment Variables are Set
On Windows: If the Oracle BI Home directory is C:\prod_mwhome\Oracle_BI1, then set the environment variables by entering the following:
The quickest way to do this is by navigating to the 'Patches & Updates' tab on support.oracle.com and using the 'Product or Family (advanced)' search feature to download the patch set for your specific OS:
Make sure you check 'Include all products in a family'!
Step 6) Unzip the patch set into your $FMW_HOME/Oracle_BI1 folder
There should be 7 folders - one for each patch:
Step 7) Remove Catalog Manager Cache Files (if they exist)
org.eclipse.osgi
org.eclipse.equinox.app
Step 8) Apply the 7 patches in the 11.1.1.6.6 patch set
It is important that you apply the patches in the following order:
Navigate into each folder and run the following command : opatch apply . The command should execute without error as shown below:
Step 9) Download the JDeveloper Patch
The Oracle Reference Document '[ID 1488475.1] OBIEE 11g Required and Recommended Patch Sets' on http://support.oracle.com indicates that for 11.1.1.6.6 patch set you need to download and apply JDeveloper patch 13952743 which is not included in the core 7 patches. Make sure to download 13952743 and unzip it to your $FMW_HOME/Oracle_BI1 folder as well.
Step 10) Update Environment Variables for the JDeveloper Patch
You'll need to change your environment variables for this patch as follows:
$ORACLE_HOME = FMW_HOME/oracle_common
Step 11) Apply the JDeveloper Patch
Using the same opatch apply command. Make sure you navigate to the 13952743 folder first!
Step 12) Validate all patches have been applied
Execute the following command: opatch lsinventory . All 8 patches should be listed.
Step 13) Validate Version in Answers
After starting your Admin Server, Node Manager, Managed Server and OPMN services. Navigate to your Administration tab in Answers to view the new version:
Potential Issue: Conflict with previous patches
In my earlier post I outlined how to apply an individual patch to resolve bug 1467168.1 (multiple pie charts error) by applying patch 14003822 .
If you've applied any individual patch and then later try to apply a bundle patch you'll get the following error:
indicating there is a conflict between the original patch and the 11.1.1.6.6 bundle patch. Go ahead and override the original patch with the new 11.1.1.6.6 patch set. This new patch set also includes any one off patches you've applied so it's safe to override.
keywords: obiee 11g upgrade, obiee upgrade, upgrade assistant, opatch, 11.1.1.6.6, how to install obiee 11g
The guide below will outline how to apply the new OBIEE 11g 11.1.1.6.6 patchset assuming your starting point is a prior version on the 11.1.1.6.x platform.
As a reminder, note that the OBIEE 11g patchsets are cumulative - meaning the 11.1.1.6.6 patchset includes all patches from 6.5, 6.4 and down.
Step 1) Make sure you have the latest OPatch installed on your machine
Oracle uses the Opatch tool to apply patches to OBIEE 11g, and if you attempt to apply a patch with an outdated Opatch version, you get the following error:
"The OUI version is not applicable for current OPatch Version":
You can download the latest version of Opatch by searching http://support.oracle.com for 'How To Download And Install The Latest OPatch Version [ID 274526.1]' or by clicking here
Step 1.1) Extract the opatch folder to your FMW_HOME/Oracle_BI1 folder. There is most likely an Opatch folder already in there - that is the old version. Archive it then remove it from the Oracle_BI1 folder and replace it with the Opatch folder you just downloaded.
Step 2) Back Up Critical Folders
Make sure to save the following folders in the event of a failure when applying the patch set:
- The ORACLE_HOME\bifoundation\server directory
- The ORACLE_INSTANCE\bifoundation\OracleBIServerComponent\coreapplication_obis1\repository
- The ORACLE_BI_HOME\bifoundation\jee\mapviewer.ear\web.war\WEB_INF\conf\mapViewerConfig.xml, if you have modified it
The entire weblogic domain must be shut down prior to applying the patch set
Step 4) Confirm Key Environment Variables are Set
On Windows: If the Oracle BI Home directory is C:\prod_mwhome\Oracle_BI1, then set the environment variables by entering the following:
- set ORACLE_HOME=C:\prod_mwhome\Oracle_BI1
- set PATH=%ORACLE_HOME%\bin;%PATH%
- set JAVA_HOME=%ORACLE_HOME%\jdk
- set PATH=%JAVA_HOME%\bin;%PATH%
- set PATH=%ORACLE_HOME%\OPatch;%PATH%
The quickest way to do this is by navigating to the 'Patches & Updates' tab on support.oracle.com and using the 'Product or Family (advanced)' search feature to download the patch set for your specific OS:
Step 6) Unzip the patch set into your $FMW_HOME/Oracle_BI1 folder
There should be 7 folders - one for each patch:
| Patch | Abstract |
|---|---|
15844023
|
Patch 11.1.1.6.6 (1 of 7) Oracle Business Intelligence Installer
|
15844066
|
Patch 11.1.1.6.6 (2 of 7) Oracle Real Time Decisions
|
14800665
|
Patch 11.1.1.6.6 (3 of 7) Oracle Business Intelligence Publisher
|
15843961
|
Patch 11.1.1.6.6 (4 of 7) Oracle Business Intelligence ADF Components
|
15844096
|
Patch 11.1.1.6.6 (5 of 7) Enterprise Performance Management Components Installed from BI Installer 11.1.1.6.x
|
14791926
|
Patch 11.1.1.6.6 (6 of 7) Oracle Business Intelligence
|
15839347
|
Patch 11.1.1.6.6 (7 of 7) Oracle Business Intelligence Platform Client Installers and MapViewer
|
Step 7) Remove Catalog Manager Cache Files (if they exist)
- On Linux, AIX, or Solaris: If the Oracle BI Home directory is prod_mwhome/Oracle_BI1, then go to the following directory:prod_mwhome/Oracle_BI1/bifoundation/web/catalogmanager/configuration/
- On Windows: If the Oracle Home directory is C:\prod_mwhome\Oracle_BI1, then go to the following directory: c:\prod_mwhome\Oracle_BI1\bifoundation\web\catalogmanager\configuration\
org.eclipse.osgi
org.eclipse.equinox.app
Step 8) Apply the 7 patches in the 11.1.1.6.6 patch set
It is important that you apply the patches in the following order:
| Patch | Abstract |
|---|---|
15844023
|
Patch 11.1.1.6.6 (1 of 7) Oracle Business Intelligence Installer
|
15844066
|
Patch 11.1.1.6.6 (2 of 7) Oracle Real Time Decisions
|
14800665
|
Patch 11.1.1.6.6 (3 of 7) Oracle Business Intelligence Publisher
|
15843961
|
Patch 11.1.1.6.6 (4 of 7) Oracle Business Intelligence ADF Components
|
15844096
|
Patch 11.1.1.6.6 (5 of 7) Enterprise Performance Management Components Installed from BI Installer 11.1.1.6.x
|
14791926
|
Patch 11.1.1.6.6 (6 of 7) Oracle Business Intelligence
|
15839347
|
Patch 11.1.1.6.6 (7 of 7) Oracle Business Intelligence Platform Client Installers and MapViewer
|
Navigate into each folder and run the following command : opatch apply . The command should execute without error as shown below:
Step 9) Download the JDeveloper Patch
The Oracle Reference Document '[ID 1488475.1] OBIEE 11g Required and Recommended Patch Sets' on http://support.oracle.com indicates that for 11.1.1.6.6 patch set you need to download and apply JDeveloper patch 13952743 which is not included in the core 7 patches. Make sure to download 13952743 and unzip it to your $FMW_HOME/Oracle_BI1 folder as well.
Step 10) Update Environment Variables for the JDeveloper Patch
You'll need to change your environment variables for this patch as follows:
$ORACLE_HOME = FMW_HOME/oracle_common
Step 11) Apply the JDeveloper Patch
Using the same opatch apply command. Make sure you navigate to the 13952743 folder first!
Step 12) Validate all patches have been applied
Execute the following command: opatch lsinventory . All 8 patches should be listed.
Step 13) Validate Version in Answers
After starting your Admin Server, Node Manager, Managed Server and OPMN services. Navigate to your Administration tab in Answers to view the new version:
In my earlier post I outlined how to apply an individual patch to resolve bug 1467168.1 (multiple pie charts error) by applying patch 14003822 .
If you've applied any individual patch and then later try to apply a bundle patch you'll get the following error:
keywords: obiee 11g upgrade, obiee upgrade, upgrade assistant, opatch, 11.1.1.6.6, how to install obiee 11g
Subscribe to:
Posts (Atom)