OAC: BI Publisher Diagnostic Logs Produce An Error While Retrieving Sql_id From Gvsession Database Table (Doc ID 2652979.1)

Last updated on MARCH 26, 2020

Applies to:

Symptoms

On : OAC 5.5, Layered Compute - BI Publisher

BI Publisher diagnostic logs produce an error while retrieving sql_id from the gv$session database table. This doesn't have any impact on the report queries and appears to be a permissions issue. It seems to happen when you enable full diagnostic logging. Excerpt of log shown below.

>>>
2019-12-06T21:46:24.759+00:00][dp id:1027343192][sch info:JobId:1955[ESS RequestId:null]]GetSQLID Query Timeout: 100
[2019-12-06T21:46:24.822+00:00][dp id:1027343192][sch info:JobId:1955[ESS RequestId:null]]java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:495)
.
.
.
.
Caused by: Error : 942, Position : 199, Sql = SELECT NVL(s.sql_id,s.prev_sql_id) as SQL_ID
  ,DECODE(s.sql_Hash_value,0,s.prev_hash_value,s.sql_Hash_value) as SQL_HASH_VALUE
  ,NVL(s.SQL_EXEC_ID,s.PREV_EXEC_ID) as SQL_EXEC_ID
  FROM gv$session s
  WHERE 1 =1
  AND s.STATUS IN ('ACTIVE','INACTIVE')
  AND s.module = :P_module
  AND s.action = :P_action
, OriginalSql = SELECT NVL(s.sql_id,s.prev_sql_id) as SQL_ID
  ,DECODE(s.sql_Hash_value,0,s.prev_hash_value,s.sql_Hash_value) as SQL_HASH_VALUE
  ,NVL(s.SQL_EXEC_ID,s.PREV_EXEC_ID) as SQL_EXEC_ID
  FROM gv$session s
  WHERE 1 =1
  AND s.STATUS IN ('ACTIVE','INACTIVE')
  AND s.module = :P_module
  AND s.action = :P_action
, Error Msg = ORA-00942: table or view does not exist

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:499)
... 42 more
 

Related Error code:
ORA-00942

This issue is reproduced when you enable full diagnostic logging.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.