Error when searching with too many options such as "Search in all columns" or "Search in Process"

Document ID : KB000088102
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Error Message :
U00020568 Runtime error in object 'XSEARCH(SET)'

When using the search in the Java-UI and selecting the additional option "Search in all columns" in the "Further options" tab  or "Search in Process" the following errors appear:
 
Error on MSSQL:
U00020568 Runtime error in object 'XSEARCH(SET)', line '00427'. DS return 
code: '0000003590': 'U00003590 UCUDB - DB error: 'SQLExecDirect', 'ERROR ', 
'42000', 'Incorrect syntax
near ')'.''. Error occurred in UCDSFUN at position: 
'DS_SEARCH41'. 

 
Error on Oracle:
"U00020568 Runime error in object 'XSEARCH(SET), DS return code: '0000003590': 'U00003590 UCUDB - DB error: 'OCIStmtExecute','ERROR ', 
".'ORA-00936: missing expression", Error occurred in UCDSFUN at position: 'DS_SEARCH41',"
Environment:
OS Version: N/A
Cause:
Cause type:
Defect
Root Cause: Text search shows error message if too many options are activated, such as "Search in Process" or "Search in all Columns".
Resolution:
Update to a fix version listed below or a newer version if available.

Fix Status: Released

Fix Version(s):
Automation Engine 12.0.2 - Available
Automation Engine 11.2.5 – Available
Additional Information:
Workaround :
The issue starts if 5 options are checked for the search. 

Reduce the number of activated options.