Tuesday Apr 10, 2012

OBIEE 11.1.1.5.0 Bundle Patch 2 is available

Oracle BI EE 11.1.1.5.0 Bundle Patch 2 is available. The Patch number is 13611078 and it can be downloaded from Oracle Support (you can download it without password). This patch currently is available on Microsoft Windows x64 (64 bit), Linux x86 - 64 bit, IBM AIX on Power System (64 bit) and Oracle Solaris Sparc (64 bit). Remaining four platforms Win32, Linux32, HP-Itanium, and Solaris x86-64 are expected 3-4 weeks later.

This Patch has thoroughly been tested and signed off by BI QA Team. 

[Read More]

Thursday Apr 05, 2012

OBIEE 11.1.1 - BI Design Best Practices Whitepaper V1.4

  • Oracle BI Principles.
  • Repository design best practices.
  • Dashboards and reports design best practices.
  • 10g Upgrade considerations.

This version includes some additional best practices and improvements specific to 11.1.1.7.0

Click here to download (Right click or option-click the link and choose "Save As..." to download this pdf file)

Wednesday Apr 04, 2012

OBIEE 11.1.1.6.0 - Import Metadata from Oracle Database is not working with BI Client installer

BI Client installer (version 11.1.1.6.0) does not install Oracle Database Client. Therefore for BI Admin tool client installations, the Oracle DB Client (11gR2) must also be separately installed on same windows machine.

Tip: If you install BI Client 32bit version, make sure to install Oracle Database Client 32bit version. Likewise If you install BI Client 64bit version then make sure to install Oracle Database Client 64bit version.


Friday Mar 30, 2012

EPM 11.1.2 - EPM Infrastructure Tuning Guide v11.1.2.1

Applies To: This edition applies to only 11.1.2, 11.1.2 (PS1).

One of the most challenging aspects of performance tuning is knowing where to begin. To maximize Oracle EPM System performance, all components need to be monitored, analyzed, and tuned. This guide describe the techniques used to monitor performance and the techniques for optimizing the performance of EPM components.

TOP TUNING RECOMMENDATIONS FOR EPM SYSTEM:

Performance tuning Oracle Hyperion EPM system is a complex and iterative process. To get you started, we have created a list of recommendations to help you optimize your Oracle Hyperion EPM system performance.

This chapter includes the following sections that provide a quick start for performance tuning Oracle EPM products. Note these performance tuning techniques are applicable to nearly all Oracle EPM products such as Financial PM Applications, Essbase, Reporting and Foundation services.

1. Tune Operating Systems parameters.
2. Tune Oracle WebLogic Server (WLS) parameters.
3. Tune 64bit Java Virtual Machines (JVM).
4. Tune 32bit Java Virtual Machines (JVM).
5. Tune HTTP Server parameters.
6. Tune HTTP Server Compression / Caching.
7. Tune Oracle Database Parameters.
8. Tune Reporting And Analysis Framework (RAF) Services.

Click to Download the EPM 11.1.2.1 Infrastructure Tuning Whitepaper (Right click or option-click the link and choose "Save As..." to download this pdf file)


Wednesday Mar 28, 2012

EPM 11.1.1 - EPM Infrastructure Tuning Guide v11.1.1.3

This edition applies to EPM 9.3.1, 11.1.1.1, 11.1.1.2 & 11.1.1.3 only.

INTRODUCTION:One of the most challenging aspects of performance tuning is knowing where to begin. To maximize Oracle EPM System performance, all components need to be monitored, analyzed, and tuned. This guide describe the techniques used to monitor performance and the techniques for optimizing the performance of EPM components.

Click to Download the EPM 11.1.1.3 Infrastructure Tuning Whitepaper (Right click or option-click the link and choose "Save As..." to download this file)


Tuesday Mar 27, 2012

Essbase 11.1.2 - JVM_OPTION settings for Essbase

When tuning the heap size for Essbase, there are two JVM_OPTIONS settings available for Essbase - one for the Essbase agent and one for the Essbase applications that are using custom-defined functions (CDFs), custom-defined macros (CDMs), data mining, triggers or external authentication.

  • ESS_JVM_OPTION setting is used for the application and mainly for CDFs, CDMs, data mining, triggers, external authentication
  • ESS_CSS_JVM_OPTION setting is used to set the heap size for the Essbase agent


Wednesday Mar 14, 2012

Essbase 11.1.2 - Optimisation of Essbase Calculation Scripts Using NOT in IF statements

In Essbase calculation scripts, when an IF statement is performed, it will perform the first element of the IF statement first, check if the combination being calculated meets that criteria and calculate it if it does or pass to the next element, i.e the next ELSEIF. This will continue through all the ELSEIF statements and then the ELSE (if present) if the combination does not meet any of the criteria of the IF or ELSEIF.

It is possible to optimise an IF statement by first analysing which condition will be met by the majority of your data and then to try and place this IF statement as near to the top of your IF statement as possible ... if possible, of course.

[Read More]

Thursday Mar 08, 2012

OBIEE 11.1.1 - BI Office Intermittent Timeout Errors

In OBIEE releases 11.1.1.5 / 11.1.1.6, if the BI Office Server is configured to connect to Presentation Services through Oracle HTTP Server (OHS), then you might see intermittent error messages that are caused by the timeout of a request. To work around this issue, increase the Keepalive timeout 50 or more.

Reference: http://docs.oracle.com/cd/E23943_01/relnotes.htm 


OBIEE 11.1.1 - Scale-Out Scenarios Are Not Supported on OS with Different Patch Levels

In OBIEE releases 11.1.1.5 / 11.1.1.6, Scale-out scenarios of the BI domain are not supported on servers that have the same operating system but different patch levels. All servers must have the same operating system patch level.

Reference: http://docs.oracle.com/cd/E23943_01/relnotes.htm 


Wednesday Mar 07, 2012

EPM 11.1.2 - Service unavailable errors using EPM System

Users experience intermittent Service Unavailable errors using different components of the Oracle EPM System. A blank page with the following error message shows up:

                The service is unavailable.

Reviewing the application specific log files and testing the WebLogic application servers in the back end does not show any issues. As the client can still connect to the web server and the Java Application Server is working fine in the back end, it is clear that there is some issue in between web and application server. To track this down, logging for the WebLogic web server plug-in needs to be enabled. Setting up logging depends on the web server, so we need to distinguish between Internet Information Services (IIS) and Oracle HTTP Server (OHS).

[Read More]

Tuesday Mar 06, 2012

OBIEE 11.1.1 - How to obtain Crash logs for BI Mobile app in iPhone/iPad

a. First synchronize your mobile device (iPhone/iPad) with your computer

b. Crash logs stored under:

          Windows 7

        C:\Users\username\AppData\Roaming\Apple Computer\Logs\CrashReporter\MobileDevice\iPad2

          Windows XP

        C:\Documents and Settings\Application Data\Apple computer\Logs\CrashReporter\

          Mac OS X

        /Library/Logs/CrashReporter/MobileDevice//

EPM 11.1.2 - VBScript error using HFM in a load balanced environment

Financial Management is installed in an environment using two or more web servers and a load balancer is used to distribute user request across the web servers. The following errors occur in the web client:

Microsoft VBScript runtime error '800a01a8'
Object required
/hfm/data/webformgenerated.asp, line 48

Error number:424
Error description: Object required
Error source: Microsoft VBScript runtime error
Page On which Error Occured: /hfm/DocMgr/OpenItem.asp

Make sure IIS logging is configured to log include "Cookies". You can check this as follows:

[Read More]

EPM 9.3.3 - Cannot log in to Financial Reporting Studio 9.3.3

The following error occurs in Financial Reporting Studio after entering user credentials and server name into login dialog, also the Financial Reporting Studio does not connect to the Financial Reporting Server at all:

You are not authorized to use this functionality. Contact your administrator.

Financial Reporting Studio log file (HYPERION_HOME\logs\BIPlus\FRClient.log) does not exist.

[Read More]

Wednesday Feb 29, 2012

OBIEE 11.1.1 - How to capture Console logs in iPhone

To troubleshoot authenication issues etc in Oracle BI Mobile application, here are the basic steps to trace / get the Console Logs:

1. Download and setup iPhone Configuration Utility - Available from developer.apple.com
2. Connect device to computer.
3. Start iPhone Configuration Utility.
4. Go-to Console tab and Clear Console Output.
5. Launch Oracle BI Mobile application.
6. Set Console Logging “ON” .
7  Capture console output in Config Utility i.e. Save Console As...

OBIEE 11.1.1 - IBM JDK Tuning for WebLogic 11G under AIX 6.x

Modify setOBIDomainEnv.sh:

Each lines like:
        if [ "${JAVA_VENDOR}" = "IBM" ] ; then
                # 64-bit IBM JVM is the only JVM supported for AIX
                # assume to always use Managed server memory args for 64-bit IBM JVM
                SERVER_MEM_ARGS="-Xms2048m -Xmx2048m -Xmns512m -Xmnx512m -Xss2m -Xrs -Xgcpolicy:gencon -Xverify:none"
                export SERVER_MEM_ARGS

Glossary:
    -Xms<size>        set initial Java heap size
    -Xmx<size>        set maximum Java heap size
    -Xss<size>         set java thread stack size
    -Xrs                    reduce use of OS signals by Java/VM (see documentation)

    -Xmns<size>
      Sets the initial size of the new (nursery) heap to the specified value when using -Xgcpolicy:gencon. By default, this option is selected internally according to your system's capability. This option will return an error if you try to use it with -Xmn.
    -Xmnx<size>
      Sets the maximum size of the new (nursery) heap to the specified value when using -Xgcpolicy:gencon. By default, this option is selected internally according to your system's capability. This option will return an error if you try to use it with -Xmn.
    -Xverify:<option>
With no parameters, enables the verifier. Note that this is the default; used on its own, this option has no effect.

Additional parameters to review:

You can force the JVM to use large pages, which is more efficient memory management.
Java VM command line option: -Xlp64K
JVM Environment Entry: LDR_CNTLR =  “DATAPSIZE=64K@TEXTPSIZE=64K@STACKSPSIZE=64K”

You should also consider using huger pages.
PPC64 supports 4K(default) and 16M (although this is more likely to speed things up but unlikely solve your heap problem...)
General info for AIX and PPC:
http://publib.boulder.ibm.com/infocenter/aix/v6r1/index.jsp?topic=/com.ibm.aix.prftungd/doc/prftungd/large_page_ovw.htm
Java vm command line:
"-Xlp<size>
AIX: Requests the JVM to allocate the Java heap (the heap from which Java objects are allocated) with large (16 M pages, if a sizeis not specified. If large pages are not available, the Java heap is allocated with the next smaller page size that is supported by the system. AIX requires special configuration to enable large pages.

For more information about configuring AIX support for large pages, see http://publib.boulder.ibm.com/infocenter/aix/v6r1/topic/com.ibm.aix.prftungd/doc/prftungd/large_page_ovw.htm.
The SDK supports the use of large pages only to back the Java heap shared memory segments. The JVM uses shmget() with the SHM_LGPG and SHM_PIN flags to allocate large pages. The -Xlp option replaces the environment variable IBM_JAVA_LARGE_PAGE_SIZE, which is now ignored if set.
AIX, Linux, and Windows only: If a <size> is specified, the JVM attempts to allocate the JIT code cache memory using pages of that size. If unsuccessful, or if executable pages of that size are not supported, the JIT code cache memory is allocated using the smallest available executable page size."

You should also turn on verbose gc.
Java VM command line option:  –verbose:gc

Consider some of the following Java VM command line options (some IBM vm specific):
- -Xgcpolicy:subpool "Uses an improved object allocation algorithm to achieve better performance when allocating objects on the heap. This option might improve performance on large SMP systems"
- -Xcompressedrefs "Use -Xcompressedrefs in any of these situations: When your Java applications does not need more than a 25 GB Java heap. When your application uses a lot of native memory and needs the JVM to run in a small footprint."
- -Xcompactexplicitgc "Enables full compaction each time System.gc() is called."
- -Xcompactgc "Compacts on all garbage collections (system and global)."
- -Xsoftrefthreshold<number> "Sets the value used by the GC to determine the number of GCs after which a soft reference is cleared if its referent has not been marked. The default is 32, meaning that the soft reference is cleared after 32 * (percentage of free heap space) GC cycles where its referent was not marked." Reducing this will clear out soft  references sooner. If any soft referenced-based caching is being used, cache hits will go down but memory will be freed up faster. But this will not directly solve your OOM problem: "All soft references are guaranteed to have been cleared before the OutOfMemoryError is thrown.
The default (no compaction option specified) makes the GC compact based on a series of triggers that attempt to compact only when it is beneficial to the future performance of the JVM."



About

A blog focused on Tips & Tricks about Oracle Business Intelligence (OBI), Oracle Exalytics and Oracle Enterprise Performance Management (EPM) products.
[Blog Admin: ahmed awan]

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today