Symptom
- stack traces in the iqmsg file and requested an investigation to ensure there is no table corruption in their production system.
- sp_iqcheckdb does not report errors
- The error messages indicate a page header mismatch and internal inconsistency in SAP IQ.
Messages and Stacktrace:
BARRAY: save partition *** slib/s_barray.cxx:13891
BARRAY: save partition *** slib/s_barray.cxx:13891
...
BARRAY: save partition *** slib/s_barray.cxx:13891
..
t*** slib/s_barray.cxx:11889 - (***) != (***)
** Non-Fatal IQ Internal Error Detected
** at slib/s_barray.cxx:11898
**
** Please report this to SAP IQ support
** Error from IQ connection:
** Time of error: xxxx
** Command text:
Statement text unavailable
***************** This is the STACKTRACE ***************
===== Thread Number xxx (IQ connID: xxx) =====
StackTraceForThisThread
s_mergeFINALWriter::LoadPageForMerge
s_mergeFINALWriter::DoInsert
hs_dpInsert::Insert
dfiio_FP::FinalFetchOpus
dfo_IndexInsert::FinalFetchOpus
df_CombinerFinalFetchHelper::DoFinalFetch
df_CombinerFinalFetchHelper::ExecWork
workAllocator::DoWork
hos_team::StartWork
hos_team::Exec
df_CombinerFinalFetchHelper::Run
dfo_Combiner::FetchOpus
dfo_Sequencer::FetchOpus
dfo_Root::FetchOpus
db_dmlcommand::ExecuteDFOTree
db_LoadTable::Execute
st_command::DoCmdThroughResourceGate
st_iqdml::Load
UIQDML_Load
st_SAIQInterfaceInfo::callFunction
st_SAIQInterface::RunIQFunc
st_SAIQInterface::Execute
saint_iqthresholddml::Load
dbi_load_table
DoExecuteBodyLocal
DoExecuteStmt
exec_procedure_stmt
run_procedure
call_procedure
DB_Exec_event_handler
EventHandler::do_request
Worker::spawn
RQInternalBaseItem::do_work
RequestQueue::worker_body
request_task(void*)+89
run_task_body+1e
UnixTask::pre_body
INFO [hos_InMemMsgLog::BroadcastDumpInMemMsgLog] from slib/s_barray.cxx:11913 local/remote server ids:1/2
Exception Thrown from slib/s_barray.cxx:11918, Err# 7
O/S Err#: 0, ErrID: 2065 (hs_BArrayexception); SQLCode: -1009149, SQLState: 'QSB45', Severity: 14
BArray page header mismatch Internal Inconsistency:
-- (slib/s_barray.cxx 11918) (7,N/A,N/A)
Exception Thrown from slib/s_barray.cxx:11918, Err# 7
O/S Err#: 0, ErrID: 2065 (hs_BArrayexception); SQLCode: -1009149, SQLState: 'QSB45', Severity: 14
[xxx]: BArray page header mismatch Internal Inconsistency:
Exception Thrown from slib/s_barray.cxx:11918,
O/S Err#: 0, ErrID: 2065 (hs_BArrayexception); SQLCode: -1009149, SQLState: 'QSB45', Severity: 14
BArray page header mismatch Internal Inconsistency:
-- (slib/s_barray.cxx 11918)
Cleaning pending errors from slib/s_bmCur.cxx:948
Read more...
Environment
SAP IQ 16.1 SP05 PL12
Product
Keywords
830864, CR830864, CR#830864, "s_mergeFINALWriter::LoadPageForMerge", "s_mergeFINALWriter::DoInsert", "hs_dpInsert::Insert " , KBA , BC-SYB-IQ , Sybase IQ , Known Error
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.