Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi. I have strange issue where a connection is not working in the Talend Management Console, stating "Unknown server host name". See screenshot
The remote engine executing this is running on a server on our local network, and the job works perfectly ok when run from Talend Studio and using this Remote Engine as the Target Exec. But when run from the TMC, I get the error.
Does anybody have any suggestions?
Thanks
Steve
Hello,
From the error message above, there is some DB connection issue in TMC. Are you using context value in tDBConnection component properties?
Note:The context that gets used is based strictly on the name of the environment in TMC (and goes to the default if the environment doesn't match any of the contexts).
Best regards
Sabrina
Hi @Xiaodi Shi
Yes, this is working perfectly fine for another server.
The tDBConnection component in the job uses a context variable with the "connection" prefix e.g. connection_mssql_ao. This context is setup as a connection in the TMC, and works fine if I specify a different server. All the variable names are the same. The only difference is the value for the database server