ISSUE:
******
PRCSINSTANCE PRCSNAME RUN_STATUS DISTRIBUTION_STATUS
--------------- ----------- -------------- ----------------------
471876 TL_GRP_RFRSH NOSUCCESS POSTED
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.
******
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
*******
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.
No comments :
Post a Comment