JWP stuck and outdated search results

Article Id: 130869

Status: Published

Updated On: 12-04-2019 14:12

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.

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.