Agile Quick Search of Users Shows Error "Wildcard query resulted in too many results"

(Doc ID 1387996.1)

Last updated on NOVEMBER 23, 2017

Applies to:

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

Symptoms

When attempting to search specific user by Quick Search, the following error occurs.

Error

Wildcard query resulted in too many results, please refine your criteria and try again

In server log, detailed error is:

11/12/21 02:38:28 com.agile.util.exception.CMAppException: Wildcard query resulted in too many results, please refine your criteria and try again.
11/12/21 02:38:28 at com.agile.cs.query.QueryCacheResult.convertSQLException(QueryCacheResult.java:5973)
11/12/21 02:38:28 at com.agile.cs.query.QueryCacheResult.execute(QueryCacheResult.java:753)
11/12/21 02:38:28 at com.agile.cs.query.QueryServiceResult.marshalTable(QueryServiceResult.java:278)
11/12/21 02:38:28 at com.agile.cs.query.QueryService.marshalTable(QueryService.java:465)
11/12/21 02:38:28 at com.agile.cs.query.QuerySessionBean.executeQuery(QuerySessionBean.java:331)

Steps

The issue can be reproduced at will with the following steps:
1. Log into Web Client.
2. Type 001 to Quick Search against Users
3. Error occurred.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms