JWP stuck and outdated search results
search cancel

JWP stuck and outdated search results


Article ID: 130869


Updated On:


CA Automic Workload Automation - Automation Engine


The JWP gets stuck and does not updated new objects. This causes an outdated list in the search results.

U00045015 The previous error was caused by 'java.sql.SQLSyntaxErrorException: "ORA-01795: maximum number of expressions in a list is 1000
"' at 'oracle.jdbc.driver.T4CTTIoer.processError():450'.
U00003620 Routine 'com.automic.search.lucene.builder.IndexBuilder' forces trace because of error.
U00003450 The TRACE file was opened with the switches '0000000000000000'.
U00003449 Output to the TRACE file is finished.


Oracle databases




Update to a fix version listed below or a newer version if available.

Component(s): Automation Engine

Automation Engine 12.2.3 - Planned release date: 06/04/2019

Public short description EN: 
Search cannot be used for new imported objects in Oracle databases.

Public description EN: 
An issue with the index builder functionality required for searching objects has been fixed. It caused a database error on Oracle when a large number of objects was imported at once.