My Oracle Support Banner

User Admin Applet Fields Throw ORA-00904 SQL Error Due to Querying Incorrect Table (Doc ID 2468672.1)

Last updated on MARCH 12, 2021

Applies to:

Oracle WebCenter Content - Version 12.2.1.3.0 and later
Information in this document applies to any platform.

Symptoms

When using "Define Filter" in the User Admin Applet, selecting any of the following options throws a SQL error

User Name, Full Name, Email Address, User Locale, User Timezone



ERROR
-----------------------
Error is:

Unable to execute service GET_DATARESULTSET and funciton createResultSetSQL.  The error was caused by an internally generated issue. The error has been logged

 

And, the query throws ORA-00904 error as below:

 WHERE (((dUserAuthType LIKE 'EXTERNAL' ) AND (dUserType LIKE '' OR Revisions.dUserType IS NULL))) ORDER by dName, Error Msg = ORA-00904: "REVISIONS"."DUSERTYPE": invalid identifier



STEPS
-----------------------
The issue can be reproduced with the following steps:

1. Launch User Admin applet

2. Select Define Filter

3. Select the checkbox for any of the following (leave it blank)

     * Note: occurs with the following fields: User Name, Full Name, E-mail Address, User Locale, User Timezone

4. Note the pop up error:   

Unable to execute service GET_DATARESULTSET and function createResultSetSQL.

The error was caused by an internally generated issue.  The error has been logged

6. Trace log with Services tracing shows the query to Revisions.dUserType and throws ORA-00904:"REVISIONS"."DUSERTYPE": invalid identifier

     

!csUserEventMessage,weblogic,host.company.com:16200!$ intradoc.common.ServiceException: !csServiceDataException,GET_DATARESULTSET,createResultSetSQL!$

      *ScriptStack GET_DATARESULTSET

       createResultSetSQL,**no captured values**

       Caused by: intradoc.data.DataException: !csJdbcGenericError

       Caused by: java.sql.SQLSyntaxErrorException: ORA-00904:"REVISIONS"."DUSERTYPE": invalid identifier

       Caused by: Error : 904, Position : 103, Sql = SELECT Users.* FROM Users WHERE (((dUserAuthType LIKE 'LOCAL' ) AND (dUserType LIKE '' OR Revisions.dUserType IS NULL))) ORDER by dName, OriginalSql = SELECT Users.* FROM Users

 



Changes

 

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
References


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