Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

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 Forum

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 Acha
    Joel Acha Rank 8 - Analytics & AI 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?