VSMGUI User Activity Log (Doc ID 2197736.1)

Last updated on OCTOBER 31, 2016

Applies to:

Oracle StorageTek Virtual Storage Manager (VSM) GUI - Version 1.1 and later
Information in this document applies to any platform.

Symptoms

When selecting a user in the user activity log the customer has a pop-up for an exception in the SQL executed in background.

ADF_FACES-60096:Server Exception during PPR


In the VSMGUI log you can see:

#### <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <ADF_FACES-60096:Server Exception during PPR, #5


and

javax.el.ELException: /buttons/RowDetailButton.jsf @2,184
actionListener="#{backingBeanScope.rowDetailBean.showSelectedRows}":
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement
preparation. Statement: SELECT UserActivityLog.USERNAME,
UserActivityLog.EVENT_TYPE, UserActivityLog.FILE_TYPE,
UserActivityLog.TAPEPLEX_NAME, UserActivityLog.FILE_NAME,
UserActivityLog.ACTIVITY_TIME FROM USER_ACTIVITY_LOG UserActivityLog WHERE
((USERNAME='hmtj625' AND ACTIVITY_TIME='2016-10-25 15:45:43.090109')) ORDER
BY UserActivityLog.ACTIVITY_TIME DESC

 

Changes

 None

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms