2791194 - "CONNECT_TO_GATEWAY_FAILED" error occurs in ST22 after executing job in background - SAP Data Services

• The following error messages occur in Tcode ST22 and SAP Data Services Designer after executing a job in background (batch) mode which is reading data from SAP application datastore:
  
  
• Exception condition "CONNECT_TO_GATEWAY_FAILED" triggeredData flow <dataflow name>|Reader Query|Transform Query__Driver
• The SAP job was canceled for host < >, job name <7f6fbfa0722311e9b7e827201db87bxx>, job count <082720xx>, job log from SAP
  <201905xx, 0827xx, Job is started
  201905xx, 0827xx, Step 001 started (program /SAPDS/RPT_STREAM_READ_TABLE, variant &00000000000xx, user ID <username>)
  201905xx, 0827xx, Internal session terminated with a runtime error RAISE_EXCEPTION (see ST22).
  201905xx, 0827xx, Job canceled
  
  
• The 'Execute in background (batch)' option is checked in the source table settings
  

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

• SAP Data Services 4.2
• SAP NetWeaver 7.x

EIM, EIM-DS-SAP, LOD-HCI-DS, HCI, CONNECT_TO_GATEWAY_FAILED, /SAPDS/RPT_STREAM_READ_TABLE, RAISE_EXCEPTION, background, error, ERP, ECC, SAPDS, NETWEAVER , KBA , EIM-DS-SAP , SAP Interfaces , LOD-HCI-DS , HANA Cloud Integration for Data Services , LOD-HCI-DS-OPS , HCI DS Cloud Operations , Problem