Symptom
The following stack trace is generated when running sp_iqcheckdb against a corrupted object.
********************************************************
**
** Non-Fatal IQ Internal Error Detected
** at /home/iqabuild/views/links/r16.1.0_sp05_nbld_linux_64/gitsrc/cm/iqa/include/s_unitList.h:467 on thread 139511986321152 (TID 3972)
**
** 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: 25 SA connID: 6 IQ connID: 0000000332 User: DBA
** Time of error: 2024-06-18 09:10:02
** IQ Version: SAP IQ/16.1.050/11137/P/SP05.04
** OS info: IQ built on: Linux/Linux64 - x86_64 - 3.10.0-327, Executed on: Linux/cad-ocbplhyb002/4.18.0-513.5.1.el8_9.x86_64/#1 SMP Fri Sep 29 05:21:10 EDT 2023/x86_64
** Command status when error occurred: COMMAND ACTIVE
** Command text:
call "sp_iqcheckdb"('check table MECH.NON_FIN_TXN')
***************** This is the STACKTRACE ***************
===== Thread Number 139511986321152 (IQ connID: 0000000332) =====
<unknown>
pcstkwalk
ucstkgentrace
StackTraceForThisThread
hs_ulcontainerexception::hs_ulcontainerexception
v2s_bmcontext::bmlfblkget
v2s_bmcontext::bmver
v2s_bmcontext::bmverify
s_bm::GatherStatistics
hs_dp::GatherStatistics
db_IndexDef::GatherStatistics
db_Statistics::db_Statistics
db_dbccIter::ExecWork
workAllocator::DoWork
hos_thread::Main
hos_lwtask::Start
IQWorkerStarter
run_task_body
UnixTask::pre_body
<unknown>
<unknown>
******************* End of STACKTRACE ******************
**
** End of stack trace from Non-Fatal IQ Internal Error /home/iqabuild/views/links/r16.1.0_sp05_nbld_linux_64/gitsrc/cm/iqa/include/s_unitList.h:467
**
********************************************************
Exception Thrown from /home/iqabuild/views/links/r16.1.0_sp05_nbld_linux_64/gitsrc/cm/iqa/include/s_unitList.h:467, Err# 1, tid 3972 origtid 3972
O/S Err#: 0, ErrID: 2087 (hs_ulcontainerexception); SQLCode: -1009149, SQLState: 'QSB45', Severity: 14
[20189]: Unit List Internal Inconsistency:
-- (/home/iqabuild/views/links/r16.1.0_sp05_nbld_linux_64/gitsrc/cm/iqa/include/s_unitList.h 467) (1,1,0)
\{139511986321152\} DBCC: Statistics check detected exception from INDEX { MECH.NON_FIN_TXN.ASIQ_IDX_T1326454_C304_FP }
Read more...
Environment
SAP IQ 16.1 SP05.04
Product
Keywords
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.