SAP Knowledge Base Article - Preview

2318028 - IQ server got crashed with "vp_OrderedProjection::Prepare()".

Symptom

An IQ server got aborted due to a simple query below.

 select now(*)
 from OWNER001.TAB001
 order by COL001;

[Stacktrace]

  Dump all thread stacks at st_server.cxx:1442 for PID: 8585270
  ...
  .vp_OrderedProjection::Prepare()                                             
  .vp_Cursor::PrepareProjection
  .dfo_VerticalLeafCursor::PrepareProjection()                                 
  .dfo_VerticalLeafCursor::PrepareChildrenAndProjection()                     
  .dfo_VerticalLeafCursor::PrepareOpus()                                     
  .dfo::PrepareChildren()                                                      
  .dfo::PrepareOpus()

If the order by clause is commented out, the crash does not happen.
     
 select now(*)
 from OWNER001.TAB001
 -- order by COL001;

The same crash doesn't happen in IQ 16.0.


Read more...

Environment

SAP IQ 15.4 ESD5.11

Product

SAP Sybase IQ 15.4

Keywords

IQ, crash, vp_OrderedProjection, vp_OrderedProjection::Prepare, CR 798778, 798778 , 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 ONE Support launchpad (Login required).

Search for additional results

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