SAP Knowledge Base Article - Preview

2754124 - sp_iqrebuildindex internal IQ error - SAP IQ

Symptom

IQ Internal error 's_ohcidx.cxx:9340' happened when trying to rebuild index using sp_iqrebuildindex.

Error occurs even on new table with data loaded. Currently founded followings,
 - Retiering of the column does not help
 - Datatype of column involved in varchar(10)
 - Other tables have the same issue
 - Issue has existed in previous PL's as well

  • Error & Stack trace

(etl)> drop index xxx.table1.npi_hg;
Execution time: 0.586 seconds
(etl)> create hg index pharmacy_npi_hg on xxx.table1( npi);
Execution time: 57.25 seconds
(etl)> call sp_iqrebuildindex ( 'xxx.table1', 'index npi_hg');
Could not execute statement.
  ..
  ..  ** Non-Fatal IQ Internal Error Detected
  ..  ** at slib/s_ohcidx.cxx:9340 on thread 139987057411840 (  TID 11)
  ..  **

 ****** STACKTRACE ******
  ..          
  .. hs_ThrowIdxException                
  .. hs_ohc::ReleaseInsertSubIndex       
  .. dfo_HGIndexInsert::PostFetchOpus    
  .. df_CombinerFinalFetchHelper::ExecWork
  .. workAllocator::DoWork               
  .. hos_team::StartWork                 
  .. hos_team::Exec                      
  .. df_CombinerFinalFetchHelper::Run    
  .. dfo_Combiner::FetchOpus             
  ..


Read more...

Environment

SAP IQ 16.0

Product

SAP IQ 16.0

Keywords

ReleaseInsertSubIndex , 'sp_iqrebuildindex' , 813073, s_ohcidx.cxx ,   , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.