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
book
Article ID: 130869
calendar_today
Updated On:
Products
CA Automic Workload Automation - Automation Engine
Issue/Introduction
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.
Cause
Defect
Environment
Oracle databases
Resolution
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.