ETL Agent Error

More
11 months 3 weeks ago #25422 by tahmad
ETL Agent Error was created by tahmad
We are getting below error which cause Production ETL stuck. Please advise 
ETL Server - Execution Agent (32bit) - Cannot open file "C:\ProgramData\ETL-Tools.com\Options.ini". The process cannot access the file because it is being used by another process
The following user(s) said Thank You: admin

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

More
11 months 3 weeks ago #25423 by tahmad
Replied by tahmad on topic ETL Agent Error
there is one mor error for the same server
aetlcl.exe
6.4.2.33
6628fd6a
KERNELBASE.dll
6.3.9600.21615
64ffee7f
0eedfade
0002dfd8
2a6c
01dbf68ab4a524bb
C:\Program Files (x86)\DB Software Laboratory\Advanced ETL Processor Enterprise\aetlcl.exe
C:\Windows\SYSTEM32\KERNELBASE.dll
13f368a4-627e-11f0-81f8-00155d01945e
The following user(s) said Thank You: admin

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

More
11 months 3 weeks ago #25424 by admin
Replied by admin on topic ETL Agent Error
Looking at it now

Mike
ETL Architect

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

More
11 months 3 weeks ago #25425 by admin
Replied by admin on topic ETL Agent Error
There is some process which has locked Options.ini file.

It can be our software or something else for example antivirus or backup software.

You can check the process using Process explorer

learn.microsoft.com/en-us/sysinternals/d...ads/process-explorer

click find => find handle or dll



If you kill the process the agent should start working again.



 

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

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

More
11 months 3 weeks ago #25426 by Peter.Jonson
Replied by Peter.Jonson on topic ETL Agent Error
One thing I've noticed once agent is stuck it is not possible to stop the service.
So the only solution is to reboot the server which is not ideal.
I am looking at what can be done about it right now.
 

Peter Jonson
ETL Developer

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

More
11 months 3 weeks ago #25427 by Peter.Jonson
Replied by Peter.Jonson on topic ETL Agent Error
I have fixed the agent issues and published a new release.
I have also noticed that Options.ini was being updated far too often that was fixed as well.

6.4.2.33 Version is rather old and since than we have added a lot of new features so if you decide upgrade please test everything first.

As alternative you may try replacing agent exe  with a new version

Peter Jonson
ETL Developer

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