Technology Network Community
Oracle Database
Fusion Middleware
Development Tools
Server & Storage Systems
Enterprise Management
Berkeley DB Family
Cloud Computing
Big Data
Business Intelligence
Migration and Modernization
E-Business Suite
PeopleSoft Enterprise
JD Edwards World
JD Edwards EnterpriseOne
User Productivity Kit Pro (UPK) and Tutor
Governance, Risk & Compliance (GRC)
Master Data Management (MDM)
Oracle CRM On Demand
On Demand: SaaS and Managed Applications
AutoVue Enterprise Visualization
Agile PLM
Endeca Experience Management
Fusion Applications
Archived Forums



Business Intelligence Suite Enterprise Edition

Covers BI Server, Interactive Dashboards, Answers, Delivers, Disconnected Analytics, Briefing Books

nQSError: 17010

Hello all!  I hope that someone can help me with the problem I am facing.   A few days ago I installed Oracle BI, OBI Apps 7.9 and Informatica 7.1.4. The data is read from a oracle 10g database.   If I right click on a dimension, in the OracleBIAnalyticsApps (which is the repository that came along with the installation package), and I select view data it shows following error:  Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 17001] Oracle Error code: 933, message: ORA-00933: SQL command not properly ended at OCI call OCIStmtExecute. [nQSError: 17010] SQL statement preparation failed. (HY000)  The strange thing about this is that I use the same settings for another datasource and there it works perfectly.  I noticed there are severale people facing the same problem but there is no solution to be found.  I hope someone can help me out.  Thanks a lot!  Tim

You can change the NQSConfig.ini on [ SECURITY ] area and uncomment the : AUTHENTICATION_TYPE = DATABASE;    [ DATABASE ]         DATABASE = "Oracle Data Warehouse";  and into Administration Tool, on connection pool give the datasource name like in tnsnames.ora with user/pass.

Related Links

10g - merge 2 fact tables
drilling down - duplicate sub category
Templates blafp and fusionfx
Web catalog is not displayed, with the Office Ad-in 11g
Date format
Connection Pool
Isolation level in OBIEE
Can't start BI Java Host Service
Creating a Dummy Column
Replace Function
Error:-An error occurred during execution of "connect". Connection refused
Informatica Repository Navigator missing Sessions object
General Background Colour in Dashboard Pages
Bi publisher starting error Error 503--Service Unavailable
Design of BMM layer
Unable to communicate with Oracle BI Presentation Services. OBI EE 10g