error while running a report using nqcmd

vkm

I'm trying to run a report using nqcmd utility in Linux. I keep getting below error and no results are returned. I can run the report using the same logica SQL by logging into the BI application. none of hte logs are showing any informaiton on the attempted run. Any idea how I can start troubleshooting this?

the command I'm using is

[oraclebi@rdcqlbiap02 bin]$ ./nqcmd.sh -d AnalyticsWeb -u username -p password -s ProfitabilityAnalysis.lsql -o output

the output file content are:

SELECT

   0 s_0,

   "DCI - Financials - Profitability Analysis"."Document Details"."Local Currency" s_1,

   "DCI - Financials - Profitability Analysis"."Ledger"."Ledger Name" s_2,

   "DCI - Financials - Profitability Analysis"."Plant"."Plant Location Name" s_3,

   0 s_4,

   "DCI - Financials - Profitability Analysis"."Local Currency Amounts"."Revenue Amount - Local" s_5,

   "DCI - Financials - Profitability Analysis"."Local Currency Amounts"."Sales Margin % - Local" s_6,

   "DCI - Financials - Profitability Analysis"."Local Currency Amounts"."Sales Margin - Local" s_7,

   "DCI - Financials - Profitability Analysis"."Local Currency Amounts"."Total COGS - Local" s_8,

   case when "DCI - Financials - Profitability Analysis"."Local Currency Amounts"."Revenue Amount - Local" =0 then 0 else ("DCI - Financials - Profitability Analysis"."Local Currency Amounts"."Sales Margin - Local"/"DCI - Financials - Profitability Analysis"."Local Currency Amounts"."Revenue Amount - Local")*100 end s_9

FROM "DCI - Financials - Profitability Analysis"

WHERE

(((("Time"."Fiscal Year" = 2016) AND ("Time"."Fiscal Quarter" IN ('2016 Q 1', '2016 Q 2', '2016 Q 3'))) AND (("Transacted Currency Amounts"."Revenue Amount - Transacted" <> 0) OR ("Transacted Currency Amounts"."Total COGS - Transacted" <> 0))))

ORDER BY 5 ASC NULLS LAST, 2 ASC NULLS LAST, 3 ASC NULLS LAST, 4 ASC NULLS LAST

FETCH FIRST 250001 ROWS ONLY

[DataDirect][ODBC lib] You are not licensed to use this ODBC driver with the DataDirect ODBC Driver Manager under the license you have purchased.  You can order a license by calling DataDirect Technologies at 800-876-3101 in North America and +44 (0) 1753-218 930 elsewhere.  Thank you for your cooperation.

Statement execute failed

Processed: 1 queries

Encountered 1  errors

Thanks in advance!

Robert Angel

See => IBM ERROR: You are not licensed to use this DataDirect Technologies ODBC Driver, when using ClearQuest - United States

With this being Linux could it just be that your user does not have the necessary rights on the license file?

Joel

Take a look at this article, it might be related to your issue:

Oracle Support Document 1307503.1 (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....") can be found at: https://support.oracle.com/epmos/faces/DocumentDisplay?id=1307503.1

vkm

Can you point me towards location of the licence file in OBIEE 12C. I did some search and it is supposed to be at <obiee_home>/bi/common/ODBC/Merant/7.1.4 but I don;t have ODBC folder under the Common directory in my installation.

Thanks!

Joel

Take a look at this document to ensure that you have correctly set up your ODBC.

vkm

I can see the Library path is setup for Data direct driver:

LD_LIBRARY_PATH=/u01/app/Oracle/Middleware/Oracle_Home12212/bi/modules/oracle.bi.datadirect.odbc/7.1.5/lib:$LD_LIBRARY_PATH

Joel

Can you check that the Linux user/group have read permissions to this license file

Does the directory containing the ODBC driver appear 1st in the library path?

vkm

yes, The usergroup has correct permissions and the directory for the ODBC Driver appears first in the library path.