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

Scheduling of reports
Pivot Table Alignment
unable to open Hyperion workspace with weblogic 8.1
Suggest me the solution?
essbase holap cube reporting in obiee
Issue With Dashboard
Increase the height for the Writeback column
How to model a conversion table for unit of measures?
Getting error when ever I am try to create the session variable in the init
Cache Issue
Using Maps in Oracle BI
How format drill down column?
Sort column limit
Write Back working in one instance not in other instance after migration
Unable to login into BI Publisher.
Direct Database Request - Incorrect Column Data type