Business Intelligence Suite Enterprise Edition
Covers BI Server, Interactive Dashboards, Answers, Delivers, Disconnected Analytics, Briefing Books
Hello all! I hope that someone can help me with the problem I am facing. A few days ago I installed Oracle BI 10.1.3.3, 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.