After 9.3.6 RUP13/14, Advanced Search with List Attribute Throws "Error visiting expression", Unable to Load Dynamic List Value in the Advanced Search List Field (Doc ID 2704803.1)

Last updated on NOVEMBER 26, 2021

Applies to:

Symptoms

After applying 9.3.6 RUP13 or RUP14, while trying to perform advanced search with list or multilist in the criteria, getting the below error.
Dynamic list attribute value does not load in the Advanced Search criteria, and find below error in stderr.log


Error

Error visiting expression.
com.agile.util.exception.CMDebugException: Error visiting expression.
com.agile.util.exception.CMDebugException: Error visiting expression.
com.agile.util.exception.CMDebugException: Error visiting expression.
com.agile.util.exception.CMDebugException: Error visiting expression.
com.agile.util.exception.CMDebugException: Error visiting expression.
com.agile.util.exception.CMDebugException: Error visiting expression.
com.agile.util.exception.CMDebugException: Error visiting expression.
com.agile.util.exception.CMDebugException: Error visiting expression.
com.agile.util.exception.CMDebugException: Don't know how to visit class com.agile.admin.metadata.SQLExpr$MultiListContainExpr

Facts

The issue does not happen with advanced search with all list/multilist attributes, but multiple cases are reported


Steps

The issue can be reproduced with multiple cases.

Case 1:

1. Log into Web Client, and run Advanced Search with below criteria:
   Change | Change Orders | Object Search
   Cover Page.Change Analyst | In
   * Note: This can be other multilist attribute where User dynamic list is associated
2. Try to locate the value for Change Analyst field to be set to the advanced search criteria. See the value cannot be loaded
3. In the stderr.log, see the error

Case 2:

1. Log into Java Client as admin user
2. Goto Admin tab, Settings > Data Settings, and open User groups Class
3. Goto User Interface Tab >  General Info > Attributes: General Info
4. Double click and open Category 7 attribute. Make sure this field is visible
5. Goto List Detail Box field, and click View Detail
6. Goto List tab, and add list values. i.e: cat1, cat2, cat3
7. Goto Admin tab > Settings > User Settings > User Groups, and create user group
8. Fill in Category 7 attribute value (i.e. cat1), and save
9. Log into Web Client, and run Advanced Search with below criteria:
   User Groups | User groups | Object Search
   Category | Equal To | cat1
10. In the Web Client UI, Gets error

Changes

Applied 9.3.6 RUP13 or RUP14

Cause

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