ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
JWP stuck and outdated search results
Article ID: 130869
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.
Update to a fix version listed below or a newer version if available.
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.