S_QOS_SNAPSHOT not updated - OCI_ERROR - ORA-06550: line 1, column 7: PLS-00905: object (username).SPN_DE_UPDATEQOSSNAPSHOT is invalid

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

The table S_QOS_SNAPSHOT is not being updated with current values.

In the data_engine log I can see the following error, where (username) is the username configured in data_engine (e.g. the Oracle tablespace username):

OCI_ERROR - ORA-06550: line 1, column 7:

PLS-00905: object (username).SPN_DE_UPDATEQOSSNAPSHOT is invalid

ORA-06550: line 1, column 7:

Environment

Release : 20.3

Component :

Cause

missing permissions on Oracle DB

Resolution

The following grant should resolve this issue:

grant select on v$session to (username);

In some cases we have seen where upgrading Oracle 12 to 12.2 has caused this grant to be dropped for unknown reasons.