2449384 - RSDANLCON - IQ NLS for SDA returns "internal error: Cannot test remote source" | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

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

Symptom

  • 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.

Read more...

Environment

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

Product

SAP Business Warehouse all versions ; SAP HANA 1.0, platform edition ; SAP IQ 16.0

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.