JWP stuck and outdated search results


Article ID: 130869


Updated On:


CA Automic Workload Automation - Automation Engine AUTOMIC WORKLOAD AUTOMATION


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.