SAP Knowledge Base Article - Preview

2617016 - SAP IQ server could crash during concurrent execution of the same stored procedure - SAP IQ 

Symptom


  • SAP IQ server could crash during concurrent execution of the same stored procedure that contains a subquery / a derived table block with the proxy / IQ tables.
  • The stack trace contains the functions GetNewTree.

    [Sample Stack trace]
    GetNewTree
    MakeExternalCursor
    MakeVolcanoOptimizerCursor
    MakeCursor
    dbi_openselect
    dfe_BuildManagerProc::makeSubqueryCursor
    dfe_BuildManagerProc::BuildExists
    dfe_Factory::BuildAndArgs
    dfe_Builder::BuildPrepExpr
    dfe_Builder::BuildPrepExprValueWithDFE
    dfe_ProcedureExprEvaluator::DoAnnotateAndBuild
    dfe_ProcedureExprEvaluator::AnnotateAndBuildPred
    exec_procedure_stmt
    run_procedure
    dbi_resume_procedure
    handle_open
    do_cursor_execute
    db__execute_any_imm
    do_request
    RequestProcedure::call
    Worker::spawn


Read more...

Environment

  • SAP IQ 16.1
  • SAP IQ 16.0

Product

SAP IQ 16.0 ; SAP IQ 16.1

Keywords

CR812294, CR#812294, 812294 , stacktrace, stktrc , Sp , sub-query , KBA , BC-SYB-IQ , Sybase IQ , Problem

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.