SAP Knowledge Base Article - Preview

3054992 - signal 11 (SIGSEGV) at (PopDistinct<ParallelCost, ParallelProps>::_popConsGroupOrdering) for query with ROWS LIMIT - SAP ASE for BS


  • ST22 dump shows error 30046 Connection to the server has been lost:

    Category Resource bottleneck
    Runtime Errors DBIF_REPO_SQL_ERROR
    Date and Time 06.04.2021 11:28:26

    Short Text
    SQL error 30046 while accessing program "CX_SY_SQL_ERROR===============CP
    " part "LOAD".

  • ASE log reports Current process (0xxxxxxx) infected with signal 11 (SIGSEGV) with stack trace:         

        PopDistinct<ParallelCost, ParallelProps>::_popConsGroupOrdering()
        Pop1<ParallelCost, ParallelProps>::_popMatchOrdering()
        Pop<ParallelCost, ParallelProps>::popMatchProperties()

  • The involved query has ROWS LIMIT like following:

        SELECT SUM( ... )  FROM ... WHERE "MANDT" = '100' GROUP BY ... ORDER BY ... ROWS LIMIT 2147483647




  • SAP Adaptive Server Enterprise (ASE) 16.0 SP03 PL08 HF1 for Business Suite

  • SAP Adaptive Server Enterprise (ASE) 16.0 SP03 PL08 HF1

  • SAP NetWeaver (NW) - All versions


SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver all versions


CR 824730, CR#824730, 824730, ROWS LIMIT, SQL30046 , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

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.