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
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.