Hello all,
I need to create a text file to store into a folder in the system, the problem is, I need to input every line that I'm getting from a query into it, at the moment we have about 117.085 liness that need to be presented in a text file.
I tried a timer but of course I got a timeout, even if I increase the default timeout to 90 minutes stills fail.
Do you have any suggestions to handle this?Thanks in advance.
Hi Eduardo Oliveira,
You can adapt your timer to exit before the timeout and launch again till you have lines to process.
For that you can use a site property for the timeout threshold.
For each execution you can check if the file already exists, if not create the text file otherwise use the previous one to append the content.
For the last execution rename the file with suffix Final, this way you will now that the execution ended.
Hope that it helps you
Hi,
Seems here issue is not getting the text file actual issue seems in fetching the records from database. Could you please post screenshot of what you are doing in the timer. If timer is long running then we should handle the timeout condition. But before that it will be great if you can provide screenshot of code in the timer.
regards
How are you currently creating that file?What is the technical approach you currently have?Which type of text file is it? Do you mean a .txt file?
there is an option (if database is Oracle) that is to use the dump command expdp , its just an opinion.