User login
Sponsored links
Recent blog posts
- How to resubmit on Integration Broker message with DONE status
- Message cannot be changed. Message referenced in runtime tables (Doc ID 660969.1)
- PeopleSoft Object Type List
- PeopleSoft Data Integrity Error (124,85)
- Unwanted Save Warnings in Display Only Pages
- Breadcrumb SQL to find the Navigation path for the component in the PIA
- Application Designer Index naming convention
- How to create Trigger in DB2
- Emplid increment automatically
- How can we romove multiple duplicate rows of data printing under each Print command in SQR Program?
Restatable AE program
- Login to post comments
Hi,
I built a restartable AE program. This program reads the data from delivered psft tables and writes into flat files using file layout. The data is read from tables and inserted into temp tables using insert and select (set processing) and then from temp tables it is written into a flat file. Select-insert is done by one step with action SQL and writing flat-file is done by the next step with action peoplecode. Likewise there are many steps and combination of one SQL and peoplecode creates a flat-file.
The problem is when AE aborts at some step and goes to no success in case of data error, and after correcting the data when i restart it doesnt create output flat files but does insert the data into temp tables and goes to success.
Pls help me out.
Thanks
Sammy
Unanswered Forum Posts
| 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 |
Stay updated
Poll
New forum topics
- Component interface Error: no rows exist for the specified keys
- ADD 24 months starting from current month.(peoplesoft)
- TRC values dropdown
- OHS is rendering XML instead of the view or data
- Search Results
- PS Query - Need Dependency and Prunable examples
- PS HCM AWE - Transaction routing to Requestor for approval, when he is the Delegatee by his 1 up Manager
- how to find missing sequence in GRID and print the mising sequence number while saving through peoplecode
Recent comments
- Re: PeopleCode Check Number and Check Letter Functions
2 years 23 weeks ago - Re: nVision Tabular Report through PIA with prompts
2 years 28 weeks ago - Re: PeopleSoft PeopleTools Meta-Tables
2 years 28 weeks ago - Re: PS Query - Need Dependency and Prunable examples
2 years 29 weeks ago - Re: Search Results
2 years 30 weeks ago - Re: How to schedule appengine using peoplecode
2 years 30 weeks ago - Re: Mark worked in Worklist page
2 years 32 weeks ago - Re: Calculate the sum for a grid field with out using row ...
2 years 34 weeks ago - Re: Invalid SNAC client version
2 years 37 weeks ago - Re: Trace Application Engine Processes Using Process Definitions
2 years 43 weeks ago
I'm guessing this has to do with the way you are opening the file in your peoplecode section. What is the code that you have?
I would actually just disable the App Engine's Restart property. I don't think you need it in such a program. This way, you need to re-run the program after it fails instead of restarting it.
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
Ya i agree with Lepa.. You ve to open the file in append mode, to append the data when u r restarting it so that the data will be appended to the exitsting file.
Regards,
Hari.A