Tuesday, October 29, 2013

Oracle BI Mobile App Designer Trial Edition is now Available for Download

Hi Folks,

Oracle BI Mobile App Designer Trial Edition  is available for download.



Monday, October 7, 2013

OBIEE - Sample Application (V309 R2) is now Available for Download

Hi Friends,

Sample App is now available for download



Thursday, August 29, 2013

Important Note on Java Version used in OBIEE

Hi Friends ,

This a note for those of you who are using Java 6 and OBIEE.


Abstract of the above article is java 6 is no longer safe and is vulnerable

If you did  Enterprise Installation of OBIEE, it comes with java 6 version and Weblogic 10.3.5.

Important note here is web logic server  10.3.5 is not compatible  with JDK 7( Reference : oracle certification matrix). Only web logic server 10.3.6 + can use java 7.


Weblogic Server 10.3.6 with OBIEE and JDK 1.7.0_07+ is a certified combination 

 First upgrade to WLS 10.3.6 and the upgrade then to the latest JDK 1.7.0_07+.

 For more specific questions relevant to your environment , always raise an SR with oracle and take their opinion before doing any upgrades....


Tuesday, August 6, 2013

Agent Failed : nQSError: 77006

Hi Friends,

Today I cam across an error in Agents ( OBIEE when I try to deliver a report of 18.1 MB size to users as excel attachment.

Error :

[nQSError: 77006] Oracle BI Presentation Server Error: A fatal error occurred while processing the request. The server responded with: A fatal error occurred while processing the request. The server responded with: com.siebel.analytics.utils.InputStreamWithLimit$ReadOverTheLimitException.
Error Codes: AGEGTYVF
Location: saw.rpc.mis.read, saw.subsystem.portal.pdf, saw.delivers.rpc.getDeviceContent, saw.rpc.server.responder, saw.rpc.server, saw.rpc.server.handleConnection, saw.rpc.server.dispatch, saw.threadpool.socketrpcserver, saw.threads

Solution :

Go to


and edit the config.xml file

 Here limit is 8192 KB and I am trying to send 18534.4 KB.

First Thing to do for trouble shoot this issue is.... Change the 8192 to zero as  shown below.

 and restart the services.... It will fix the issue...A value of '0' means that this limit is deactivated.

But , you would like to limit the maximum input size (in kilobytes) for requests that are sent to the JavaHost service, then gradually increase the parameter's value until you can export correctly.


Tuesday, July 9, 2013

Display a list of dashboards based on permissions?

Hi Friends,

Today  an  interesting question was asked and it is answered on OTN.

Credit goes to   MTache  for his Java script on OTN forums and I am just posting it here.

Question :

Is there a way to display a list of dashboards based on permissions?

Ans :  Copy and paste the below script in the text box and mark  " Contains HTML" box. 

<img id="loading" src="/analytics/res/sk_blafp/catalog/loading-indicator-white.gif" />
<div id="dash_list"></div>
<script src="//ajax.googleapis.com/ajax/libs/jquery/1.10.1/jquery.min.js"></script>
<script type="text/javascript">
url: "saw.dll?getDashboardList"
}).done(function( data ) {
    var start = data.indexOf('[');
    var end = data.lastIndexOf(']');
    var len = end-start+1;
    var json_str = data.substr(start,len);
    var json_obj = jQuery.parseJSON(json_str);
    var str = 'You have access to the following dashboards:<br/>';
    $.each(json_obj, function() {
        if (this.folderName!=='Welcome'){
            str += '<div style="float:left;margin:5px 10px;";><b>' + this.folderName + '</b><br/>';
            $.each(this.portals, function() {
                    str += '<a href="saw.dll?Dashboard&PortalPath=' + this.portalPath + '">' + this.portalName + '</a><br/>';
            str += '</div>';


Wednesday, June 5, 2013

WARNING - BI Applications installation issue

Hi Friends,

ugghhhhhh....... This is just my scenario.....

Please refer the below article



Saturday, April 6, 2013

How to Upgrade from OBIEE to on linux

Hi Friends ,

Today we will see how to upgrade from OBIEE to version.

In this example I am taking OBIEE   and upgrading it to  OBIEE Version.

Your Best Friend to help is oracle Upgrade Documentation.


High-level upgrade path is as follows

There is a  chapter in the upgrade document which says

"Moving from,, or to".

This is you starting point.


Step 1:

Stop all the  OBIEE Stack

Step 2: Patching Weblogic

As we are going to the latest OBIEE. I want to patch the weblogic to the latest version.
We  have a default weblogic 10.3.5 which came from default OBIEE Installation.
I am here trying to patch the weblogic 10.3.5  to 10.3.6. 

Why to patch the endeca ?Another  Reason to upgrade weblogic?

If you are planning to use Endeca  better upgrade the weblogic right now... see the screen shot below. Endeca supports  10.3.6

Note : What versions of weblogic is supported for  OBIEE


Patch number  13529623 is required to patch the weblogic from 10.3.5 to 10.3.6, download it from oracle support.

Run the following command to start the upgrade process

That's it we have patched the Weblogic Server

Step 3 : Upgrading the BI Domain

For this one you have to download the OBIEE  Software(bishiphome)

Linux Tip :  If you want to unzip all the Linux files at the same time use the following command

Click Finish and you are done with  Installation.

Step 4:  

Start the Node Manager and Weblogic in linux

Step 5: Upgrading MDS and BIPLATFORM Schemas

Starting the  Patch set assitant

Click on the connect button it will automatically populate the MDS Schema Details

*Enter the DEV_MDS   Schema password you gae during the OBIEE installation and click " NEXT"*

Step 5:  For all the remaining steps in the oracle documentation  ( 6-14)  As said in the document we are gonna use Configuration Assistant.

That's it done with  configuration 

You can now login to OBIEE URL

 Oracle Business Intelligence  Banner etc are misssing... If you have the same problem flush your cache....

After clearing the cache everything looks good as below.

Even Weblogic is upgraded to the 10.3.6

The only part I am missing is as follows

Need to do some more reading.... I know while installing OBIEE... we all select the RTD option as below...

Will do some research  on upgrading RTD ( Real -Time Decisions)

and update the upgrade process...