Symptom
- "slib/s_blockmap.cxx:11424" and "slib/s_ohcidx.cxx:7424" error happened as below as soon as the DELETE statement got started.
No stacktrace for this error generated in the IQ message log.
=,<,15669,PREPARE,delete from "OWNER001"."TAB001" where("COL001" < "DATEFORMAT"("DAYS"("DATE"('2000101),-2),'YYYYMMDD') or "LOAD_DT" = '20001231')
+202,E,15669,-1006000,IQ Internal error. Please report this to SAP IQ support. -- (slib/s_blockmap.cxx 7006)
I. 11/30 16:48:23. 0000064027 [20917]: Delete of 1401759 rows started for table:
I. 11/30 16:48:24. 0000064027 main Bufman: Blockmap info error; bmp={bl=1849853998566942,uid=70522307,txn=40090637,sp=1737,nentr=1692,rb=54519858,nlnk=2,flags=0xd,...........
I. 11/30 16:48:24. 0000064027 =13,rmod=13}. slib/s_blockmap.cxx:11424
I. 11/30 16:48:24. 0000064027 The following exception is from GetBlockmapEntryInfo
I. 11/30 16:48:24. 0000064027 Blockmap Member Variables for 0x7fb5210dd718
I. 11/30 16:48:24. 0000064027 From slib/s_ohcidx.cxx:7424
I. 11/30 16:48:24. 0000064027 _nextPartitionForHelperFlush = 0
...................
...................
I. 11/30 16:48:24. 0000064027 GetBlockmapEntryInfo() Inputs & Outputs:
I. 11/30 16:48:24. 0000064027 logicalBlockId: 0
I. 11/30 16:48:24. 0000064027 link: 1849853998566942
I. 11/30 16:48:24. 0000064027 serverID: 0
I. 11/30 16:48:24. 0000064027 Exception Thrown from slib/s_blockmap.cxx:7006, Err# 0, tid 1010 origtid 1010
I. 11/30 16:48:24. 0000064027 O/S Err#: 0, ErrID: 2092 (s_invalidinputexception); SQLCode: -1006000, SQLState: 'QBA00', Severity: 23
- This error happened at IQ 16.0 SP11 PL06, but the same error occurred again after upgrading the IQ database to SP11 PL12.
- DBCC (with check and verify options) did not report any error.
I. 11/30 16:48:09. 0000064027 DBCC Verify Mode Report:
I. 11/30 16:48:09. 0000064027 DBCC Status: No Errors Detected
4. There exists ONE unique HG index.
Read more...
Environment
SAP IQ 16.0 SP11
Product
Keywords
SAP IQ, IQ, slib/s_blockmap.cxx:11424, slib/s_ohcidx.cxx:7424, s_blockmap, s_ohcidx, main Bufman, Blockmap info error, GetBlockmapEntryInfo, CR812208, CR#812208, CR 812208, CR820361, CR#820361, CR 820361, , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed
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.