Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

error while running a report using nqcmd

Received Response
31
Views
7
Comments
Rank 5 - Community Champion

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!

Welcome!

It looks like you're new here. Sign in or register to get started.

Answers

Welcome!

It looks like you're new here. Sign in or register to get started.