SAP Knowledge Base Article - Preview

2994356 - DBCO connection fails on Unrecognized encryption option 'skip_certificate_name_check' - SAP IQ NLS

Symptom

  • SAP IQ ODBC driver 16.0 is installed.
  • A symbolic link libdbodbc17.so points to the real lib file libdbodbc16.so.
  • SAP IQ server is started with encryption option -ec.
  • Upgraded SAP BW 7.53 PL 427 to PL 700, When connecting through DBCO with client encrypted connection option SYBASE_SSL=1, this error can be seen in dev trace log:

B Connect to IQNLS as SAPSUER with SYBASE_CONN_TIMEOUT=10 SYBASE_CONTYPE=IQ SYBASE_IQ_CESU-8=1 SYBASE_SERVER=IQHOSTNAME SYBASE_DBNAME=DBNAME SYBASE_PORT=11111 SYBASE_IQ_ENGINE=IQNLS SYBASE_SSL=1 SYBASE_IQ_BUFFER_SIZE=500000 SYBASE_IQ_LOCKWAIT=600
C using ssl.
C using lock wait time 600 for Sybase IQ.
C load of IQ library libdbodbc17.so successful. ==> DBSL finds and loads libdbodbc17.so
C lib_dbsl 753 04/16/2020 12:36:00
C dbsybslib.dll patch info
C SAP patchlevel 0
C SAP patchno 700
C Last SYBASE DBSL patchlevel 0
C Last SYBASE DBSL patchno 700
C Last SYBASE DBSL patchcomment SAP Support Package Stack Kernel 7.53 Patch Level 700 (2957666)
C ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 6500]
C (-895) [08001] [Sybase][ODBC Driver][SQL Anywhere]Encryption error: Unrecognized encryption opt
C ion 'skip_certificate_name_check'
C Connection 0 failed using DRIVER={SQL Anywhere 12}; CommLinks=tcpip(HOST=IQHOSTNAME;ServerPort=11111);uid=SAPUSER;DatabaseName=DBNAME;ServerName=IQNLS;pwd=xxxxx;
   Encryption=tls(fips=NO;tls_type=rsa;trusted_certificate=/usr/sap/SID/SYS/global/certificate.crt;skip_certificate_name_check=yes);
C
B ***LOG BY2=> sql error -895 performing CON [dbds 989]
B ***LOG BY0=> [IQ Error SQL-895:08001][SQL Anywhere]Encryption error: Unrecognized encryption option 'skip_certificate_name_check' [dbds 989] 


Read more...

Environment

  • SAP IQ 16.0
  • SAP IQ 16.1 
  • SAP BW 7.53

Product

SAP IQ 16.0 ; SAP IQ 16.1

Keywords

libdbodbc17.so; libdbodbc16.so; skip_certificate_name_check; SYBASE_SSL ; encryption ; , KBA , BC-SYB-IQ , Sybase IQ , 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 for Me (Login required).

Search for additional results

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