SAP Knowledge Base Article - Preview

2497589 - Select distinct query causing Non-Fatal IQ error at vp_GroupedProjection::Prepare

Symptom

SELECT DISTINCT query on a table with a HG index and duplicate rows caused a Non-fatal exception at vp_Projections.cxx:751 with a stack throw at call to vp_GroupedProjection::Prepare

 The stacktrace generated:


********************************************************
**
** Non-Fatal IQ Internal Error Detected
** at vplib/vp_Projections.cxx:751 on thread 139635944544000 (TID 602)
** Error detected at DFO #02 Grouped Leaf
** for expression: FPORDINAL(rg.CdGrupo, 1) [0x0x7f0334218a48, hn:524, qb:1]
**
** Please report this to SAP IQ support
** with the following diagnostic information,
** and, if possible, with the user's command.
**
** Error from IQ connection: SA connHandle: 90 SA connID: 22 IQ connID: 0000000654 User: user1
** Time of error: 2017-02-19 14:27:17
** IQ Version: SAP IQ/16.0.110/10364/P/sp11.06
** OS info: IQ built on: Enterprise Linux64 - x86_64 - 2.6.18-194.el5, Executed on: Linux/server-.....
** Command status when error occured: CURSOR ACTIVE

***************** This is the STACKTRACE ***************


===== Thread Number 139635944544000 (IQ connID: 0000000654) =====

vp_GroupedProjection::Prepare

vp_Cursor::PrepareProjection

dfo_VerticalLeafCursor::PrepareProjection

dfo_VerticalLeafCursor::PrepareChildrenAndProjection

dfo_VerticalLeafCursor::PrepareOpus

df_DFOPrepareIterator::ExecWork

workAllocator::DoWork

hos_thread::Main

hos_lwtask::Start

IQWorkerStarter

run_task_body

UnixTask::pre_body


Read more...

Environment

  • SAP IQ 16.0 SP08.x
  • SAP IQ 16.0 SP11.x
  • SAP IQ 16.1 SP01.x

Product

SAP IQ 16.0 ; SAP IQ 16.1

Keywords

Sybase, stktrc, stacktrace, Grouped Leaf, vp_Projections.cxx, vp_GroupedProjection, aggregation, 795452, CR795452, CR#795452, 811396, CR811396, CR#811396 , 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.