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

Creating table(view) using select at RPD failing

Received Response
4
Views
3
Comments
User_CN4UP
User_CN4UP Rank 2 - Community Beginner
edited August 13 in Oracle Analytics Cloud and Server

I am trying to create a table using select at physical layer connection to OCI. But i getting error view viewing data(ORA-00936:missing expression at OCI call ocistmtexecute) or deploy view([nQSError: 17001] Oracle Error code: 1031, message: ORA-01031: insufficient privileges

 at OCI call OCIStmtExecute.).

But Update row count working fine. Can anyone provide solution for this to get table(view) created at RPD.

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    ORA-01031: insufficient privileges

    This is a database error message, not an OBIEE/OA error, therefore you should look at what you are doing in the database and fix your privileges issues there.

  • User_CN4UP
    User_CN4UP Rank 2 - Community Beginner

    I am able to view data for opaque which is already created, for that i am trying to add one more column. Once i add column to opaque view i am not seeing that column under opaque view and while deploy view i got error.

    for same select query i am able to create direct database query from BI front end.

    With this scenarios working, is it still database privileges issue or anything to check at RPD

    I have created new opaque view ,It got created successfully but under view name dont see list of columns,. When tried to view data got error as (ORA-00936:missing expression at OCI call ocistmtexecute)

  • User_CN4UP
    User_CN4UP Rank 2 - Community Beginner

    I am able to fix this.

    Solution: once we add column under columns tab. We are good and issue fixed.