My Oracle Support Banner

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 06, 2020

Applies to:

Oracle Agile PLM Framework - Version 9.3.6.0 and later
Information in this document applies to any platform.

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

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.