Hello,
I am trying to import data from excel and saving into the entity but when I try to save it using the CreateTableName() entity action facing the error from server " Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding."
Application designed in Traditional web.
I tried with the SetRequestTimeout ( HTTPRequestHandler ). but this will not work.
Thanks In Advance
Hi Shubham,
Can you explain bit more? I guess you are doing form screen action.If your excel is too big then in my suggestion must use asynchronous job to perform this action.
Thanks,
Narendra
Hi Shubham, try to increase the server request time out of module by some seconds as shown in below screen shot and see if it helps. Otherwise , you can try the bpt approach , upload the excel file in one entity and create process w.r.t that entity , create one activity and move your logic inside the activity of the process. Delete the file from the entity once the uploading is done.
Hi Tejas,
I am using Traditional web application.
Thanks!
If the number of records being uploaded is something not in your hands, then it is better to process such data via batch processing using either Timers or Processes. You can very well save the file in DB for you to get it processed via batch job. Also there are Forge components like BulkInsert available for you to insert data efficiently
Below is a tech talk session on how to go about implementing Heavy Timers for your reference. Hope it helps.
https://www.outsystems.com/training/lesson/1749/odc-2018-heavy-timers
Regards,
Saurabh
https://www.outsystems.com/training/lesson/1133/master-class-on-best-practices-and-timers