S
Sreenivasulu Erigineni
Guest
Thanks, Looks like now I am able to connect from Backend using nqcmd. obiee1171@xxxxxxxxxx bin]$ ./nqcmd ------------------------------------------------------------------------------- Oracle BI ODBC Client Copyright (c) 1997-2013 Oracle Corporation, All rights reserved ------------------------------------------------------------------------------- Give data source name: MongoDB4 Give user name: cms Give password: [T]able info [C]olumn info [D]ata type info [F]oreign keys info [P]rimary key info [K]ey statistics info pecial columns info [Q]uery statement Select Option: Q Give SQL Statement: But we are getting below error while connecting from BI Answers. Please advise. Odbc driver returned an error (SQLExecDirectW). Error Details Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 16001] ODBC error state: S0002 code: -5501 message: [DataDirect][ODBC 20101 driver][20101]syntax error or access rule violation: base table or view not found: XXUSERS_ZIP_TERR_V. [nQSError: 16002] Cannot obtain number of columns for the query result. (HY000) SQL Issued: SELECT 0 s_0, "Zodiac Mongo Test"."Users"."Account Number" s_1, "Zodiac Mongo Test"."Users"."City" s_2 FROM "Zodiac Mongo Test" FETCH FIRST 999999 ROWS ONLY Refresh Regards, Sreenivasulu.
Continue reading...
Continue reading...