topic Remote Engine job not completing on one server in Talend Studio

Remote Engine job not completing on one server

welshsteve — Fri, 15 Nov 2024 22:59:57 GMT

Hi.

I have a Remote Engine running in a server farm of 8 servers.

I have a published job in Talend Portal (Management Console), which works absolutely fine when run against databases on 7 of the 8 servers. But for one server, the Remote Engine task just keeps running and never completes. The job doesn't do anything.

If I open up SQL Server Management Studio on the server in question, I can see the connection process, so a connection has been established. But the execution never happens.

It is not erroring, so I'm at a loss to understand why it is doing this.

Re: Remote Engine job not completing on one server

Anonymous — Thu, 21 Apr 2022 04:48:49 GMT

@Steve Williams try to check and do some testing to see what could be the cause.

1 Has iteration and create many connections to the same DB in the job?

2 Process a small data set to see if the execution ends?

3 Export the job script and move to the server where Remote engine is installed, execute it to see if the same problem occurs.

Regards

Shong

Re: Remote Engine job not completing on one server

welshsteve — Thu, 21 Apr 2022 11:09:43 GMT

Hi @Shicong Hong

The job I am using to test this is a very simple job that connects to a database, and creates one record in one data table. Here's the job in Studio. As you can see, it's very basic.

I have 7 other SQL servers, one of which also has the remote engine running on it.

The job works fine when run against databases on all the other servers, so it is just this server that appears to have the issue

Because the job doesn't "die", I've got no logs to give me a clue as to what the issue might be.