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

Read more...

Environment

  • SAP Data Services 4.2
  • Linux 

Keywords

RWSocketError, CONNREFUSED, 210113, sub, data transfer, dataflow, hosts, DS, ADDRINUSE , KBA , EIM-DS-EXE , Data Services Job Execution , EIM-DS , Data Services (Use Subcomponent) , Problem

About this page

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

Search for additional results

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