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 220.127.116.11 and later
Information in this document applies to any platform.
When attempting to search specific user by Quick Search, the following error occurs.
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)
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!