You are experiencing a sudden failure of connections to data sources such as MySQL, Qlik Cloud, and Microsoft SQL Server in Talend Data Catalog. These connections were previously working correctly. When you test the connection, you receive the following error message:
"An error occurred in the remote service [-1,1] - MIMB execution thread ( ) was not found"
This issue can occur even if you can locally access the data sources with other tools, such as DBeaver.
Cause
The error message indicates that the Talend Data Catalog application is unable to connect to the bridge server. This is because the Remote Harvest Agent required to access your local data sources is either missing, has been deleted, or is not properly configured. The default server running in the cloud does not have access to data sources behind your firewall.
Resolution
To resolve this issue, you need to install and configure a new Remote Harvest Agent. This agent can be installed on the same server as your data source (e.g., MySQL) or on another machine that has access to it.
Here are the steps to follow:
Install the Remote Harvest Agent:
Download the installation files for the Remote Harvest Agent.
If you are installing on aWindowsoperating system, run the Setup.bat file.
If you are installing on aLinux or Unix-likeoperating system, run the Setup.sh file.
Follow the on-screen instructions to complete the installation.
Configure the New Agent in Talend Data Catalog:
Once the agent is installed, open your Talend Data Catalog.
Navigate toManage Servers.
Add the newly installed Remote Harvest Agent.
Use the New Agent for Harvesting:
When configuring your data source connections, select the new agent you just added to harvest the data model.
These instructions are the same for both the cloud and on-premise versions of Talend Data Catalog.
Additional Information
For more detailed instructions, you can refer to the following documentation:
