Hello,
So I ran into an issue where sometimes a graph will get stuck and jam up the server. The reason the graph jams is when it hits the erp server were pulling data the connection can time out but the graph will still try to run. Also our graphs never run longer than 2 hours.
The graphs are cloning graphs to pull all the data into our Data Warehouse.
1. What I want to do is create a listener to know if a graph runs longer then 2 hours?
2. Also how would I stop the graph if it does run to long automatically?
Just seeing what options are available when working with this issue.
Thank you
Patrick
So I ran into an issue where sometimes a graph will get stuck and jam up the server. The reason the graph jams is when it hits the erp server were pulling data the connection can time out but the graph will still try to run. Also our graphs never run longer than 2 hours.
The graphs are cloning graphs to pull all the data into our Data Warehouse.
1. What I want to do is create a listener to know if a graph runs longer then 2 hours?
2. Also how would I stop the graph if it does run to long automatically?
Just seeing what options are available when working with this issue.
Thank you
Patrick
-
Hi Patrick,
CloverETL Server comes with Graph Event Listeners that can easily handle this kind of tasks. The graph event monitored by the listener is called "graph_timeout" and can be used exactly the way you need - that means when a graph execution time reaches predefined limit the listener kills the graph (Abort job). And even more, you might want to kill the whole source of the event - that is also possible. Since there is a lot more you might want to take a look at the related documentation article.
Hope it helps.
Please sign in to leave a comment.
Comments 1