SAP Knowledge Base Article - Preview

2298521 - In IQ16 SP10.11, 's_dpidx.cxx' was detected in consistence index checking.

Symptom

After installed SP10.11, a delete query encountered 's_dpidx.cxx:7241' error.
  While deleting, two indexes were detected problem in allocation pages.
  It's not sure if the table has been damaged or it was fine before the s_dpidx error.
 
  DBA ran DBCC after the erro, but **_ITR_DY' checked as 'No error detected'.
  After the delete job, in SP10.11, server detected the 's_dpidx.cxx' in index verification phase
  and let the changes by delete job be rollbacked.
  
   I. 03/28 23:34:13. 0000009487  barray t1447 **_OVD_ACCN: CheckColumnEBMCoverage
   I. 03/28 23:34:13. 0000009487   barray t1447*** duplicate barray page in ridmap: 70
   I. 03/28 23:34:13. 0000009487 t1447 *** **_ITR_DY.ASIQ_IDX_T2100_C28_FP(bigint): multiple ridmap regions link to the same page.
   ...
   ...
   I. 03/28 23:34:13. 0000009487     ********************************************************
   I. 03/28 23:34:13. 0000009487     **
   I. 03/28 23:34:13. 0000009487     **       Non-Fatal IQ Internal Error Detected
   I. 03/28 23:34:13. 0000009487     **       at slib/s_dpidx.cxx:7241  on thread 1447 (TID 1438)
   ...
   I. 03/28 23:34:13. 0000009487 t1424 *** **_ITR_DY.ASIQ_IDX_T2100_C43_FP(bigint): blockmap page allocation mismatch: 1808,1,1807,1
   I. 03/28 23:34:13. 0000009487 t1424 *** **_ITR_DY.ASIQ_IDX_T2100_C43_FP RidMap:
   ...
   ...
   I. 03/28 23:34:13. 0000009487 [20238]: IQ Internal error. Please report this to SAP IQ support.
   I. 03/28 23:34:13. 0000009487 t1424 *** **_ITR_DY.ASIQ_IDX_T2100_C43_FP(bigint): blockmap page allocation mismatch: 1808,1,1807,1
   I. 03/28 23:34:13. 0000009487 Blockmap Member Variables for eaecacf78
   I. 03/28 23:34:13. 0000009487 From slib/s_dpidx.cxx:572

 * stack in *iqmsg =>
    ...
   ===== Thread Number  1447  (IQ connID: 0000009487) =====
    ..
    .. void StackTraceForThisThread ..
    .. void hs_dp::CheckIndexConsistency(int) ..
    .. void hdb_delete_indices::Unit_of_Work(int)..
    .. int hdb_delete_indices::hdb_delete_index_iter::ExecWork(int&,unsigned) ..
    .. void workAllocator::DoWork(unsigned) ..
    .. int hos_thread::Main() ..
    .. int hos_lwtask::Start(hos_lwtask*) ..
    .. void IQWorkerStarter(void*) ..
    .. void*UnixTask::pre_body(void*) ..


Read more...

Environment

IQ 16.0 SP10.x

Product

SAP IQ 16.0

Keywords

"duplicate barray page in ridmap"; "s_dpidx.cxx" ; "CheckIndexConsistency" ; 'hdb_delete_indices" ; "ridmap overlap" ; , 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.