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 for Me (Login required).

Search for additional results

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