Agile Quick Search of Users Shows Error "Wildcard query resulted in too many results"
(Doc ID 1387996.1)
Last updated on AUGUST 22, 2023
Applies to:
Oracle Agile PLM Framework - Version 9.3.0.2 and laterInformation 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
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 |
Cause |
Solution |
References |