My Oracle Support Banner

User Applet "Define Filter" Functionality Does Not working (Doc ID 2469307.1)

Last updated on FEBRUARY 22, 2019

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.