Showing posts with label OBIEE. Show all posts
Showing posts with label OBIEE. Show all posts

Friday, October 14, 2011

Big Data Keynote at Oracle Open World 2011

See Oracle’s solution to solving “Big Data” problem:

Oracle NoSQL database
Oracle Enterprise Manager 12c (cloud)
Oracle Data Integrator
Oracle Loader for Hadoop (moves data from Hadoop to Oracle database)
Oracle R Enterprise (programming language built into the database) (similar to SAS)
Integration with OBIEE (demo)
Oracle Exalytics
Oracle Big Data Appliance

Good Presentation from Oracle Open World 2011 here

The video quality is not great, but the presentation is very insightful.

Saturday, May 28, 2011

Installing OBIEE Presentation Server Plugin for IIS 7.5 on Windows 2008/Windows 7 64 bit


I recently struggled installing and configuring OBIEE on Windows 2008 64 bit OS. I got the infamous HTTP 500 error. OBIEE is NOT supported on Windows 64 bit OS but you can try the following steps to try and get it to work. Note, ideally you want to avoid 64 bit compatibility issues if possible by taking the 32-bit route. I am documenting a couple of steps that seemed to be the key in solving my problem.


Installation – When you run the setup, you might be welcomed with the incompatibility message below. Try running the setup.exe in Windows 2003 compatibility mode. This worked for me and the installation went through.


Configuration – Before you start configuring OBIEE Plugin on IIS Server, you need to run the following command:

C:\inetpub\adminscripts>%windir%\system32\inetsrv\appcmd set config -section:applicationPools -applicationPoolDefaults.enable32BitAppOnWin64:true

The above command enables 32 bit app on 64 bit OS. Without setting this option, I got HTTP Error 500.0.

You may need to search adsutil.vbs on your Windows server. Once you find it you can copy it under C:\inetpub\adminscripts or where ever you have inetpub on your PC.

Another command that I have seen people use is below, but It did NOT work for me.

C:\inetpub\adminscripts>cscript adsutil.vbs SET W3SVC/AppPools /Enable32BitAppOnWin64 1
Microsoft (R) Windows Script Host Version 5.8
Copyright (C) Microsoft Corporation. All rights reserved.

ErrNumber: -2147221020 (0x800401E4)
Error Trying To Get the Object: W3SVC

Good Luck! Smile

Saturday, May 14, 2011

OBIEE Error cannot access C:\OracleBIJserver/Sample/samplesales/FactsRevxml

Installed OBIEE on my Ubuntu desktop. Accessing the sample sales app, I ran into this error.

Luckily the fix was easy... Login to OBIEE server using the Admin tool and fix the BI_EE_HOME static variable.

Problem solved:

Actual Error:

Error Codes: OPR4ONWY:U9IM8TAC:0l2DL65P
State: HY0OOE Code: 10058 [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred [nQSError: 64023] cannot access C:\OracleBIJserver/Sample/samplesales/FactsRevxml: No such file or directory for table FactsRev (HY000)

Wednesday, April 20, 2011

OBIEE 11g Demo


Quick summary of OBIEE 11g front-end (Presentation layer)


For OBIEE 11g tutorial click here