3378341 - SSL Configuration for new SDA connection with CDP

An existing HDP Hadoop SDA connection with SSL is enabled. Setting up a new CDP Hadoop environment and created a new SDA connection from HANA which work fine, however the connection is failing after enabling the SSL connection.

[167953]\{354058\}[127/-1] 2023-04-03 21:31:27.237180 i TraceContext     TraceContext.cpp(01269) : UserName=SYSTEM, ApplicationUserName=OPR03944, ApplicationName=HDBStudio, ApplicationSource=csns.federation.services.ds.impl.sql.DataProvisioningService.browseRemoteSource(DataProvisioningService.java:329);csns.federation.catalog.navigator.FederationWorkbenchAdapter$1.run(FederationWorkbenchAdapter.java:149);org.eclipse.core.internal.jobs.Worker.run(Worker.java:63);, StatementHash=94412059c3f16f183785cceef0105d94, StatementExecutionID=844438188334472
[167953]\{354058\}[127/-1] 2023-04-03 21:31:27.237170 e FedTrace         SparkSQLAccess.cpp(03511) : SparkSQLAccess::testConnection: Connection closed!: failed with error: Connection has been closed.
[167953]\{354058\}[127/-1] 2023-04-03 21:31:27.237214 e FedTrace         SparkSQLAccess.cpp(03511) : SparkSQLAccess::Connection not available!: failed with error: Not Connected!!
[432232]{-1}[-1/-1] 2023-04-03 21:31:29.616745 e Stream           NetworkChannelCompletion.cpp(00434) : [c93e26be00aaaffa,10.129.163.11:17308,10.229.163.77:7860,HAD,0] NetworkChannelCompletionThread #9 {<NetworkChannelSSLFilter>={<NetworkChannelBase>={this=131356695535640, fd=1126, refCnt=1, idx=9, local=10.129.163.11/17308_tcp, remote=10.229.163.77/7860_tcp, state=ConnectWait, pending=[---c]}}}: Error in asynchronous stream event: exception  1: no.2110001  (Basis/IO/Stream/impl/NetworkChannelCompletion.cpp:360) TID: 432232
    Generic stream error: getsockopt, Event=EPOLLERR - , rc=111: Connection refused; $Context$=[c93e26be00aaaffa,10.129.163.11:17308,10.229.163.77:7860,HAD,0]; $channel$={<NetworkChannelSSLFilter>={<NetworkChannelBase>={this=131356695535640, fd=1126, refCnt=1, idx=9, local=10.129.163.11/17308_tcp, remote=10.229.163.77/7860_tcp, state=ConnectWait, pending=[---c]}}}
exception throw location:
1: 0x00007f466ba37d94 in Stream::NetworkChannelCompletionThread::run(void*&)+0xad0 at NetworkChannelCompletion.cpp:360 (libhdbbasis.so)
2: 0x00007f466bafbf85 in Execution::Thread::staticMainImp(Execution::Thread*)+0x531 at Thread.cpp:522 (libhdbbasis.so)
3: 0x00007f466baeb9e8 in Execution::pthreadFunctionWrapper(Execution::Thread*)+0x1e4 at ThreadInterposition.cpp:639 (libhdbbasis.so)
4: 0x00007f466b14dea5 in start_thread+0xc1 (libpthread.so.0)
5: 0x00007f4669834b0d in __clone+0x69 (libc.so.6)
exception type information:
- 0: public ltt::exception@0x7f466b0b4c40
[146738]\{354059\}[127/-1] 2023-04-03 21:31:29.618902 i TraceContext     TraceContext.cpp(01269) : UserName=SYSTEM, ApplicationUserName=OPR03944, ApplicationName=HDBStudio, ApplicationSource=csns.federation.services.ds.impl.sql.DataProvisioningService.browseRemoteSource(DataProvisioningService.java:329);csns.federation.catalog.navigator.FederationWorkbenchAdapter$1.run(FederationWorkbenchAdapter.java:149);org.eclipse.core.internal.jobs.Worker.run(Worker.java:63);, StatementHash=94412059c3f16f183785cceef0105d94, StatementExecutionID=844438188334486
[146738]\{354059\}[127/-1] 2023-04-03 21:31:29.618897 e FedTrace         SparkSQLAccess.cpp(03511) : SparkSQLAccess::testConnection: Connection closed!: failed with error: Connection has been closed.
[146738]\{354059\}[127/-1] 2023-04-03 21:31:29.618921 e FedTrace         SparkSQLAccess.cpp(03511) : SparkSQLAccess::Connection not available!: failed with error: Not Connected!!
[432232]{-1}[-1/-1] 2023-04-03 21:31:34.007793 e Stream           NetworkChannelCompletion.cpp(00434) : [c93e26be00aaaffd,10.129.163.11:17330,10.229.163.77:7860,HAD,0] NetworkChannelCompletionThread #9 {<NetworkChannelSSLFilter>={<NetworkChannelBase>={this=121134224152600, fd=1126, refCnt=1, idx=9, local=10.129.163.11/17330_tcp, remote=10.229.163.77/7860_tcp, state=ConnectWait, pending=[---c]}}}: Error in asynchronous stream event: exception  1: no.2110001  (Basis/IO/Stream/impl/NetworkChannelCompletion.cpp:360) TID: 432232
    Generic stream error: getsockopt, Event=EPOLLERR - , rc=111: Connection refused; $Context$=[c93e26be00aaaffd,10.129.163.11:17330,10.229.163.77:7860,HAD,0]; $channel$={<NetworkChannelSSLFilter>={<NetworkChannelBase>={this=121134224152600, fd=1126, refCnt=1, idx=9, local=10.129.163.11/17330_tcp, remote=10.229.163.77/7860_tcp, state=ConnectWait, pending=[---c]}}}
exception throw location:
1: 0x00007f466ba37d94 in Stream::NetworkChannelCompletionThread::run(void*&)+0xad0 at NetworkChannelCompletion.cpp:360 (libhdbbasis.so)
2: 0x00007f466bafbf85 in Execution::Thread::staticMainImp(Execution::Thread*)+0x531 at Thread.cpp:522 (libhdbbasis.so)
3: 0x00007f466baeb9e8 in Execution::pthreadFunctionWrapper(Execution::Thread*)+0x1e4 at ThreadInterposition.cpp:639 (libhdbbasis.so)
4: 0x00007f466b14dea5 in start_thread+0xc1 (libpthread.so.0)
5: 0x00007f4669834b0d in __clone+0x69 (libc.so.6)
exception type information:
0: public ltt::exception@0x7f466b0b4c40

SAP HANA DB Version 2.0

KBA , HAN-DB-SDA , SAP HANA Smart Data Access , Problem