User Applet "Define Filter" Functionality Does Not working
(Doc ID 2469307.1)
Last updated on APRIL 09, 2024
Applies to:
Oracle WebCenter Content - Version 11.1.1.9.0 to 11.1.1.9.0 [Release 11g]Information in this document applies to any platform.
Symptoms
When filtering on fields in the user admin applet the following error is received.
Caused by: intradoc.data.DataException: !csDbUnableToCreateResultSet,SELECT Users.* FROM Users
WHERE ((Revisions.dUserAuthType LIKE 'LOCAL' )) ORDER by dName!$[FMWGEN][SQLServer JDBC Driver][SQLServer]The multi-part identifier "Revisions.dUserAuthType" could not be bound.
at intradoc.jdbc.JdbcWorkspace.handleSQLException(JdbcWorkspace.java:2729)
at intradoc.jdbc.JdbcWorkspace.createResultSetSQL(JdbcWorkspace.java:927)
at intradoc.jdbc.JdbcWorkspace.createResultSetSQL(JdbcWorkspace.java:866)
at intradoc.server.Service.createResultSetSQL(Service.java:3774)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at intradoc.common.IdcMethodHolder.invokeMethod(IdcMethodHolder.java:86)
at intradoc.common.ClassHelperUtils.executeMethodEx(ClassHelperUtils.java:310)
at intradoc.common.ClassHelperUtils.executeMethod(ClassHelperUtils.java:295)
at intradoc.server.Service.doCodeEx(Service.java:643)
at intradoc.server.Service.doCode(Service.java:598)
at intradoc.server.ServiceRequestImplementor.doAction(ServiceRequestImplementor.java:1795)
... 48 more
Caused by: java.sql.SQLException: [FMWGEN][SQLServer JDBC Driver][SQLServer]The multi-part identifier "Revisions.dUserAuthType" could not be bound.
at weblogic.jdbc.sqlserverbase.ddb_.b(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb_.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb9.b(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb9.a(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddr.v(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddq.a(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddm.a(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddm.t(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddm.d(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddn.a(Unknown Source)
at weblogic.jdbc.sqlserver.ddj.h(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.v(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.u(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.u(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.u(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.executeQuery(Unknown Source)
at weblogic.jdbc.wrapper.Statement.executeQuery(Statement.java:506)
at intradoc.jdbc.JdbcWorkspace.createResultSetSQL(JdbcWorkspace.java:898)
... 60 more
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 |
| Cause |
| Solution |
| References |