2449384 - RSDANLCON - IQ NLS for SDA returns "internal error: Cannot test remote source"

• You are working on SAP BW with SAP NLS IQ through Smart Data Access (SDA).
• All the configurations have been done but in the RSDANLCON connection, you see the below errors:

@5B@ DB connection <NLS_source> opened (work process nn of server xxxxx_<SID>_nn)
@5C@ Remote source <NLS_source> for SDA has errors; see subsequent messages
@5B@ internal error: Cannot test remote source <NLS_source>
@5B@ -------------------------------------------------- SP_IQSTATUS --------------------------------------------------

• From developper trace file (dev_w*) those errors are returned:

C *** ERROR => execute() of C_0331, #rec=0, rc=1, rcSQL=403
[dbsdbsql.cpp 1669]
C {root-id=005056BA1C7C1ED7868FBBB50C5480FB}_{conn-id=00000000000000000000000000000000}_0
C *** ERROR => EXECUTE C_0331 on connection 0, rc=403
[dbslsdb.cpp 9730]
C SQLCODE : 403
C SQLERRTEXT : internal error: Cannot test remote source <NLS_source>
C sc_p=00000000034FB8D8,no=331,idc_p=0000000000000000,con=0,act=1,slen=39,smax=256,#vars=0,stmt=000000007ED9B990,table=
C call CHECK_REMOTE_SOURCE ('<NLS_source>') ;
B ***LOG BY2=> sql error 403 performing OPC [dbds 437]
B ***LOG BY0=> internal error: Cannot test remote source <NLS_source> [dbds 437]

• Connection to SAP IQ through SDA from Hana Studio can be established successfully.
• IQ connection test with ADBC_TEST_CONNECTION also informs connection is succesfully established.

• SAP IQ 16
• SAP Business Warehouse on HANA
• SAP HANA Smart Data access

SDA, "internal error" , KBA , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , HAN-DB-SDA , SAP HANA Smart Data Access , Problem