SAP Knowledge Base Article - Preview

3230658 - DBCO connection from BW to SAP IQ16.1 fails

Symptom

  • DBCO connection test
    sm38 -> ADBC_TEST_CONNECTION -> <DB Connection Name> 
    Got error: work process restarted, ABAP session terminated.

  • st22 error

    Category               Internal error                                                               
    Runtime Errors         SYSTEM_CORE_DUMPED                                                           
    Date and Time          12.07.2022 16:19:36 

    Short Text                                                                                        
        Process terminated by signal 11.  

  • dev trace error

    Symptom 1:                                                                                                                                                                                                                               
    ===============
    B  Loading DB library '/usr/sap/<SID>/<nnn>/exe/dbsybslib.so' ...                                                                                                                                                                                                   
    B  Library '/usr/sap/<SID>/<nnn>/exe/dbsybslib.so' loaded                                                                                                                                                                                                           
    B  Version of '/usr/sap/B4D/D40/exe/dbsybslib.so' is "777.05", patchlevel (0.427)                                                                                                                                                                               
    C  trace file set                                                                                                                                                                                                                                               
    B  Connect to SAP_IQ3 as DBA with SYBASE_CONN_TIMEOUT=10 SYBASE_CONTYPE=IQ SYBASE_IQ_CESU=1 SYBASE_SERVER=<host_name> SYBASE_DBNAME=<dbname> SYBASE_PORT=<nnn> SYBASE_IQ_ENGINE=<server_name>                                              
    C  load of IQ library libdbodbc17.so successful.                                                                                                                                                                                                                
    M  si_code = 1                                                                                                                                                                                                                                                  
    M  Sending process ID = 0                                                                                                                                                                                                                                       
    M  Real user ID of sending process = 0                                                                                                                                                                                                                          
    M  SEGV_MAPERR: Address not mapped to object                                                                                                                                                                                                                    
    M  (nil) (Memory location which caused fault)                                                                                                                                                                                                    
    ================

    Symptom 2 - IQ library libdbodbc17.so could not be loaded and no error info printed:
    ==============
    B Mon Aug  1 03:43:24:389 2022                                                                                                                                                                                                                                  
    B  Loading DB library '/usr/sap/WB4/D00/exe/dbsybslib.so' ...                                                                                                                                                                                                   
    B  Library '/usr/sap/WB4/D00/exe/dbsybslib.so' loaded                                                                                                                                                                                                           
    B  Version of '/usr/sap/WB4/D00/exe/dbsybslib.so' is "777.05", patchlevel (0.500)                                                                                                                                                                               
    C  trace file set                                                                                                                                                                                                                                               
    B  Connect to SAPIQDB as dba with SYBASE_CONTYPE=IQ SYBASE_SERVER=vm-nls.openstack.eu-de-1.cloud.sap SYBASE_PORT=31238 SYBASE_IQ_ENGINE=SAPIQSERVER SYBASE_DBNAME=SAPIQDB SYBASE_IQ_LOCKWAIT=600                                                                
    C  using lock wait time 600 for Sybase IQ.                                                                                                                                                                                                                      
    ===============                                                               

       


Read more...

Environment

Net Weaver 7.53
SAP Kernel 7.77 64 bit UNICODE
HANA 2.0 
SAP IQ 16.1
SAP Network client 16.1

Product

SAP BW/4HANA 2.0 ; SAP IQ 16.1

Keywords

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 for Me (Login required).

Search for additional results

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