JWP stuck and outdated search results

book

Article ID: 130869

calendar_today

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.

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.