SAP Knowledge Base Article - Preview

2895993 - sp_iqrebuildindex on Unique HG index, server got aborted with stack '..s_btBulkLoadCursor<s_btfdiskbloc..' , 'hs_ohcInsert' -- SAP IQ

Symptom

When sp_iqrebuildindex on Unique HG index, server got aborted with stack '..s_btBulkLoadCursor<s_btfdiskbloc..' , 'hs_ohcInsert'.
But DBCC on the same index reported 'No Error Detected'. It happened once, but no more reproduction after restoration. Customer has been restoring test DB from production weekly.

  call "sp_iqrebuildindex"('DBA.SecurityESG','index IDX_SecurityESGVID')

  ===== Thread Number ... =====
   ..
   .. hos_ABORT..
   ..
   .. s_btBulkLoadCursor<s_btfdiskblock, s_btfitem>::~s_btBulkLoadCursor ...
   .. s_btBulkLoadCursor<s_btfdiskblock, s_btfitem>::~s_btBulkLoadCursor ...
   .. s_btBulkLoadCursor<s_btfdiskblock, s_btfitem>::~s_btBulkLoadCursor ...
   .. s_btBulkLoadCursor<s_btfdiskblock, s_btfitem>::~s_btBulkLoadCursor ...
   .. s_btBulkLoadCursor<s_btfdiskblock, s_btfitem>::~s_btBulkLoadCursor ...
   .. s_btBulkLoadCursor<s_btfdiskblock, s_btfitem>::~s_btBulkLoadCursor ...
   .. hs_ohcInsert::~hs_ohcInsert()...
   .. dfo_HGIndexInsert::FetchOpus()...


Read more...

Environment

SAP IQ16.1 SP03.x

Product

SAP IQ 16.1

Keywords

sp_iqrebuildindex, s_btBulkLoadCursor, s_btfdiskbloc, hs_ohcInsert, , 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.