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.

Restatable AE program

2 replies [Last post]
Guest's picture
Guest

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

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

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

Hari_aindian's picture
User offline. Last seen 7 years 2 weeks ago. Offline
Joined: 08/02/2010
Posts: 84
Re: Restatable AE program

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