Timeout for Packages running via commandline

More
10 months 4 weeks ago #25562 by prashant
I have multiple packages which run with URL Logger using command line .

How do I define timeout for these packages , for example typically it takes less than 30 seconds for the below packages to finish , here I would like to terminate them otherwise

 

For your reference these packages start like below
 
The following user(s) said Thank You: Peter.Jonson

Please Log in or Create an account to join the conversation.

More
10 months 4 weeks ago #25567 by Peter.Jonson
This functionality is not currently supported.

Assuming that you are using JavaScript to start aetlcl.exe it should be possible to use JavaScript  to kill aetlcl.exe based on timeout

Peter Jonson
ETL Developer

Please Log in or Create an account to join the conversation.

More
10 months 4 weeks ago #25568 by prashant
Maybe a better option could be to pass another variable in command line 

They are all running below via
Code:
const fs = require("fs"); const { spawn } = require("child_process"); try {   const WORKING_DIRECTORY = "C:\\Program Files\\DB Software Laboratory\\Advanced ETL Processor Enterprise\\";   const fileToExecute = "C:\\Program Files\\DB Software Laboratory\\Advanced ETL Processor Enterprise\\aetlcl.exe";   const objectId = 7736;   const parameters = [objectId, logId];     logger.info(parameters);     spawn(fileToExecute, parameters, { cwd: WORKING_DIRECTORY, detached: true });     return 200; } catch (err) {   logger.error(`Caught an error: ${err.message ? err.message : err}`);   return 500; // Any error caught here results in a 500 status }
The following user(s) said Thank You: admin

Please Log in or Create an account to join the conversation.

More
10 months 2 weeks ago #25599 by admin
FYI: We have started working on implementing your suggestion.

Mike
ETL Architect
The following user(s) said Thank You: Peter.Jonson, prashant

Please Log in or Create an account to join the conversation.

More
10 months 2 weeks ago #25608 by Peter.Jonson
FYI: We have implemented your suggestions in the latest release.

02/09/2025 6.4.6.8

 + Added: hardtimeout, softtimeout and retries parameters to aetlcl.exe

Documentation can be found here.

www.etl-tools.com/wiki/advanced-etl-proc...mand-line-interface/

Any issues let us know


 

Peter Jonson
ETL Developer

Please Log in or Create an account to join the conversation.

More
10 months 2 weeks ago #25610 by prashant
HI Peter, thanks for this update , before I roll out , few quetstions

earlier I would use URL Logger like below aetlcl.exe 9563 {logid} So I command line parameters , I will read define position as 2, see what I mean below  

 

1. Now with retry mechanism I can still do {logid} as 2nd parameter  and keep my package same or retry mechanism requires 2nd position always ?
2. Can I combine the timeouts and retries like example 2 ?

aetlcl.exe 9563 {logid} retries=2
aetlcl.exe 956 {logid}  retries=2   hardtimeout=100
 
The following user(s) said Thank You: admin

Please Log in or Create an account to join the conversation.

Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Read more
Marketing
Set of techniques which have for object the commercial strategy and in particular the market study.
Google
Accept
Decline
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Google Analytics
Accept
Decline
Functional
Tools used to give you more features when navigating on the website, this can include social sharing.
Advertisement
If you accept, the ads on the page will be adapted to your preferences.
Google Ad
Accept
Decline
Save