An application will get stuck in APPLWAIT state. The Monitor perspective does not show any previous generation active. The Application propertied has "Wait for previous generation" checked.
The tracelog will show the application starting and then going in the APPLWAIT state
20180510 HH:MM:09.710 [internal:messages] [INFO] DM.Appl.APPLiCATION_XYZ.123: Adding message directly onto our queue. AFM: 20180523 10260969-0100 CAWADE_7500 CAWADE_7500 /MAIN/APPLiCATION_XYZ.123/JOB123 State APPLWAIT Conditions() StatusQ() Userid(user.CAWADE_7500)
CA Workload Automation DE R11.3 / R12
If the application does not need "Wait for previous generation", then uncheck it and save it. When a new generation is built, the application will no longer go on APPLWAIT.
If the "Wait for previous generation" is needed, then you may be required to make some database side changes. It is suggested to contact CA Support for more specific database clean-up procedure.
Note: Database clean-up will require CA WA DE shutdown. CA also recommends to take full back up before make any changes to the DB
To check if you have an older application generation that is not complete, you can run this SELECT statement on the database used by DE.
SELECT * FROM esp_application where appl_name = '<APPL_NAME>' AND state <> 'COMPLETE'