SAP Knowledge Base Article - Preview

2585011 - Sub data flow fails with RWSocket error - SAP Data Services 4.2

Symptom

  • Job is terminated due to error <210113>.
  • Data flow failed to start with command <...>.  Diagnostic information <RWSocketError: in RWSocket::connect: CONNREFUSED>.
  • The job with sub data flow design (for example, Data Transfer transform) fails with the RWSocketError.  Remove the sub data flow object, the job works.
  • Restarting the Job Server doesn't help.
  • The following error appears in Data Services service_eventlog:
    12-29-17 10:26:21 (11450:4089816864) SYSTEM : Started ******** Start Logging al_jobservice *********
    12-29-17 10:26:49 (11450:4089816864) SYSTEM : ERROR: Error Starting JobServer Server1 on Port ANY:3500
    12-29-17 10:27:01 (11450:4089816864) SYSTEM : ERROR: JobServer Server1 on Port ANY:5400 is NOT running.
    12-29-17 10:27:28 (11450:4089816864) SYSTEM : ERROR: Error Starting JobServer Server1 on Port ANY:3500
    12-29-17 10:27:55 (11450:4089816864) SYSTEM : ERROR: Error Starting JobServer Server1 on Port ANY:3500
    12-29-17 10:28:22 (11450:4089816864) SYSTEM : ERROR: Error Starting JobServer Server1 on Port ANY:3500
    12-29-17 10:28:49 (11450:4089816864) SYSTEM : ERROR: Error Starting JobServer Server1 on Port ANY:3500
    12-29-17 10:29:16 (11450:4089816864) SYSTEM : ERROR: Error Starting JobServer Server1 on Port ANY:3500
    12-29-17 10:29:16 (11450:4089816864) SYSTEM : ERROR: Fatal Error Starting JobServer Server1 on Port ANY:3500
  • The following error appears in the Job Server server_eventlog:
    (14.2) 12-29-17 10:26:22 (1775:4082845472) JobServer: -------------------------------------------------- (BODI-850035)
    (14.2) 12-29-17 10:26:22 (1775:4082845472) JobServer: Job Server Started... (BODI-850036)
    ... ...
    (14.2) 12-29-17 10:26:23 (1775:4082845472) JobServer: Listening on ANY:3500. (BODI-850157)
    (14.2) 12-29-17 10:27:01 (12462:4082845472) JobServer: -------------------------------------------------- (BODI-850035)
    (14.2) 12-29-17 10:27:01 (12462:4082845472) JobServer: Job Server Started... (BODI-850036)
    ... ...
    (14.2) 12-29-17 10:27:01 (12462:4082845472) JobServer: Binding server to address inet:3500. (BODI-850044)
    (14.2) 12-29-17 10:27:01 (12462:4082845472) JobServer: Socket Exception: ADDRINUSE at RWSocket::bind. (BODI-850046)
    (14.2) 12-29-17 10:27:28 (12506:4082845472) JobServer: -------------------------------------------------- (BODI-850035)
    (14.2) 12-29-17 10:27:28 (12506:4082845472) JobServer: Job Server Started... (BODI-850036)
    ... ...
    (14.2) 12-29-17 10:27:29 (12506:4082845472) JobServer: Binding server to address inet:3500. (BODI-850044)
    (14.2) 12-29-17 10:27:29 (12506:4082845472) JobServer: Socket Exception: ADDRINUSE at RWSocket::bind. (BODI-850046)
    (14.2) 12-29-17 10:27:55 (12955:4082845472) JobServer: -------------------------------------------------- (BODI-850035)
    (14.2) 12-29-17 10:27:55 (12955:4082845472) JobServer: Job Server Started... (BODI-850036)
    ... ...
    (14.2) 12-29-17 10:27:56 (12955:4082845472) JobServer: Binding server to address inet:3500. (BODI-850044)
    (14.2) 12-29-17 10:27:56 (12955:4082845472) JobServer: Socket Exception: ADDRINUSE at RWSocket::bind. (BODI-850046)
    (14.2) 12-29-17 10:28:22 (13325:4082845472) JobServer: -------------------------------------------------- (BODI-850035)
    (14.2) 12-29-17 10:28:22 (13325:4082845472) JobServer: Job Server Started... (BODI-850036)
    ... ...
    (14.2) 12-29-17 10:28:23 (13325:4082845472) JobServer: Binding server to address inet:3500. (BODI-850044)
    (14.2) 12-29-17 10:28:23 (13325:4082845472) JobServer: Socket Exception: ADDRINUSE at RWSocket::bind. (BODI-850046)
    (14.2) 12-29-17 10:28:49 (17491:4082845472) JobServer: -------------------------------------------------- (BODI-850035)
    (14.2) 12-29-17 10:28:49 (17491:4082845472) JobServer: Job Server Started... (BODI-850036)
    ... ...
    (14.2) 12-29-17 10:28:50 (17491:4082845472) JobServer: Binding server to address inet:3500. (BODI-850044)
    (14.2) 12-29-17 10:28:50 (17491:4082845472) JobServer: Socket Exception: ADDRINUSE at RWSocket::bind. (BODI-850046)
  • Use 'netstat -anp|grep al_' to check and a proper al_jobserver process is running on the expected port (for example, 3500):
    netstat_DSD.png

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."


Read more...

Environment

  • SAP Data Services 4.2
  • Linux 

Keywords

RWSocketError, CONNREFUSED, 210113, sub, data transfer, dataflow, hosts, DS, ADDRINUSE, BODS, designer, , KBA , EIM-DS-EXE , Job Execution , EIM-DS , Data Services , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.