SAP Knowledge Base Article - Preview

2752800 - sp_iqcheckdb on restored SAP IQ database shows object corruption

Symptom


sp_iqcheckdb on a successfully restored SAP IQ database backup can result in "Decompression error during Read" and "Incorrect page header read" errors

main Bufman: Decompression error during Read; from slib/s_buf.cxx:1787
expected: btype=7,blk=224,pbn=18921437,nlb=16,npb=5,uid=2167,txn=43212326,sp=4,mn=868,upmn=868,flgs=0x80008018,iscmp=1
read: btype=7,nlb=16,npb=5,ctr=136,cta=134,pbn=18921437,txn=43212326,sp=4,ver=1,pb=119,pus=224 iscmp=1
Expected Pad1: 119 (0x77), Pad2: 224 (0x00e0)
Got Pad1: 119 (0x77), Pad2: 224 (0x00e0)
age dump for sbuf @ 0x104dbb00
_dskBlk @ 0xffcfd310000
Physical block #: 18921437 (0x120b7dd)
...
main Bufman: Incorrect page header read; from slib/s_trycatch.cxx:2928
expected: btype=17,blk=215,pbn=19069472,nlb=16,npb=1,uid=2196,txn=43212326,sp=4,mn=863,upmn=863,flgs=0x80000018,iscmp=0
read: btype=0,nlb=0,npb=0,ctr=0,cta=0,pbn=0,txn=0,sp=0,ver=0,pb=0,pus=0 iscmp=0
Expected Pad1: 148 (0x94), Pad2: 215 (0x00d7)
Got Pad1: 0 (0x00), Pad2: 0 (0x0000)
There was an s_buf::Read() error during s_bufman::Find().

Same corrupted objects on source database are clean, issue only appears on the restored database side.


Read more...

Environment

  • SAP IQ 16.0 SP 11
  • SUSE 11.4

Product

SAP IQ 16.0

Keywords

 Sybase ; CR817773, CR#817773, 817773 ; corrupt ; dbcc ; FP index ; stacktrace, stktrc, stack trace , 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.