Symptom
In Datasphere, when trying to maintain a load balanced connection, using message server, it does not allow to maintain the virtual port as sapms<SID>.
When using the Load Balancer port, the following error message is raised:
If standard port (sapgw00) is used instead, the connection is established successfully.
Environment
- SAP Datasphere
Cause
System working as designed.
Resolution
System mapping defined with hostname:sapms<systemID> is yet to be supported by Dataflow and Repliction flow run-time. It is required to define the load balancing system mapping in Cloud Connector with internal port instead.
See Also
Create the On-Premise Source System in the Cloud Connector
SAP KBA 3369433 - How to troubleshoot Cloud Connector related issues when creating connection in SAP Datasphere
SAP KBA 3460828 - 'Expose the system in your Cloud Connector' Error in SAP Datasphere
SAP KBA 2835207 - ABAP connection type for SAP Data Intelligence / SAP Datasphere
Keywords
load, balancer, port, invalid, SID, DWC, Datasphere, connection, fail , KBA , DS-DI-CON , Connections , Problem
SAP Knowledge Base Article - Public