- Posts: 51
- Thank you received: 1
Backup Repository is not working
5 years 7 months ago #17613
by albrechl
Backup Repository is not working was created by albrechl
Hi,
I just wanted to update Advanced ETL Processor Enterprise from 6.1.0.0 to 6.3.0.1 using the procedure www.etl-tools.com/articles/january-etl-update.html .
The problem is, that I cannot backup the repository. No file is created. I tried different filenames and filepaths. My User is Domain admin and e.g. in c:\temp I found an old repository backup file from 2017. So Access should not be an issue.
My repository is in a mysql database Version 5.7. I am on Windows 2012 R2 Windows Server.
Any idea? Is there another way to do the update procedure?
Lionel
I just wanted to update Advanced ETL Processor Enterprise from 6.1.0.0 to 6.3.0.1 using the procedure www.etl-tools.com/articles/january-etl-update.html .
The problem is, that I cannot backup the repository. No file is created. I tried different filenames and filepaths. My User is Domain admin and e.g. in c:\temp I found an old repository backup file from 2017. So Access should not be an issue.
My repository is in a mysql database Version 5.7. I am on Windows 2012 R2 Windows Server.
Any idea? Is there another way to do the update procedure?
Lionel
Please Log in or Create an account to join the conversation.
5 years 7 months ago #17615
by admin
Mike
ETL Architect
Replied by admin on topic Backup Repository is not working
We are trying to reproduce the problem
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
5 years 7 months ago #17616
by admin
Mike
ETL Architect
Replied by admin on topic Backup Repository is not working
Please run the following script against your repository.
It will patch it to the latest version.
Please keep us posted about your progress
Insert into OBJECT_TYPES
(OBJECT_TYPE,OBJECT_TYPE_NAME)
Values
('903','MongoDB Connection')
Insert into OBJECT_TYPES
(OBJECT_TYPE,OBJECT_TYPE_NAME)
Values
('904','MongoDB Connections')
INSERT INTO OBJECTS_TREE
(OBJECT_ID,
PARENT_ID,
NAME,
OBJECT_TYPE
)
Select
OBJECT_ID*-4 as OBJECT_ID,
PARENT_ID,
'MongoDB' as NAME,
903 as OBJECT_TYPE
From
OBJECTS_TREE
where OBJECTS_TREE.OBJECT_TYPE=320
UPDATE OBJECT_TYPES
set OBJECT_TYPE_GROUP=22000
WHERE OBJECT_TYPE= '903'
ALTER TABLE QUEUE ADD TERMINATE_ON_TIMEOUT NUMERIC(1) DEFAULT 0
ALTER TABLE QUEUE_HISTORY ADD TERMINATE_ON_TIMEOUT NUMERIC(1) DEFAULT 0
ALTER TABLE SCHEDULE ADD TERMINATE_ON_TIMEOUT NUMERIC(1) DEFAULT 0
ALTER TABLE EVENT_MONITORS ADD TERMINATE_ON_TIMEOUT NUMERIC(1) DEFAULT 0
It will patch it to the latest version.
Please keep us posted about your progress
Insert into OBJECT_TYPES
(OBJECT_TYPE,OBJECT_TYPE_NAME)
Values
('903','MongoDB Connection')
Insert into OBJECT_TYPES
(OBJECT_TYPE,OBJECT_TYPE_NAME)
Values
('904','MongoDB Connections')
INSERT INTO OBJECTS_TREE
(OBJECT_ID,
PARENT_ID,
NAME,
OBJECT_TYPE
)
Select
OBJECT_ID*-4 as OBJECT_ID,
PARENT_ID,
'MongoDB' as NAME,
903 as OBJECT_TYPE
From
OBJECTS_TREE
where OBJECTS_TREE.OBJECT_TYPE=320
UPDATE OBJECT_TYPES
set OBJECT_TYPE_GROUP=22000
WHERE OBJECT_TYPE= '903'
ALTER TABLE QUEUE ADD TERMINATE_ON_TIMEOUT NUMERIC(1) DEFAULT 0
ALTER TABLE QUEUE_HISTORY ADD TERMINATE_ON_TIMEOUT NUMERIC(1) DEFAULT 0
ALTER TABLE SCHEDULE ADD TERMINATE_ON_TIMEOUT NUMERIC(1) DEFAULT 0
ALTER TABLE EVENT_MONITORS ADD TERMINATE_ON_TIMEOUT NUMERIC(1) DEFAULT 0
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
5 years 7 months ago - 5 years 7 months ago #17617
by albrechl
Replied by albrechl on topic Backup Repository is not working
Ok, the scripts are like in the update procedure, right?
What I did:
1. Run the scripts
2. uninstall Version 6.1.0.0
3. install Version 6.3.0.1
4. insert manually the mysql repository Connection Details in the Connections.ini
5. run AETL and connect to my repository
6. start execution Agent service
scheduled Jobs looked like to run.
running a package manually using the excution Agent will be submitted, but does not execute
backup repository still does not work
please have a look at the the printscreens about the maintain tab Status before and afterwards
I had to roll back to Version 6.1.0.0 at the end.
Lionel
What I did:
1. Run the scripts
2. uninstall Version 6.1.0.0
3. install Version 6.3.0.1
4. insert manually the mysql repository Connection Details in the Connections.ini
5. run AETL and connect to my repository
6. start execution Agent service
scheduled Jobs looked like to run.
running a package manually using the excution Agent will be submitted, but does not execute
backup repository still does not work
please have a look at the the printscreens about the maintain tab Status before and afterwards
I had to roll back to Version 6.1.0.0 at the end.
Lionel
Last edit: 5 years 7 months ago by albrechl.
Please Log in or Create an account to join the conversation.
5 years 7 months ago #17618
by admin
Mike
ETL Architect
Replied by admin on topic Backup Repository is not working
Please drop an email to support@etl-tools.com.
One of us will connect remotely and investigate what is happening
One of us will connect remotely and investigate what is happening
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
- Peter.Jonson
-
- Offline
- Platinum Member
-
5 years 6 months ago #17622
by Peter.Jonson
Peter Jonson
ETL Developer
Replied by Peter.Jonson on topic Backup Repository is not working
Hello
We can confirm that backup does not work when no username/password specified for repository connection.
This issue was addressed by adding following error message.
Problem with executing packages.
That was addressed as well.
Other changes are:
6.3.0.2
+ Updated : SFTP components
+ Improved : Backup Error handling
+ Improved : Repository Switching
+ Fixed : Various bug fixes and improvements
We can confirm that backup does not work when no username/password specified for repository connection.
This issue was addressed by adding following error message.
Problem with executing packages.
That was addressed as well.
Other changes are:
6.3.0.2
+ Updated : SFTP components
+ Improved : Backup Error handling
+ Improved : Repository Switching
+ Fixed : Various bug fixes and improvements
Peter Jonson
ETL Developer
Please Log in or Create an account to join the conversation.