ILM - missing/abormal information in the logs after the system had been upgrade to 21.0.7

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

The problem concerns missing messages in the PWP logs during ILM-related operations:

In version 12.3.9 the logs were showing this type of messages

=====================================================================================

20230705/132241.070 - U00005344 ILM: Skip checking as partition '427' has successfully been checked before.
20230705/132241.909 - U00005321 SIM: 'ALTER TABLE UC4.AFC DISABLE CONSTRAINT FK_AFC_APPF'
20230705/132241.929 - U00005321 SIM: 'ALTER TABLE UC4.AJPOP DISABLE CONSTRAINT FK_AJPOP_AJPOV'
20230705/132241.930 - U00005321 SIM: 'ALTER TABLE UC4.AJPFV DISABLE CONSTRAINT FK_AJPFV_AJPPF'
......
20230705/132242.312 - U00005305 ILM: 'ALTER TABLE UC4.AFC DISABLE CONSTRAINT FK_AFC_APPF'
20230705/132242.331 - U00005305 ILM: 'ALTER TABLE UC4.AJPOP DISABLE CONSTRAINT FK_AJPOP_AJPOV'
20230705/132242.339 - U00005305 ILM: 'ALTER TABLE UC4.APDC DISABLE CONSTRAINT FK_APDC_APD'
20230705/132242.345 - U00005305 ILM: 'ALTER TABLE UC4.AJPFV DISABLE CONSTRAINT FK_AJPFV_AJPPF'
20230705/132242.350 - U00005305 ILM: 'ALTER TABLE UC4.AJPOV DISABLE CONSTRAINT FK_AJPOV_AJPPO'

=====================================================================================

Whereas in version 21 the PWP logs contained the following for the same ILM operations.

=====================================================================================

20230714/065423.876 - U00005310 The standard user will be used for ILM processing because no login object has been specified.
20230714/065423.935 - U00005344 ILM: Skip checking as partition ' ' has successfully been checked before.
20230714/065424.788 - U00005321 SIM: 'ALTER TABLE UC4.AFC DISABLE CONSTRAINT FK_AFC_APPF'
20230714/065424.796 - U00005321 SIM: 'ALTER TABLE UC4.AJPOP DISABLE CONSTRAINT FK_AJPOP_AJPOV'.

=====================================================================================

 

1. The U#5344 message no longer contains the number of the checked beforehand, it is replaced by a special character. 
2. The simulation messages are listed but the "ILM: ALTER TABLE ......" instructions are no longer present!!

Environment

Automation Engine 21 

Cause

This is a defect of the Automation Engine up to the fixing version.

Bug Description:

When checking partitions, we have noticed that the partition number is being displayed incorrectly. Additionally, we have observed that when executing SQL commands, specifically the "Change_partition" operation, the corresponding actions are not being logged in our system logs.

 

Resolution

This bug is fixed in the following versions of the Automation Engine

21.0.8 HF5 

21.0.9

Additional Information

Bug ID: AE-33079
Bug Ticket: ILM - missing/abormal information in the logs after 21.0.7 Upgrade