Agile Quick Search of Users Shows Error "Wildcard query resulted in too many results" (Doc ID 1387996.1)

Last updated on AUGUST 13, 2017

Applies to:

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

Symptoms

On : 9.3.0.2 version, Searches, 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