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.