1977765 - [SAP IQ] Internal Error "s_ohcidx.cxx:5361" happened while running a delete statement. | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

1977765 - [SAP IQ] Internal Error "s_ohcidx.cxx:5361" happened while running a delete statement.

Symptom

  1. while running a delete statement, a non-fatal IQ internal error happened.
    IQ optimizer choses a mid method for deleting a HG index.
    DBCC reports "No error detected" for consistency check of the HG index using sp_iqcheckdb stored procedure.
  2. Error message & Stacktrace

[20917]: Delete of 5120347 rows started for table:
Mid Delete Failed for Index CDWADM.UK_INCOMEDEDUCTION.UK_INCOMEDEDUCTION_IXHG_PLACEMENTNO: 5120348 Rows Deleted. Expected 5120347.
   
********************************************************
**
**       Non-Fatal IQ Internal Error Detected
**       at s_ohcidx.cxx:5361  on thread 926 (TID 917)
**

_Z13ucstkgentraceii + ............
_Z23StackTraceForThisThreadPKciS0_S0_S0_ + ............
_ZN15hs_idxexceptionC1EPKciNS_12hs_idxerrorsEPK7s_indexjS1_S1_ + ............
_Z20hs_ThrowIdxExceptionPKciN15hs_idxexception12hs_idxerrorsEPK7s_indexjS0_S0_ + ............
_ZN12hs_ohcDelete8CompleteEv + ............
_ZN19s_ohcDeleteIterator8CompleteEv + ............
_ZN6hs_ohc9MidDeleteERK4s_bmiPK14hos_ValueRange + ............
_ZN6hs_ohc6DeleteEPK4s_bmyiiP8s_CKInfoPK14hos_ValueRange + ............
_ZN18hdb_delete_indices12Unit_of_WorkEi + ............
_ZN18hdb_delete_indices21hdb_delete_index_iter8ExecWorkERij + ............
_ZN13workAllocator6DoWorkEj + ............
_ZN13workAllocator7sDoWorkEPS_j + ............
_ZN10hos_thread4MainEv + 0x5e0 at ............
_ZN10hos_lwtask5StartEPS_ + ............
_Z15IQWorkerStarterPv + ............
run_task_body + ............
_ZN8UnixTask8pre_bodyEPv + ............
__pthread_bound_body + ............

   
Exception Thrown from s_ohcidx.cxx:5361, Err# 16, tid 917 origtid 917
   O/S Err#: 0, ErrID: 2068 (hs_idxexception); SQLCode: -1006003, SQLState: 'QBA03', Severity: 23
[20241]: IQ Internal error. Please report this to Sybase IQ support. CDWADM.UK_INCOMEDEDUCTION.UK_INCOMEDEDUCTION_IXHG_PLACEMENTNO 14 ???


Read more...

Environment

SAP SYBASE IQ 15.4 SP03 PL7 (15.4 ESD 3.7)

Product

SAP Sybase IQ 15.4

Keywords

s_ohcidx, delete, mid deleted failed, _ZN12hs_ohcDelete8CompleteEv , 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.