SAP DS Designer not able to execute a Job in a remote DS Job Server

[jorgepinaud]

Hi Colleagues,
I have 2 Problems related to SAP Data Services, but most probably both are related.
    1. In the first System I execute SAP DS Designer from my Laptop and are able to connect to the DS Server. I already opened the ports 3500 and 6400, and configured the CMS to work with port 6500 (instead of the "Auto assigned" port). In this case I become an error message in the lower-right corner indicating that "Job Server: ( <MyServer>:3500 ) - is not responding (BODI-1241021)". Also when trying to execute a Job I receive the error message "The job server you selected is not working.". I checked the system and the Job Server is running. Maybe I'm missing some ports or a range of ports, but I'm not able to find the right Note or blog where this is clearly indicated. In this case I cannot execute the DS Designer from the DS Server, as the DS Server is installed in a Linux Environment. My workaround is to execute the Jobs from the DS Console (Web Console), but this is not a good solution (only a Workaround).
    2. In the second system, installed in a Windows Environment, I'm able to execute DS Designer and run the Job Server, but the Job Server can only be used where connected to DS Designer in the same Server as the DS System is installed. But when I run the DS Designer from my Laptop and try to execute a Job I become the same error message as in the first system: "The job server you selected is not working.". But the difference is that in the lower-right corner I don't have an error indicating that the Job Server is not responding. In this case I don't have a Firewall between the DS Server and my Laptop (that's why I don't have the connection error), but I still have the "Job Server is not working" error. Here the workarounds are two: Execute DS Designer from the same DS Server (not suitable for the first problem) and use DS Console just for executing the jobs (not the best solution).

I checked SAP Notes and Blogs, opened ports and changed DS configurations, but nothing solves my problem.

So, in summary, my problems are:
    - First: identify the remaining ports that the DS System in Linux could be using, for listening and also for connecting to DS Designer. There's a Firewall in between.
    - Second: discover why DS Designer, executed from a remote computer (my Laptop) is telling me that the Job Server is not working. This is for both problems.

I know that this description is a long one, but I tried to clearly explain what is happening, and what I already did.
If someone had the same problems, please reply to this message and help me. I'm pretty sure it'll also be helpful for other consultants with the same problems.

Ah, last but not least, both DS installations are DS 4.3. The first one (the one in Linux) is SP03. The second one (the one in Windows) is SP00.
Best regards,

Jorge Pinaud.

[Julian_Riegel]

Hi,

try opening the Port range from 3500 - 3599.

Also, make sure that these ranges are also enabled by your companies Network team from the DS job server to all desktops. Then, set the ports manually in DS Designer (by un-checking "Designer to set its own ports").

BR,

Julian

[jorgepinaud]

Hi Julian.

Thank you for your reply. I already did this, but I tried again. In the first system I already asked the Firewall Team to open the whole port range from 6400 to 6500, so I updated DS Designer to use ports 6410 to 6499. But it doesn't work.

I did it also in the second system, where no Firewall is present, and used the range 3501 to 3599 for DS Designer, and it also doesn't work.

In both cases I restarted the DS Server.

Best regards,

Jorge.

[Julian_Riegel]

To begin troubleshooting, open a command-line prompt on the Designer machine and type 'telnet <jobserver_machine> <jobserver_port>'. A successful connection will display a blank or black screen.

If you're unable to establish a connection and get disconnected, there might be a network obstacle. If the telnet test succeeds, the next step is ensuring connectivity from the Job Server machine to the Designer's listening ports.

By default, the Designer selects its own port, but for testing purposes, you'll need to specify a port: In the Designer, navigate to 'Tools - Options', then choose 'Designer - Environment'. Disable 'Allow Designer to set the port for Job Server communication' and set a specific port (e.g., 3510).Click OK and restart the Designer.

On the Job Server machine, open a command-line or shell prompt and enter 'telnet <Designer_machine_name> <Designer_port>'. Can you establish a telnet session from the Job Server to the Designer? One of these tests is likely to fail, indicating the point of communication breakdown. Once identified, you can collaborate with your IT or network team to resolve the issue.

You might also want to check the following KBs:

https://me.sap.com/notes/0001416303

https://i7p.wdf.sap.corp/sap(bD1lbiZjPTAwMQ==)/bc/bsp/sno/ui_entry/entry.htm?param=69765F6D6F64653D3...