The RESETGEN command is failing to reset an Application's generation with the error "Application <application _name> is active"

Products

• DSERIES- SERVER
• CA Workload Automation DE - System Agent (dSeries)

Issue/Introduction

is active"" />

Description:

The RESETGEN command from CLI perspective is failing to reset an Application's generation with the error "Application <application_name> is active". However, all generations of this Application are shown in the Monitor view on the Desktop Client as completed.

Solution:

The reason for this error is that one or more of the previous generations of the Application was not updated into the COMPLETE state.

If all generations of the Application were shown as completed in the Monitor view - execute a query against the database's ESP_WSS_APPL table for any applications with the STATUS field not updated to 2 ('COMPLETE'). For example;

SQL> select APPL_ID, APPL_GEN_NO from ESP_WSS_APPL where APPL_NAME = '<application_name>' and STATUS != 2;

For all application's generations returned as not completed, the STATUS field of the ESP_WSS_APPL table should be updated to 2. The steps to do this are:

1. Shutdown CA Workload Automation DE (dSeries) server.
   
   
2. Update mentioned field and commit the transaction:
   SQL> update ESP_WSS_APPL set STATUS = 2 where APPL_NAME = '<application_name>' and APPL_GEN_NO = <number>;
   SQL> commit;
   
   
3. Start the CAWA DE server

Environment

Release: CAWAS999000-11.1-Workload Automation-Agent for Application Services
Component: