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
Title | Under | Posted on |
---|---|---|
Component interface Error: no rows exist for the specified keys | PeopleSoft Technical | 03/15/2019 - 3:54am |
ADD 24 months starting from current month.(peoplesoft) | PeopleSoft Functional | 07/29/2018 - 8:44pm |
TRC values dropdown | PeopleSoft Technical | 04/04/2018 - 12:54am |
how to find missing sequence in GRID and print the mising sequence number while saving through peoplecode | PeopleSoft Technical | 09/11/2017 - 4:49am |
.
Regards,
Ganesh Pawar
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.
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
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.
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
Great to know that it worked!