OAM 11g: Search For User Sessions In OAM Console Session Management Page Gives Error (Doc ID 1446568.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Access Manager - Version: 11.1.1.5.0 to 11.1.1.5.0
Information in this document applies to any platform.

Symptoms



Problems when viewing User Session information in the Oracle Access Manager (OAM) 11gR1 OAM Console Session Management page.

Symptom 1

Reported with OAM Server 11.1.1.5.0 on Windows 2003 with WebGate 10.1.4.3 for IIS 6.

OAM Single Sign-On (SSO) login is successful via the WebGate protected resource but it is not possible to view the user sessions in the Session Management tab within the OAM console.

Search in Session Management page for User ID Starts With <part of username>* produces the JBO error detailed below, in a popup window:

JBO-29114 ADFContext is not setup to process messages for this exception. Use the exception stack trace and error code to investigate the root cause of this exception. Root cause error code is JBO-29000

ADF_FACES-60097:For more information, please see the server's error log for an entry beginning with ADF_FACES-60096:Server Exception during PPS, #56



The WebLogic AdminServer log file shows entries similar to the following:

....
<Feb 21, 2012 1:12:17 PM EET> <Warning> <oracle.adf.controller.faces.lifecycle.Utils> <BEA-000000> <ADF: Adding the following JSF error message: oracle.sql.TIMESTAMP cannot be cast to java.util.Date
java.lang.ClassCastException: oracle.sql.TIMESTAMP cannot be cast to java.util.Date
at model.SessionSearchVOImpl.createRowFromResultSet(SessionSearchVOImpl.java:599)
at oracle.jbo.server.ViewObjectImpl.createInstanceFromResultSet(ViewObjectImpl.java:5676)
at oracle.jbo.server.QueryCollection.populateRow(QueryCollection.java:3596)
at oracle.jbo.server.QueryCollection.fetch(QueryCollection.java:3455)
at oracle.jbo.server.QueryCollection.get(QueryCollection.java:2205)
at oracle.jbo.server.ViewRowSetImpl.getRow(ViewRowSetImpl.java:5041)
at oracle.jbo.server.ViewRowSetIteratorImpl.doFetch(ViewRowSetIteratorImpl.java:2935)
at oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2791)
at oracle.jbo.server.ViewRowSetIteratorImpl.refresh(ViewRowSetIteratorImpl.java:3032)
at oracle.jbo.server.ViewRowSetImpl.notifyRefresh(ViewRowSetImpl.java:2751)
at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:1225)
at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:1363)
at oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:1269)
at oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:1254)
at oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:6897)
at oracle.adf.model.bc4j.DCJboDataControl.executeIteratorBinding(DCJboDataControl.java:1322)
at oracle.adf.model.binding.DCIteratorBinding.doExecuteQuery(DCIteratorBinding.java:2179)
at oracle.adf.model.binding.DCIteratorBinding.executeQuery(DCIteratorBinding.java:2140)
at oracle.jbo.uicli.binding.JUSearchBindingCustomizer.applyAndExecuteViewCriteria(JUSearchBindingCustomizer.java:608)
at oracle.adfinternal.view.faces.model.binding.FacesCtrlSearchBinding.processQuery(FacesCtrlSearchBinding.java:447)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
....

<Feb 21, 2012 1:12:17 PM EET> <Warning> <oracle.adf.view.rich.component.fragment.UIXRegion> <ADF_FACES-00009> <Error processing viewId: /sessionMgmt_tf/sessionMgmt URI: /taskflows/session/mgmt/sessionMgmt.jsff actual-URI: /taskflows/session/mgmt/sessionMgmt.jsff.
java.lang.ClassCastException: oracle.sql.TIMESTAMP cannot be cast to java.util.Date
at model.SessionSearchVOImpl.createRowFromResultSet(SessionSearchVOImpl.java:599)
at oracle.jbo.server.ViewObjectImpl.createInstanceFromResultSet(ViewObjectImpl.java:5676)
at oracle.jbo.server.QueryCollection.populateRow(QueryCollection.java:3596)
at oracle.jbo.server.QueryCollection.fetch(QueryCollection.java:3455)
at oracle.jbo.server.QueryCollection.get(QueryCollection.java:2205)
at oracle.jbo.server.ViewRowSetImpl.getRow(ViewRowSetImpl.java:5041)


Symptom 2

This issue was reported with OAM Server 11.1.1.5.0 on Windows 64bit and Linux x86-64 platforms.

OAM Single Sign-On (SSO) login is successful via the WebGate protected resource.

Subsequent search for user sessions in the OAM Console Session Management page produces the following error in a popup box:

java.util.Date cannot be cast to java.lang.String

Or alternatively the following error:

java.util.Date cannot be cast to java.lang.Boolean


User sessions are returned but the Session Management Search results page does not display the data correctly. The columns are populated with the wrong values e.g. The column User ID field displays the Client IP Address, the Client IP Address field contains the User ID value etc.


The WebLogic AdminServer log shows similar to the following:

####<Jan 24, 2012 4:27:03 PM CET> <Warning> <oracle.adf.controller.faces.lifecycle.Utils> <oam.oracle.com> <AdminServer> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <weblogic> <> <f5fd6014281c62f0:-5eb3be83:134fb713e9a:-8000-0000000000000f2d> <1327418823290> <BEA-000000> <ADF: Adding the following JSF error message: java.sql.Timestamp cannot be cast to java.lang.String
java.lang.ClassCastException: java.sql.Timestamp cannot be cast to java.lang.String
at model.SessionSearchVORowImpl.getIdentityDomain(SessionSearchVORowImpl.java:312)
at model.SessionSearchVORowImpl$AttributesEnum$10.get(SessionSearchVORowImpl.java:110)
at model.SessionSearchVORowImpl.getAttrInvokeAccessor(SessionSearchVORowImpl.java:334)
at oracle.jbo.server.ViewRowImpl.getAttribute(ViewRowImpl.java:870)
at oracle.jbo.uicli.binding.JUCtrlValueBinding.internalGetAttributeValueFromRow(JUCtrlValueBinding.java:1157)
at oracle.jbo.uicli.binding.JUCtrlValueBinding.getAttributeFromRow(JUCtrlValueBinding.java:751)
at oracle.jbo.uicli.binding.JUCtrlValueBinding.getInputValueInRow(JUCtrlValueBinding.java:2826)
at oracle.jbo.uicli.binding.JUCtrlValueBinding.getInputValue(JUCtrlValueBinding.java:2730)
at oracle.jbo.uicli.binding.JUCtrlHierNodeBinding.internalGet(JUCtrlHierNodeBinding.java:1520)
at oracle.adfinternal.view.faces.model.binding.FacesCtrlHierNodeBinding.internalGet(FacesCtrlHierNodeBinding.java:119)
....

Or:

[2012-01-09T15:11:43.239+02:00] [AdminServer] [WARNING] []
[oracle.adf.controller.faces.lifecycle.Utils] [tid: [ACTIVE].ExecuteThread:
'2' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: weblogic]
[ecid: 4539a5ecbfde57cd:-700fc796:1348a040073:-8000-00000000000098b6,0]
[APP: oam_admin#11.1.1.3.0] ADF: Adding the following JSF error message:
java.util.Date cannot be cast to java.lang.Boolean[[
java.lang.ClassCastException: java.util.Date cannot be cast to
java.lang.Boolean
at model.SessionSearchVOImpl.executeSMESearch(SessionSearchVOImpl.java:464)
at
model.SessionSearchVOImpl.retrieveResultSet(SessionSearchVOImpl.java:554)
at
model.SessionSearchVOImpl.executeQueryForCollection(SessionSearchVOImpl.java:
322)
at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:1183)
at
oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:1
363)
at
oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:1269
)
at oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:1254)
at oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:6897)
....

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