2000198 - IQ server returns an internal error "vplib/vp_Projections.cxx:1105". | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2000198 - IQ server returns an internal error "vplib/vp_Projections.cxx:1105".

Symptom

  1. IQ server returns an internal error "vplib/vp_Projections.cxx:1105" against a select distinct statement.

select distinct "cif" from "rty"
 
There is approximatly 1,300,000 rows of data in that column.
The query works when there is no HG index on that column as soon as they create a HG index the stacktrace is produced.
When setting the IQ option aggregation_preference = 3 then the query works.

  1. Error messages

********************************************************
**
** Non-Fatal IQ Internal Error Detected
** at vplib/vp_Projections.cxx:1105 on thread 1438242560 (TID 10)
**


pcstkwalk(..............
ucstkgentrace(..............
StackTraceForThisThread(..............
df_Exception::df_Exception(..............
df_Exception::ThrowException_0(..............
vp_OrderedProjection::Prepare(..............
vp_Cursor::PrepareProjection(..............
dfo_VerticalLeafCursor::PrepareProjection(..............
dfo_VerticalLeafCursor::PrepareChildrenAndProjection(..............
dfo_VerticalLeafCursor::PrepareOpus(..............
dfo::PrepareChildren(..............
dfo_Cursor::PrepareOpus(..............
dfo::PrepareChildren(..............
dfo::PrepareOpus(..............


Read more...

Environment

  • SAP SYBASE IQ 16.0 SP03

Product

SAP IQ 16.0

Keywords

  • vplib/vp_Projections, vp_Projections, vp_OrderedProjection::Prepare, vp_OrderedProjection, select distinct, 759084
, 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.