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 for Me (Login required).

Search for additional results

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