Dec
5
2011

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 user.sh 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:

LD_LIBRARY_PATH=$OracleBI_HOME/server/Bin64:$OracleBI_HOME/odbc/lib64:$OracleBI_HOME/server/Bin:
$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

RecentPosts

Month List