Event Listener and Stop graph if runs to long

Support questions related to CloverETL Server

PhillyGuy
Posts: 1
Joined: Thu Jul 16, 2015 2:35 pm

Event Listener and Stop graph if runs to long

Postby PhillyGuy » Thu Jul 16, 2015 2:46 pm

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

slechtaj
Posts: 192
Joined: Wed Aug 15, 2012 8:18 am

Re: Event Listener and Stop graph if runs to long

Postby slechtaj » Wed Aug 05, 2015 3:16 pm

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.
Jan Slechta
CloverCARE Support
CloverETL | Rapid Data Integration

Visit us online at http://www.cloveretl.com

How to speed up communication with CloverCARE support


cron