SAP Knowledge Base Article - Preview

3135679 - DBCO connection to SAP IQ via BW-NLS setup failed

Symptom

  • DBCO connection to SAP IQ via BW-NLS setup
  • DBCO connection test via SE38 -> ADBC_TEST_CONNECTION failed.
  • Check dev trace file, the following errors occur:

B Wed Dec 29 10:14:05:395 2021
B Connect to SAPIQDB as dba with SYBASE_SERVER=sa300nlddb01.itc.cdc.telia.net SYBASE_PORT=3283 SYBASE_IQ_ENGINE=IQ16DEVTELIA SYBASE_DBNAME=SAPIQPBD SYBASE_CONTYPE=IQ SYBASE_IQ_LOAD=1 SYBASE_IQ_CESU-8=1 SYBASE_IQ_LOCKWAIT=600 SYBASE_IQ_BUFFER_SIZE=500000 SIQ_BULK_OP=1
C using lock wait time 600 for Sybase IQ.
C use bulk operations for IQ.
M *** ERROR => DlLoadLib()==DLENOACCESS - dlopen("libdbodbc17.so") FAILED
"libdbodbc17.so: cannot open shared object file: No such file or directory" [dlux.c 550]
M {root-id=005056B12F091EEC9A8E0D1FA0EC6CA7}_{conn-id=00000000000000000000000000000000}_0
C Could not load IQ library libdbodbc17.so.
M *** ERROR => DlLoadLib()==DLENOACCESS - dlopen("libdbodbc16.so") FAILED
"libdbodbc16.so: cannot open shared object file: No such file or directory" [dlux.c 550]
C Could not load IQ library libdbodbc16.so.
M *** ERROR => DlLoadLib()==DLENOACCESS - dlopen("libdbodbc12.so") FAILED
"libdbodbc12.so: cannot open shared object file: No such file or directory" [dlux.c 550]
C Could not load IQ library libdbodbc12.so.
C Could not load IQ odbc driver. No database connection possible.
C Load of odbc driver for Sybase IQ failed. Connect terminated.
B ***LOG BYI=> connect failed for connection SAPIQDB [dbds 999]
B ***LOG BZY=> unexpected return code 8192 calling DBDS [dbacds 2063]
B *** ERROR => Unexpected RC when calling dsql_connect
[dbacds.c 2064]


Read more...

Environment

SAP IQ 16.0
SAP IQ Network Client 16.0
HANA 2.0
BW-NLS setup

Product

SAP IQ 16.0 ; SAP IQ 16.1

Keywords

nearline storage;NLS;ADBC_TEST_CONNECTION;se38 , KBA , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , 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.