Application Engine Isssue

ISSUE:
******

PRCSINSTANCE                PRCSNAME                RUN_STATUS           DISTRIBUTION_STATUS                                
---------------            -----------           --------------         ----------------------                              
      471876       TL_GRP_RFRSH      NOSUCCESS               POSTED

ERROR:
*******
PeopleTools 8.51.18 - Application Engine Server
Copyright (c) 1988-2014 Oracle and/or its affiliates.
All Rights Reserved
PSAESRV started service request at 02.26.08 2014-04-01
All Processing Suspended: Restart OPRID=BATCH, RUNID=TIMEADMN, PI=472696 (108,503)
PSAESRV completed service request at 02.26.08 2014-04-01

DESCRIPTION:
*************
Process Instance : 471876 is trying to run an AE job(472696). But the PI:472696 is in "cancal" status.
For the same we cannot delete the PI:472696(In PIA Delete option will be unhighlighted).
If we try to re-run the PI:471876 again it is going to "NOSUCCESS" status.

SOLUTION:
**********
select * from ps_aeruncontrol;
create table ps_aeruncontrol_bkp as select * from ps_aeruncontrol
DELETE FROM ps_aeruncontrol where process_instance='472696'
commit
Now, after re-running the PI : 471876, it went to SUCCESS POSTED.