2 Replies Latest reply on Mar 15, 2019 9:42 AM by Christian Berg

    OBIEE

    3744064

      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

        • 1. Re: OBIEE
          Joel Acha

          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

          • 2. Re: OBIEE
            Christian Berg

            +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?