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
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.