Click here to Skip to main content
15,867,756 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
I have scheduled my job in server, which it will be running continuously.

After processing some time, process is stopping abruptly with out any error.

What could be the reason?

Processing data day a by day, after processing each day data , I am clearing all variables and processing next day data. like way it is processing for 3 to 4 days with out abruption and stopping the process with out errors.

Each day data will process for 4 to 5 hours, Approximately 15 to 18 hours my process is executing with out abruption and suddenly it is stopping.

Inside my process, I am hitting to delete records from snowflake and writing data to S3 also.

What I have tried:

Tried clearing memory from assigned variables.
Added logs for reasons in all areas.
Posted
Updated 2-Oct-22 18:26pm
Comments
PIEBALDconsult 3-Oct-22 8:58am    
Deleting is best avoided anyway.
Simon_Whale 3-Oct-22 9:00am    
Sounds like you need to add some logging to help you track down the issue

1 solution

There is nowhere near enough information for us to help you in any real way: we have no access to your code or the system it is running on.

So you will have to fall back on old fashioned methods, and add logging to your app to try to narrow down where it is failing. Look at your logs after a crash, and add more detailed logs to that area.
After that crashes, look at the new logs and add more logging detail until you get to the point where you can say "it fails in this area of my code".

Then you can look closely at the specific code that it crashes in and start working out why.

But at the moment, you are just guessing - and that doesn't help anyone!
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900