OBIEE SQL Server License Error (OPR40NWY:U9IM8TAC:OI2DL65P)

So this week I came across the bogus licensing issue between SQL Server and OBIEE again (Error: OPR40NWY:U9IM8TAC:OI2DL65P). I’ve seen this several time before and each time I’ve only seen it appear when OBIEE is being run on a Unix platform.

The issue isn’t always obvious at first but after you have configured the SQL Server connection on Unix and within the OBIEE repository, you can write reports and retrieve data as you would normally expect. However some days later, you may be presented with an error as follows:

The solution hasn’t always been exactly the same everywhere I have encounted this issue but it all revolves around the Unix environment variables in the shell script. In this particular instance the platform we were running OBIEE on was a 64bit Unix implementation and the key to fixing the issue was to add in the 32bit library paths as well as the 64bit. As soon as these additional library paths were added and the server rebooted, the licence error disappeared and data was retrieved from the SQL Server as normal.

The additional library paths that were added are as follows:

$OracleBI_HOME/web/bin:/OracleBI_HOME/odbc/lib:/ usr/lib:/lib:$ORACLE_HOME/lib:$LD_LIBRARY_PATH:/opt/j2se/jre/lib/sparc


Hope this will be of some help to someone

OBIEE // Java

Changing the JAVA_HOME of an existing OBIEE 10g install

Following on from Matt's post about Installing OBIEE 10g on Windows 7 (32bit or 64bit) machine...

If you have accidentally pointed your OBI install at a 64-bit JDK and you're getting errors like this during OC4J startup:

SEVERE: Exception details: C:\OracleBI\server\Bin\perfjni.dll: 
Can't load IA 32-bit .dll on a AMD 64-bit platform

Then you can redirect it to a 32-bit JDK by editing C:\OracleBI\oc4j_bi\bin\oc4j.cmd and setting the JAVA_HOME variable like so:

set JAVA_HOME=C:\Program Files (x86)\Java\jdk1.6.0_29

That sorts out OC4J but it's likely that the Oracle BI Java Host service won't be working either. The JAVA_HOME for that is in C:\OracleBIData\web\config\instanceconfig.xml

<JavaHome>C:\Program Files (x86)\Java\jdk1.6.0_29</JavaHome>
OBIEE // 10g

Installing OBIEE 10g on Windows 7 (32bit or 64bit) machine

Today i needed to install OBI 10g on my laptop which was running a 64bit version of Windows 7. After extracting the files I ran the setup.exe only to get the following error message:

I decided to change the compatibility settings for the executable to run in either Windows XP mode or Windows Vista and tried the installation again. It failed again in Windows XP mode (with the same error message) but worked when it was set to any of the Windows Vista settings.

To change the compatibility, right click on the setup.exe file and select Properties. Then click on the Compatibility tab and select the compatibility mode you wish to apply. I also ticked ‘Run this program as an Administrator’ to make sure my account had all necessary permissions to install ok.



The setup then began as normal and I got to the last screen of the installation wizard before it actually goes and installs OBIEE. You need to make sure you have a 32bit version of the Java JDK installed. If (like me) you have the 64bit version of the Java JDK installed, you need also install the 32bit as OBIEE will not work properly with the 64bit JDK. Java JDK can be installed from:


If you do pick the location of the 64bit JDK then OBIEE will be installed but you will only be able to use the Administrative tool to modify the Repository (rpd). You won’t be able to log into Analytics (Dashboards or Answers) because the ‘Oracle BI Java Host’ service (one of the 5 services that installs as part OBIEE) will fail to start or run when you try to restart it. So when you try to navigate to the logon screen in a browser http://localhost:9704/Analytics you will get the standard 404 Page not found error.

With the 32bit version of the JDK, the installation should successfully complete and everything should work as if it was installed on a Windows XP (or one of the other supported platforms).


Month List