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

Question

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.

ManishPandey · Answer

thanks manoj,

it's database permission related issue.

RichardChan · Answer

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

Manoj Dixit · Answer

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