Categories
error while running a report using nqcmd
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!
Answers
-
With this being Linux could it just be that your user does not have the necessary rights on the license file?
0 -
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
0 -
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!
0 -
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
0 -
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?
0 -
yes, The usergroup has correct permissions and the directory for the ODBC Driver appears first in the library path.
0
