SAP Knowledge Base Article - Preview

2166005 - Query on 2 table-join with like clause run forever - ASE

Symptom

  • A query with a LIKE clause does not return any results
  • The process consumes CPU resource
  • The process causes high CPU usage
  • The stack trace of the process will contain the following functions:

memalloc
PecConjPredicate::PecChoseHeteroBound
RgInterval::AnyRefineEachList
AnyInterval::AnyRefineAndCrtColBounds
PesState::PesRefinePredList
OptBlock::OptDoPredElim
OptGlobal::_GblSearchEngine
OptGlobal::GblOptimize
Optimize


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 prior to SP136
  • SAP Adaptive Server Enterprise (ASE) 16.0 prior to SP01 PL02

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

KBA , memory corruption , 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.