Not able to delete a client from AWI

Products

• CA Automic Workload Automation - Automation Engine
• CA Automic One Automation

Issue/Introduction

In v21 it is supposed to be possible to remove a (stopped) client from AWI (client 0) but we are not able to:

 

The following error is displayed in Client History:

2022-11-14 09:51:44 - U00045119 User 'UC/UC' initiated deletion of Client '101'.
2022-11-14 09:51:44 - U00045282 Starting to delete Client 101
2022-11-14 09:51:44 - U00045121 Deleting '7' objects from Client '101' ...
2022-11-14 09:51:44 - U00045204 An error occurred while deleting. Forced Traces have been created.
2022-11-14 09:51:44 - U00045203 Deleting Client '101' failed.

The generated Forced Trace contains the following error:

20221114/104536.656 - 42        java.lang.StringIndexOutOfBoundsException: begin 6, end 4, length 9
20221114/104536.656 - 42        at java.base/java.lang.String.checkBoundsBeginEnd(String.java:3319)
20221114/104536.656 - 42        at java.base/java.lang.String.substring(String.java:1874)
20221114/104536.656 - 42        at com.automic.persistence.impl.ClientDeleteImpl.lambda$analyseTables$11(ClientDeleteImpl.java:153)
20221114/104536.656 - 42        at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
20221114/104536.656 - 42        at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
20221114/104536.656 - 42        at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
20221114/104536.656 - 42        at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:484)
20221114/104536.656 - 42        at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:474)
20221114/104536.656 - 42        at java.base/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
20221114/104536.656 - 42        at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
20221114/104536.656 - 42        at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
20221114/104536.656 - 42        at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
20221114/104536.656 - 42        at com.automic.persistence.impl.ClientDeleteImpl.lambda$analyseTables$12(ClientDeleteImpl.java:151)
20221114/104536.656 - 42        at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
20221114/104536.656 - 42        at com.automic.persistence.impl.ClientDeleteImpl.analyseTables(ClientDeleteImpl.java:149)

There is also an issue in AWI: Even though the action is finished in Client History in the Client list the status remains 'Deleting' even after logging out and in of Client 0

Environment

Release : 21.0.4

Cause

This is a defect

Resolution

Workaround:

Use the Client Copy Utility to remove the client

Solution:

This has been fixed with the release of Automation Engine 21.0.5, available 13 February, 2023