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 JULY 17, 2021

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.