2197020 - Query with TOP and abstract plan using a user defined optimization goal fails with a stack trace - SAP BW on ASE

• ASE errorlog may report a stack trace when running a SQL query containing TOP and abstact plan with a user defined optimization goal.

• Here is an example of SQL Text:
  
  delete top 100000 "/XXX/XXXX_XXXXX" from "/XXX/XXXX_XXXXX" "E" where "E"."KEY_XXX_XXXXX4" IN ( select "DIM1"."DIMID" from "/XXXX_XXXXX" "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 stack trace:

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

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

ogGetFastfirstrowCt, selective, CR782869, CR#782869, 782869, stacktrace , KBA , selective delete , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , Bug Filed