You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

AE prog Aborting

6 replies [Last post]
gpawar.ps's picture
User offline. Last seen 10 years 26 weeks ago. Offline
Joined: 02/06/2009
Posts: 10

I have created AE programme to process rows of record with the help of CI code. My design is as below-
Section Main
Step 01: Do While - Populates rows into the State record
Step 02: PeopleCode- I have called CI which processes each row and save into Job record.

Everything is fine if all rows are correct but if any row with error found AE prog. Aborted. I want to skip error rows to be skiped and AE should continue with the remaining rows.

I am using Try-Catch but no help.

Please suggest me any workaround.

Regards,
Ganesh

Regards,
Ganesh Pawar

gpawar.ps's picture
User offline. Last seen 10 years 26 weeks ago. Offline
Joined: 02/06/2009
Posts: 10
Re: AE prog Aborting

.

Regards,
Ganesh Pawar

Ashar's picture
User offline. Last seen 4 years 35 weeks ago. Offline
Joined: 03/26/2008
Posts: 227
Re: AE prog Aborting

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.

Lepa's picture
User offline. Last seen 2 years 2 weeks ago. Offline
Joined: 06/23/2008
Posts: 591
Re: AE prog Aborting

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.

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog

Ganesh Pawar's picture
Ganesh Pawar (not verified)
Re: AE prog Aborting

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

Lepa's picture
User offline. Last seen 2 years 2 weeks ago. Offline
Joined: 06/23/2008
Posts: 591
Re: AE prog Aborting

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

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog

Ashar's picture
User offline. Last seen 4 years 35 weeks ago. Offline
Joined: 03/26/2008
Posts: 227
Re: AE prog Aborting

Great to know that it worked!