Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

nQSError: 17010

hendrtiSep 13 2007 — edited Sep 20 2007

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

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 18 2007

Added on Sep 13 2007

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

1 comment

1,434 views