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
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.
SAP Knowledge Base Article - Preview