OBIEE 12C Usage Tracking Dashboard Error

Question

Hi All,

when i am trying to run the top usage report in OBIEE 12c ,i am getting below error

OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.

State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS.

State: HY000. Code: 43119. [nQSError: 43119] Query Failed:

State: HY000. Code: 17001.  
Please have your System Administrator look at the log for more details on this error. (HY000)

State: HY000. Code: 17010.

SQL Issued: SELECT 0 s_0, "Usage Tracking"."Personal Data"."Name" s_1, "Usage Tracking"."Users"."User Name" s_2, "Usage Tracking"."Measures"."Query Count" s_3, MAX("Usage Tracking"."Calendar"."Date") s_4 FROM "Usage Tracking" FETCH FIRST 10000000 ROWS ONLY

Could you please help me to fix the issue.

Thanks,

Sudheer

Gianni Ceresa · Answer

As Joel pointed out there is your issue. A standard Oracle database error. Are you using the BIPLATFORM account to query that table? Because you access the tables directly without a schema, so it can only work if you use the real owner of those tables, by default BIPLATFORM. If you are using a different user you need to define the schema which contains those tables in the RPD, so the query will be SELECT ... FROM .

2cc95da3-ac23-4bc7-9673-0f20f0d79379 · Answer

If i ran the above query in all environment SQL Devlopers ,it showing the same error like below

ORA-00942: table or view does not exist

Joel Acha · Answer

I can see this:

[nQSError: 17001] Oracle Error code: 942, message: ORA-00942: table or view does not exist

at OCI call OCIStmtExecute.

[nQSError: 43119] Query Failed:

It looks like the DB user used to run this is missing permissions on some tables. What happens when you run this from your log directly in SQL Developer or TOAD?

select distinct 0 as c1,

D1.c3 as c2,

D1.c4 as c3,

D1.c1 as c4,

D1.c2 as c5

from

(select sum(D1.c1) over (partition by D1.c4)  as c1,

D1.c2 as c2,

D1.c3 as c3,

D1.c4 as c4

from

(select count(T176576.QUERY_TEXT) as c1,

max(T176599.DAY_DT) as c2,

T376998.Name as c3,

T176573.LOGIN as c4

from

(

S_ETL_DAY T176599 inner join (

(SELECT DISTINCT USER_NAME AS LOGIN, NULL AS RESP FROM S_NQ_ACCT) T176573 inner join S_NQ_ACCT T176576 On T176573.LOGIN = T176576.USER_NAME) On T176576.START_DT = T176599.DAY_DT) left outer join

(select distinct 'u'||emplid as emp_id,name from wc_emp_personal_data_d

) T376998 On T176573.LOGIN = T376998.Emp_ID

group by T176573.LOGIN, T376998.Name

) D1

order by c5 desc, c3, c2