SAP Knowledge Base Article - Preview

3248700 - SUM fails with ST22 dump Runtime Error DBIF_REPO_SQL_ERROR - ASE for BS

Symptom

  • SUM fails with ST22 dump Runtime Error DBIF_REPO_SQL_ERROR
  • Category               Resource bottleneck                                                          
    Runtime Errors         DBIF_REPO_SQL_ERROR                                                          
    Date and Time          
                                                                                                        
     
    Short Text                                                                                        
        SQL error 30046 while accessing program "CX_SY_OPEN_SQL_DB=============CP                     
           " part "LOAD".                                                                             
     
    What happened?                                                                                    
        Database error text: "[ASE Error SQL30046:08S01][SAP][ASE ODBC                                
         Driver]Connection to the server has been lost. Connection died while reading                 
         from socket. ERRNO returned 0. Check the server to determine the status of                   
         any open transactions."

  • ASE configuration allow parallel processing: 'number of worker processes' and 'max parallel degree' are greater than 1. 
    Signal 11 + stacktrace is reported at the same datetime in ASE error log and the SQL code might involve CDS view (ie SACMDT_METADATA_ENTITY_RO_VIEW).
    The stack traces reported depend on platform and configuration settings:

    • On Unix, ASE errorlog shows signal 11 in the module EquivClass::EquivClass():

            Current process (0x270014) infected with signal 11 (SIGSEGV)
            Address 0x0x0000000001ac2d31 (EquivClass::EquivClass(BmLight<VbmGtIdHidden>*, OptBlock*)+0x14591)

            with a stack trace including functions:

            EquivClass::EquivClass
            EquivClass::eqcCheapestNonBmoSortPop
            EquivClass::eqcEagerEnforce
            GttTable::GttUsefulIndex

    • On Windows, ASE errorlog shows system exception (0xc0000005) with stack including some or all of:

            Pop<ParallelCost,ParallelPropsPopEmit
            PopEmit<ParallelCost,ParallelProps>
            OptGlobal::_GblAddTopLevel
            OptGlobal::GblOptimize

            PopBase::getOptBlock
            OptGlobal::GblSetOneDegreePtn
            OptGlobal::_GblGeneratePllPops
            OptGlobal::_GblSearchEngine
            OptGlobal::GblOptimize


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP Netweaver - all versions

Product

SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver all versions

Keywords

DBIF_REPO_SQL_ERROR , SQL30046 , Connection to the server has been lost, SACMDT_METADATA_ENTITY_RO_VIEW , EquivClass::EquivClass , eqcCheapestNonBmoSortPop , eqcEagerEnforce , GttUsefulIndex , CR 815662 , CR815662 , 815662 , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.