SAP Knowledge Base Article - Preview

2245848 - Loading data into a table with UNIQUE multicolumn THG indexes starts failing with Non-Fatal errors at s_ohcindx.cxx - SAP IQ 16.0

Symptom

  • LOAD TABLE statements on tables containing multicolumn Tiered High Group indexes using IGNORE CONSTRAINT UNIQUE start to fail with Non-Fatal Internal errors at s_ohcidx.cxx and stack trace with a call to hs_subohc::GetIdentity():

Insert for 'transactions_messages' completed in 629 seconds. 59147294 rows inserted.
NumEntries: 13869943704 Ebm Count: 13869943705 Dbm Count: 0
_isPhysicallyEmpty : 0 _isEmpty0 IsConstraintViolation: 0 Unique(): 1
_OID._recCount: 13869943705 _OID._inUse: �_pBT->GetNumEntries():13869943704 _pConjugateBT->GetNumEntries(): 0

********************************************************
**
** Non-Fatal IQ Internal Error Detected
** at slib/s_ohcidx.cxx:948 on thread 140727798220544 (TID 7)
...
** Error from IQ connection: SA connHandle: 4212 SA connID: 27 IQ connID: 0000325304 User: xxx
** Time of error: 2015-10-20 10:48:56
** IQ Version: SAP IQ/16.0.0/150514/P/sp08.32
** OS info: IQ built on: Enterprise Linux64 - x86_64 - 2.6.18-194.el5, Executed on: Linux/xxxxxxxx.x86_64/#1 SMP Fri Sep 4 05:21:52 CDT 2015/x86_64
** Command status when error occured: CURSOR ACTIVE
** Command text:
>

  • The stacktrace includes the following calls: 

hs_ThrowIdxException
hs_subohc::GetIdentity
hs_ohc::GetIdentity
db_IndexDef::FlushIndexIdentity
db_IndexDef::CloseSIndexWithLock
db_IndexDef::CloseSIndex
df_Table::CloseIdxAndInserters
dfo_Scheduler::CompleteOpus
dfo::Complete
dfo_Root::CompleteAllDFOsBelowRoot
dfo_Root::Complete
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
DoExecuteStmt
exec_procedure_stmt
run_procedure
dbi_resume_procedure
handle_open
db__open
RequestProcedure::call
Context::call
Worker::call_on_stack
TopProcedure::call

  • Running sp_iqcheckdb verify, against the tables involved, is reporting "** Inconsistent Index"  and "** Non-Completed Index" errors


Read more...

Environment

SAP IQ 16.0

Product

SAP IQ 16.0

Keywords

RI, referential integrity, sybase, corrupt, crash, abort, constraint, enforce, consistency, checkdb, dbcc, IQ16, THG, HighGroup, violation, CR791403, CR#791403, 791403 , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed

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.