SAP Knowledge Base Article - Preview

2283395 - SQL5702 error for some complex queries causing disconnection (SQL30046) - SAP BW on ASE

Symptom

  • Report execution fails with error SQL5702 "ASE is terminating this process" returned with some complex BW queries (i.e. coming from BPC report).
  • For BPC client, when you try to refresh a workbook, after some time an error "Errors found retrieving data" occurs.
  • SM21 transaction shows Error SQL5702 followed by a work process Error SQL30046:

KBA_2283395_SM21.jpg

  • The ASE error log (from DBACockpit > SID > Diagnosis > Error log) shows an "infected with signal 11" error with a stack trace referencing the following modules: 

GttTable::getStarQueryGtIdOrder
sequencer

SearchEngine::SeFindOptimalOptBlockPlan
SearchEngine::_SeFindOptimal
SearchEngine::SeFindOptimal
OptGlobal::_GblSearchEngine
OptGlobal::GblOptimize

  Note: An exmaple of a complete stack trace is available under Attachments.

  • Latest versions of the following SAP Notes have been implemented in the BW system:
    • The SAP BW Correction Collection (check for the SAP Note related to your BW version on "See also" section of this KBA)
    • SAP Note 2103636 - SYB: Adaptions for SAP ASE 16.0 SP01 PL01


Read more...

Environment

  • SAP Business Warehouse (BW)
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 16.0 ; SAP Business Warehouse all versions

Keywords

30046, 5702, CR795815, CR#795815, 795815, derived, union, query, stacktrace, SEGV, segmentation, storage, access, violation, fault, segfault, kisignal, stacktrace,  stack, registers, sap_olap, CR780097, CR#780097, 780097, fact_table, fact, hint , KBA , BW-SYS-DB-SYB , BW 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.