Scheduled packages don't start after changing repository from MS Access to MSSQL

More
3 years 8 months ago #22197 by jlu
We tried to change AETL repository from default MS Access to MS SQL using OLE DB connection.
Repository change was successful itself, we could run packages manually from new repository.
Scheduled packages won't start, however.
Scheduled packages are working fine when using MS Access repository.

We have tried following:
- Rebooted AETL server
- Restarted Execution Agent
- Updated AETL from 6.3.5.x to 6.3.11.7

AETL version: 6.3.11.7

How to fix this?

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

More
3 years 8 months ago #22198 by admin

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

More
3 years 8 months ago #22200 by jlu
Scheduler was already active and was working in MS Access repository.
Now repository is in MS SQL server and scheduler is not working.

I tried to remove ETL Server Execution Agent and re-install it again, but that didn't help either.

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

More
3 years 8 months ago #22201 by admin
We would like to connect remotely and investigate.

Please email us a link

Mike
ETL Architect

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

More
3 years 8 months ago #22202 by admin
We suggested remote assistance in the past and that was ignored
www.etl-tools.com/forum/advanced-etl-pro...ms-sql.html?start=12

Mike
ETL Architect

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

More
3 years 8 months ago #22204 by jlu
I sent email now to support.
We probably just gave up earlier and went back to MS Access.

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