JWP stuck and outdated search results
Article ID: 130869
Updated On:
Products
CA Automic Workload Automation - Automation Engine
AUTOMIC WORKLOAD AUTOMATION
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.
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.
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.
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.
Feedback
Powered by
