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

ORA-20001: YOU CAN NOT CREATE, ALTER OR DROP (Kindly Use SUPERPKG)

Received Response
52
Views
4
Comments
ManishPandey
ManishPandey Rank 2 - Community Beginner
edited Aug 13, 2024 7:09PM in Oracle Analytics Cloud and Server

Hi Experts,

i'm very new in oracle Obiee.

i have created one analysis but its given error message like

tate: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 17001] Oracle Error code: 604, message: ORA-00604: error occurred at recursive SQL level 2 ORA-20001: YOU CAN NOT CREATE, ALTER OR DROP (Kindly Use SUPERPKG) ORA-06512: at line 4 at OCI call OCIStmtExecute. [nQSError: 17010] SQL statement preparation failed. (HY000)

SQL Issued: SELECT 0 s_0, "AdvtBills"."Bills"."CLIENTNAME" s_1, "AdvtBills"."Bills"."DIVN" s_2, "AdvtBills"."Bills"."PrvBillAmt" s_3 FROM "AdvtBills" WHERE ("TimeDim"."YEAR" = '2014') FETCH FIRST 65001 ROWS ONLY

i don't understand whats this error message is.

please help me

thanks

Manish.

Answers

  • ManishPandey
    ManishPandey Rank 2 - Community Beginner

    Any Suggestion?

  • Manoj Dixit
    Manoj Dixit Rank 6 - Analytics Lead

    OBI generates SQL Queries, sends them to a backend source(s) so that once the data is returned, it can display on the UI. In your case, however, there seems to be some issue with the execution of the SQL generated by OBI.

    Did you refer to Oracle Database Manauls esp. related to Data Definition and Error messages? What does your DBA say about the issue?

    Regards.

    Edit: When did Oracle start throwing error messages with text something like "kindly"?

  • RichardChan
    RichardChan Rank 6 - Analytics Lead

    Try reporting on one column at a time to see when the error occurs.

    Are you familiar with the RPD ? If so you can trace back the offending column to see how it has been configured

    Richard Chan

    Neodata Australia

  • ManishPandey
    ManishPandey Rank 2 - Community Beginner

    thanks manoj,

    it's database permission related issue.