Execution Agent started but log an error and don't start the scheduled tasks

More
4 years 8 months ago #21368 by agenziazero
Hello! I have this problem.

When I start the Visual Importer ETL Enterprise - Execution Agent (64bit), the service seems started.
But into the Visual Importer Enterprise folder appear a log file named like VImpAgent_20211019101459_2020.log with this error repeated for each row.

19/10/2021 10:14:59 ONDULATI-APPS4 Administrator La conversione di un tipo di dati nvarchar in datetime ha generato un valore non compreso nell'intervallo dei valori consentiti
19/10/2021 10:15:05 ONDULATI-APPS4 Administrator La conversione di un tipo di dati nvarchar in datetime ha generato un valore non compreso nell'intervallo dei valori consentiti
19/10/2021 10:15:11 ONDULATI-APPS4 Administrator La conversione di un tipo di dati nvarchar in datetime ha generato un valore non compreso nell'intervallo dei valori consentiti
...

And the agent really don't work and don't start the scheduled tasks.

"ONDULATI-APPS4" is the name of the Windows VPS.
"Administrator" the user (domains admin) that run the service.
"La conversione di un tipo di dati nvarchar in datetime ha generato un valore non compreso nell'intervallo dei valori consentiti" in english is: "the conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value"

This error appears whether the scheduled tasks into Visual Importer ETL Enterprise are enabled or not.

I try to change the user into Service's properties, using another local administrator and system local, but nothing change.

More infos:
Visual Importer ETL Enterprise (64bit) Standard License
Version: 9.2.7.26
Windows Server 2016 Standard 64bit
Language: Italian
Processor: QEMU Virtual CPU version 2.5+ 2.39ghz (4 processors)
The installation was made with the Domain Administrator user.
And the Services will be run with the same user.
I use a local Administrator (local administrators group).
Repository on SQL Server 2016 Express Advanced
Version: 13.0.5103


Any idea to solve this problem?
Thank you
Fabio Petris

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

More
4 years 8 months ago #21369 by admin
Hi Fabio

Please set the language of the database user to English.
www.etl-tools.com/wiki/knowledgebase/rep...l-server-repository/
Last picture
Keep us posted on your progress

Mike
ETL Architect
The following user(s) said Thank You: agenziazero

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

More
4 years 8 months ago #21370 by agenziazero
Solved. Thank you.
Regards.
Fabio Petris

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