Wednesday, December 2, 2015

OBIEE 12C Horizntal Clustering

Hi ,

I have written an article on  Horizontal Clustering in OBIEE 12C. Please find the link bellow

https://www.linkedin.com/pulse/obiee-12c-horizontal-clustering-venkata-rachuri?trk=hp-feed-article-title-publish

Thanks
Venkat

Monday, October 26, 2015

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.


http://www.oracle.com/technetwork/middleware/bi-foundation/bi-mobile-ad-trial-download-2020939.html?ssSourceSiteId=ocomen

Thanks
Venkat

Monday, October 7, 2013

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

Hi Friends,

Sample App 11.1.1.7.1 is now available for download

http://www.oracle.com/technetwork/middleware/bi-foundation/obiee-samples-167534.html

Thanks
Venkat

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.

https://community.qualys.com/blogs/laws-of-vulnerabilities/2013/08/26/java-6-0-day-exploit-in-the-wild

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.

Sol:



Weblogic Server 10.3.6 with OBIEE 11.1.1.7.x 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....

Thanks
Venkat

Tuesday, August 6, 2013

Agent Failed : nQSError: 77006

Hi Friends,

Today I cam across an error in Agents ( OBIEE 11.1.17.1) 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

/u01/app/oracle/obiee117g/instances/instance1/config/OracleBIJavaHostComponent/coreapplication_obijh1

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.

Thanks
Venkat


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">
$.ajaxSetup({
    beforeSend:function(){
        $("#loading").show();
    },
    complete:function(){
        $("#loading").hide();
    }
});
$.ajax({
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>';
        }
    });
$('#dash_list').html(str);
});
</script>

Thanks
Venkat