Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE

Received Response
1
Views
2
Comments
User_15J6I
User_15J6I Rank 5 - Community Champion
edited Aug 13, 2024 5:29PM in Oracle Analytics Cloud and Server

Hello, someone can help me with this error:

Estado: HY000. Código: 17001. [nQSError: 17001] Código de error de Oracle: 1445, mensaje: ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table at OCI call OCIStmtExecute. (HY000),

the answer that I found indicates that it is solved by removing the rowid in the view but in my case I am not sending it to call, does anyone can help?  thanks

Answers

  • Joel
    Joel Rank 8 - Analytics Strategist

    What version of OBIEE? Have you checked your log files for the exact SQL generated by the BI Server? Does the SQL run when you run it directly on the DB ie in SQL Developer/ TOAD/ SQL*Plus etc?

    There error indicates that it is not exactly an OBIEE issue but an issue propagated from the Oracle data source hence the ORA-01445 error

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    +1 to Joel. That's a pure database issue.

    What are you calling from OBIEE? A view that you imported as an object? A manually written opaque view that you wrote in the physical layer? A view that itself if built upon views?