JWP creates forced traces

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

The JWP gets stuck and does not show the latest objects in the search.

20190212/073421.718 - 23 U00045014 Exception 'com.automic.database.api.DBException: "SELECT MIN(OH_ModDate) FROM OH WHERE OH_ModDate IS NOT NULL AND OH_Idnr IN()
20190212/073422.281 - 23 U00045015 The previous error was caused by 'java.sql.SQLSyntaxErrorException: "ORA-01795: maximum number of expressions in a list is 1000
20190212/073422.281 - 23 "' at 'oracle.jdbc.driver.T4CTTIoer.processError():450'.
20190212/073422.281 - 23 U00003620 Routine 'com.automic.search.lucene.builder.IndexBuilder' forces trace because of error.
20190212/073422.285 - 23 U00003450 The TRACE file was opened with the switches '0000000000000000'.

Cause

Defect.

Environment

Release: AUTWAB99000-12.2-Automic Workload Automation-Base Edition
Component:

Resolution

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: Automation Engine

Automation Engine 12.3.0 - Available

Automation Engine 12.2.3 - Available