Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
The Talend Cloud Migration Platform (TCMP) is a utility to help the on-premises customers move to the Talend Cloud. The tool has been available for 2 years now. Several customers have leveraged TCMP in their transition to Talend Cloud.
The Talend Cloud Migration Platform (TCMP) main objective is helping the planning and the implementation of the migration of the Talend on-premises assets to Talend Cloud.
The Planning is done through the collection and inventory of the Talend on-premises assets.
The Talend assets include the list of Administrative assets: Users, Groups, Projects, and Runtime Assets: Tasks, and Execution plans. TCMP also collects the list of Talend related servers such as Talend Administrative Center (TAC) servers, TAC databases, Job servers, Virtual Servers and referenced Artifact Repositories.
The following TAC versions and databases are supported by TCMP:
11 TAC versions:
· Version 6 (6.0.1, 6.1.1, 6.2.1, 6.3.1, 6.4.1, 6.5.1)
· Version 7 (7.0.1, 7.1.1, 7.2.1, 7.3.1)
· Version 8 (8.0.1)
6 TAC databases with their integrated JDBC drivers:
· H2,
· MariaDB,
· MySQL,
· Oracle,
· PostgreSQL,
· SQL Server
To collect the assets from Talend on-premises, the TAC servers must be registered first to TCMP.
TAC Registration:
The registration process allows the Cloud Migration platform to connect to each TAC Servers and collect an inventory of administrative (admin)
and runtime assets.
The collection of those assets is done through a combination of a direct TAC database read and invocation of the TAC Metaservlet APIs.
1) A connection to the TAC Web Interface (Metaservlet access).
When all the parameters are filled up, you have the option to check the web connection to validate your inputs.
2) A connection to the TAC database.
Like for the Web connection, you have the option to validate the database connection parameters.
When the connection parameters are valid, you can Register the TAC server.
TAC Registration Troubleshooting:
In TCMP version R2023-04, we made a few improvements in the TAC Registration User Interface. These improvements were based on the user’s feedback of the Registration process.
In this version, a more descriptive error message is displayed whenever user encounters a registration failure along with some suggestions to remediate the issue.
The following Cheat Sheet covers some of the most common problems the user may encounter during the TAC registration as well as the root causes, and workarounds to fix those issues.
TAC Web interface errors:
1) Failed to connect to the TAC Server
Error: After you entered all the TAC connection parameters, click on the Test connection, or Register button, the following error is displayed in the UI
ERROR:
Failed to connect to the TAC server http: //tac-dev:8080
This problem may occur due to the following reasons:
1) If you have entered an invalid TAC URL
2) The Tac Server URL cannot be reached from the Server/Workstation where TCMP is installed.
3) There is a missing Proxy or firewall setting blocking the connection (ie. Windows Firewall on either the server or the client, 3rd party firewall software)
Workarounds:
To fix this problem, you could do one of the following:
1) Validate if the TAC URL you have entered during registration is same as the Web URL you used to connect to the TAC administration server.
2) Validate that server/workstation where TCMP is installed can reach the TAC We interface.
3) Related to 2), check if any proxy or firewall settings are required to access the TAC server.
2) Insufficient rights for the user
Error: After you have entered all the TAC connection parameters, click on the Test connection, or Register button, the error may typically look like this
ERROR:
Insufficient rights for user ‘username’.
This error may occur if the user you are registering with does not have sufficient privileges or roles assigned to the user in the TAC server.
Workaround:
To fix the error, you must provide at least minimum permissions by assigning ‘Security Administrator’, ‘Administrator’ and ‘Operations Manager’ roles to the TAC user. Once these roles are assigned register the TAC server to TCMP
Error:
After entering and validating all the connection parameters, you may get this following error during TAC registration.
ERROR:
The Request timed out while listing the tasks.
At the time of the Registration, TCMP establishes a connection with the TAC server to collect all the assets from on-premises.
If the TAC server contains many tasks, then the request could take longer than expected to fetch all the tasks definition. In this case, TCMP might get timeout errors.
Workaround
1) The TAC server, especially a production server, might get temporarily overloaded while processing all the requests. You could try registering the TAC server when the server is not busy.
2) If you are still facing challenges and the registration is taking longer than 2 mins due to many tasks. In this case, you can also increase the default timeout which is 120 secs (2 mins) by default, by setting the following parameter in start_tcmp.bat/start_tcmp.sh file:
-Dtac.config.metaservlet.read-timeout=<value in sec)
Ex: 5 mins
java -Dserver.port=%HTTP_PORT% -Dtac.config.metaservlet.read-timeout=360 -jar %tcmp%
TAC Database:
1) Failed to connect to the TAC database
Error:
ERROR:
Failed to get driver instance for jdbcUrl=jdbc:postgresql://postgres-dev:5l432/tac?
The error could occur due to the following reasons,
1) If the TAC database URL is invalid
2) The database type in the Registration UI does not match the connection string and credentials.
3) Invalid database credentials
4) The database user doesn’t have read access to all the tables.
Workaround:
To fix this error,
1) Validate if the database URL you have entered is same as the connection string in the configuration database section of the TAC server.
3) Along with the database type and URL, make sure to enter valid credentials (username and password) to connect to the database server.
4) Check if the user has read access to all the tables in the TAC database.
If you are still facing challenges and require further assistance, please contact the Bridge To Cloud/On-Premises To Cloud team (op2c@talend.com).
You can download TCMP from the Talend Help web page .