User Admin Applet Fields throw ORA-00904 SQL Error Due to Querying Incorrect Table
(Doc ID 2468672.1)
Last updated on MARCH 18, 2024
Applies to:
Oracle WebCenter Content - Version 12.2.1.3.0 and laterInformation 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,sample.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
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 |