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: