SAP Knowledge Base Article - Preview

2297346 - An internal error "slib/s_blockmap.cxx:12664" happened and FP index corrupted.

Symptom

1) An internal error "slib/s_blockmap.cxx:12664" happened while extracting data.
  I. 02/28 14:37:36. 0000086265   The following exception is BUFMAN_BLOCKMAP_INFO_ERROR (-1009047)
  I. 02/28 14:37:36. 0000086265   from s_ROBlockmapCursor::Find
  I. 02/28 14:37:36. 0000086265 Blockmap Member Variables for 1c64beb3c8
  I. 02/28 14:37:36. 0000086265 From slib/s_dpidx.cxx:571
  I. 02/28 14:37:36. 0000086265   _nextPartitionForHelperFlush = 0
  ............
  ............
  I. 02/28 14:37:36. 0000086265 Exception Thrown from slib/s_blockmap.cxx:12664, Err# 0, tid 1848 origtid 1848
  I. 02/28 14:37:36. 0000086265    O/S Err#: 0, ErrID: 2091 (s_internalexception); SQLCode: -1001012, SQLState: 'QFA12', Severity: 18
  I. 02/28 14:37:36. 0000086265 [20521]: Internal state violation, please contact SAP IQ support

2) Stacktrace
  void StackTraceForThisThread(.................
  void s_blockmap::ThrowError(s_bufman_errorInfo,.................
  s_buf*s_ROBlockmapCursor::Find(.................
  void*s_bArrayCursor::Find(.................
  void s_bArrayLocater::LoadBlock(.................
  unsigned*s_bArrayLocater::LocateTokenRecord(.................
  s_indexfetch::s_fetchRetVal hs_dpfetch::FetchNoCopyContiguous(.................
  int s_fetchRow::FetchContiguous()+.................
  int vp_Cursor::Fetch()+.................
  int dfjo_HashParaT1::FetchOpus()+.................
  int dfo_cOrderByParaIn::ExecWork(.................
  void workAllocator::DoWork(.................

3) DBCC report
  ** DBCC Status Errors Detected ******
  ** DBCC Unknown Exceptions 1 ******
      
  ================================================== ============================== ======
  Index Summary   
  ================================================== ============================== ======
  ** Inconsistent Index Count 1 ******
     Verified Index Count 62 
  ** Non-Completed Index Count 1 ******
  
  ** Inconsistent Index OWNER001.TAB001_blockmap_error.ASIQ_IDX_T3386_C37_FP ******
 
4) It seems like it's very similar with CR 786326 which is dup of 786619.
     Those CRs have been fixed in SP10 PL10.
 
  [CR 786326]
  I. 06/26 23:47:46. 0000004870 Exception Thrown from dblib/db_iqutility.cxx:8665, Err# 20, tid 6 origtid 6
  I. 06/26 23:47:46. 0000004870    O/S Err#: 0, ErrID: 1034 (db_dbccexception); SQLCode: -1000276, SQLState: 'QDB69', Severity: 23
  I. 06/26 23:47:46. 0000004870 [21094]: At least one mode and target must be specified. 
  I. 06/27 00:01:57. 0000004870   The following exception is BUFMAN_BLOCKMAP_INFO_ERROR (-1009047)
  I. 06/27 00:01:57. 0000004870   from s_ROBlockmapCursor::Find
  I. 06/27 00:01:57. 0000004870 Blockmap Member Variables for 0x12fcedb888
  I. 06/27 00:01:57. 0000004870 From slib/s_dpidx.cxx:563
  ............
  ............
  I. 06/27 00:01:58. 0000004870 Exception Thrown from slib/s_blockmap.cxx:12531, Err# 0, tid 1270 origtid 1270
  I. 06/27 00:01:58. 0000004870    O/S Err#: 0, ErrID: 2091 (s_internalexception); SQLCode: -1001012, SQLState: 'QFA12', Severity: 18
  I. 06/27 00:01:58. 0000004870 [20521]: Internal state violation, please contact SAP IQ support
  
  *** DBCC report from CR 786326
  I. 06/27 00:03:19. 0000004870 ** DBCC Status: Errors Detected  ******
  I. 06/27 00:03:19. 0000004870 ** DBCC Unknown Exceptions: 3  ******
  I. 06/27 00:03:19. 0000004870  :   
  I. 06/27 00:03:19. 0000004870 Index Summary:   
  I. 06/27 00:03:19. 0000004870 ** Inconsistent Index Count: 3  ******
  I. 06/27 00:03:19. 0000004870    Verified Index Count: 45 
  I. 06/27 00:03:19. 0000004870 ** Non-Completed Index Count: 3  ******
  I. 06/27 00:03:19. 0000004870  :   
  I. 06/27 00:03:19. 0000004870 Allocation Summary:   
  I. 06/27 00:03:19. 0000004870    Blocks Total: 183500772 
  I. 06/27 00:03:19. 0000004870    Blocks in Use: 92171126 
  I. 06/27 00:03:19. 0000004870 ** Blocks with Multiple Owners: 2  ******


Read more...

Environment

SAP IQ 16.0. SP10 PL07
Solaris 10

Product

SAP IQ 16.0

Keywords

IQ, slib/s_blockmap, s_ROBlockmapCursor, s_buf*s_ROBlockmapCursor::Find, BUFMAN_BLOCKMAP_INFO_ERROR, Internal state violation, slib/s_dpidx , 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.