VSMGUI User Activity Log
(Doc ID 2197736.1)
Last updated on FEBRUARY 25, 2021
Applies to:
Oracle StorageTek Virtual Storage Manager (VSM) GUI - Version 1.1 and laterInformation 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
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |