Symptom
IQ Server stops due the a stack trace with the following functions:
======
** Error from IQ connection: SA connHandle: 1183 SA connID: 32 IQ connID: 0000622901 User: DBA
** Time of error: 2017-08-31 09:29:11 ** IQ Version: SAP IQ/16.0.110/10318/P/sp11.03
** OS info: IQ built on: Sun_Sparc/OS 5.10, Executed on: SunOS/xxxxxxxdb09n1/5.11/11.3/sun4v
** Command status when error occured: CURSOR ACTIVE
** Command text: execute "proc01"
Dump all thread stacks at stcxtlib/st_server.cxx:1928 for PID: 2031
**************** This is the STACKTRACE ***************
s_ColumnVector*s_mergeRHSReader::NextVectorForRollover
s_mergeFINALWriter::FinalRollover
hs_dpInsert::Rollover
s_mergeFINALWriter::NBitToFlatRolloverForUpdate
s_mergeFINALWriter::DoInsert
hs_dpInsert::Insert(const s_ColumnVector*)
hs_dpUpdate::CompleteFullInsert
hs_dpUpdate::Complete()
db_UpdateCompleteIterator::CompleteIndex(s_indexUpdate*)
db_UpdateCompleteIterator::ExecWork
workAllocator::DoWork
hos_thread::Main
Another variation of stacktrace for the same issue is :
s_ColumnVector*s_mergeRHSReader::NextVectorForRollover
void s_mergeFINALWriter::FinalRollover
void hs_dpInsert::Rollover
int df_FPRolloverIterator::ExecWork
void workAllocator::DoWork
void hos_team::StartWork
void hos_team::Exec
void dfiio_FP::RolloverIfNeeded
void dfiio_FP::PostFetchOpus
void dfo_IndexInsert::PostFetchOpus
int df_CombinerFinalFetchHelper::ExecWork
void workAllocator::DoWork
int hos_thread::Main
Read more...
Environment
- SAP IQ 16.0
Product
Keywords
st_server.cxx s_ColumnVector*s_mergeRHSReader s_mergeFINALWriter::FinalRollove distinct values IQ Abort cardinality columns 786458 789479 , 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.
SAP Knowledge Base Article - Preview