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!