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.
SAP Knowledge Base Article - Preview