SAP Knowledge Base Article - Preview

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

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

Search for additional results

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