SAP Knowledge Base Article - Preview

3330490 - Getting error 702 on a query performing a 6 way self join against a view with a union - SAP ASE

Symptom

    • Running a select query with a 6-way self-join referencing a view which has a union clause.
    • The query fails with error 702:
      Error: 702, Severity: 20, State:1
      Memory request for 16514 bytes exceeds the size of single page of 16384 bytes.
         
    • Along with a stack trace which included following modules:
      memalloc
      _SybNew
      search_engine_handle
      SearchEngine::SeFindOptimalOptBlockPLan
      SearchEngine::_SeFindOptimalSaveThis
      SearchEngine::_SeFindOptimal
      SearchEngine::SeFindOptimal
      SearchEngine::SeFindOptimal
      OptGlobal::_GblSearchEngine
      OptGlobal::GblOptimize
      Optimize
      s_compile_stmt
      s_compile


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0 

Product

SAP Adaptive Server Enterprise 16.0

Keywords

CR 827979, CR#827979, 827979,    , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Known Error

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.