3585535 - Error "WebSocket server session aborted" when validate S/4HANA On-Premise connection in SAP Datasphere

Cloud Connector is selected for Data Provisioning Option under Remote Tables section of S/4HANA On-Premise connection to use the ABAP SQL service to federate data with remote tables.

When validate the S/4HANA On-Premise connection in Datasphere, below error message is displayed in the details:

Remote Tables: Unable to connect remote source: [SAP][ODBCforABAP] (08001) Open backend connection: WebSocket Close frame : TH: WebSocket server session aborted, Code: 5921, SQL State: HY000

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

SAP Datasphere

1. Select the checkbox in front of the connection to S/4HANA On-Premise.
2. Click Validate button.

Cause 1:

The WebSocket connectivity and privileged mode for SQL is not enabled on the ABAP system.

Cause 2:

Source S/4HANA On-Premise SAP Basis release version is lower than 756. ODBC access is only supported starting from SAP Basis release 756 and higher.

Resolution for Cause 1:

Enabled the WebSocket connectivity and privileged mode for SQL on the ABAP system:

1. Run transaction code RZ11.
2. Input parameter wssql/active.
3. Click "Display" button.
4. Click "Change Value" button.
5. Input 1 into New Value field.
6. Select "Switch on all Servers".
7. Click "Save change" button.
8. Use the same steps above to change the value of parameter wssql/privileged/active to 1.

Note that: the change is not permanent, and will be lost at server restart. Change it in profile file to make it permanent if necessary.

Resolution for Cause 2:

To enable ODBC access, the system must be on SAP Basis release 756 or higher. Consider upgrading the SAP Basis release to 756 or above.

• Accessing ABAP-Managed Data from External ODBC-Based Clients -> Prerequisites
• Using ABAP SQL Services for Accessing Data from SAP S/4HANA

"Remote Table" "Connection" "Datasphere" "Cloud Connector" , KBA , DS-DI-CON , Connections , BC-DB-DBI-SQLS , Internal Component - DO NOT USE , Problem