SAP Knowledge Base Article - Preview

2197020 - SQL query with TOP and abstract plan using user defined optimization goal may fail with stack traces reported in the error log - SAP BW on ASE

Symptom

  • ASE errorlog may report stack trace when running the SQL query containing TOP and abstact plan with user defined optimization goal.
  • Here is an example of SQL Text:
    delete top 100000 "/BIC/EZIC_SLCNM" from "/BIC/EZIC_SLCNM" "E" where "E"."KEY_ZIC_SLCNM4" IN ( select "DIM1"."DIMID" from "/BIC/DZIC_SLCNM4" "DIM1" join "/BI0/SDATE" "MD1" on "DIM1" . "SID_0DATE" = "MD1" . "SID" where ( "MD1"."DATE0" < '20150409' ) ) PLAN '(use optgoal sap_olap) (use parallel 4) (use fact_table E)'
  • Following modules can be found at top of the stacktrace:

OptGoal::ogGetFastfirstrowCt
SeHyPermStrat::SeInitForFastfirstrow
SeHyPermStrat::SeInit
SearchEngine::SeFindOptimalOptBlockPlan

  • ABAP short dump

Database error text: [ASE Error SQL30046:08S01][SAP][ASE ODBC
Driver]Connection to the server has been lost. Connection died while writing
to socket. Socket returned error code 10053. Check the server to determine
the status of any open transactions.
Triggering SQL statement:  "CX_RS_PROGRAM_ERROR===========CP        "

  •  SM21 log

SM21Capture.JPG

 


Read more...

Environment

  •  SAP Adaptive Server Enterprise (ASE) 16.0 SP01 PL01
  •  SAP BW

Product

SAP Adaptive Server Enterprise 16.0

Keywords

OptGoal::ogGetFastfirstrowCt, '(use optgoal sap_olap)', abstract plan, parallel, ogGetFastfirstrowCt, sap_olap, selective , KBA , selective delete , BW-SYS-DB-SYB , BW 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.