Forum Stats

  • 3,851,567 Users
  • 2,264,000 Discussions
  • 7,904,781 Comments

Discussions

Error in OBIEE Reports.ORA-01445

716024
716024 Member Posts: 66
When making some formula or adding new columns,I am getting the following Err..


State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 17001] Oracle Error code: 1445, message: ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table at OCI call OCIStmtExecute. [nQSError: 17010] SQL statement preparation failed. (HY000)


Its something related to joins.Can anyone Help.

Edited by: Darwin S on Aug 22, 2009 8:48 PM
Tagged:

Answers

This discussion has been closed.