OBIEE 11g Purge Cache License Error: "You are not licensed to use this ODBC driver with the DataDirect ODBC Driver Manager under the license you have purchased...."

(Doc ID 1307503.1)

Last updated on JANUARY 23, 2017

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.3.0 [1905] and later
Information in this document applies to any platform.

Symptoms

While running the below command to purge OBIEE cache, a license error is encountered:

nqcmd -d AnalyticsWeb -u USERNAME -p PASSWORD -s MARS_PurgeCache.txt -utf16

The file is run from $ORACLE_HOME/bifoundation/server/bin

The command executes successfully but with the following warnining:
"You are not licensed to use this ODBC driver with the DataDirect ODBC Driver Manager under the license you have purchased. If you wish to purchase a license, then you may use the Driver Manager for a period of 15 days, during which time you are required to obtain a license."

In order to run the below command, the environment variables below are set:
(1) LD_LIBRARY_PATH = $ORACLE_HOME/bifoundation/odbc/lib/:$ORACLE_HOME/bifoundationserver/server/bin
(2) ODBCINI=$MW_HOME/instance/instance1/bifoundation/OracleBIApplication/coreapplication/setup/odbc.ini

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms