JWP creates forced traces
Article ID: 127047
Updated On:
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'.
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:
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
Feedback
Powered by
