.

I think if you handle the Do-Select logic in the PeopleCode itself (may be populating a rowset initially and traverse the rowset and do ur rest of the logic..), AE will not be aborted.. I'm not sure about this but i remember reading it somewhere that it is because of some SQL cursor not getting closed due to the error in peoplecode.

under a Step Properties there is "On Error" drop down. Have you tried changing that to Ignore or Suppress?

You can specify how PeopleSoft Application Engine should respond to an error at the step level. The On Error routine behaves the same for both SQL and PeopleCode actions. The program only terminates on errors, not warnings.
Available options are:
• Abort: The application terminates with an error message.
• Ignore: The program continues but logs an error message.
• Suppress:The program continues and presents no error message.

Hello,

Thank you for your reply.
My issue got resolved. I am posting it for those who are facing same issue.

Instead of using below structure-
Step 01: Do Select - Populates rows into the State record
Step 02: PeopleCode- I have called CI which processes each row and save into Job record.

I have removed Do Select and implement same logic into PeopleCode only.
I have used RowSet logic to process the rows and it is working fine.

When Critical error occurs DoSelect loop Aborted even if you have used Try Catch loop and Step Properties"On Error" drop down set to "Ignore".

Hope this will help you.

Regards,
Ganesh Pawar

Thanks for sharing your solution with us Ganesh! I'm glade you were able to figure out.

Great to know that it worked!