SAP Knowledge Base Article - Preview

2936503 - Error 624 when DBCC LOG runs on an empty empty IMRSLOGS. - SAP ASE 16.0

Symptom

  • When an IMRS enabled database has just been created and sysimrslogs is empty,

  • DBCC LOG hits Error 624 when attempting to dump log records and specifying pageno=<ptnfirst> and rowno=0, for example:

1> dbcc imrslog(tdb1, show, ptnfirst)
2> go
PTNFIRST: 102401
1> dbcc imrslog(tdb1, show, ptnroot)
2> go
PTNROOT: 102401
1> dbcc imrslog(4, show, lastlr)
2> go
LAST IMRSLOG ROW: (0, 0)

1> dbcc log(4,-1, 102401,0,10,-3)
2> go

IMRSLOG SCAN DEFINITION:
Database id : 4
Forward scan: starting at (102401,0)
Maximum of 10 imrslog records.

Msg 624, Level 21, State 1:
Line 1:
Adaptive Server failed to retrieve a row via its RID in database 'mydb' because the requested RID has a higher number than the last RID on the page. Rid pageid = 102401; row num = 0. Page pointer = 0x0x155fc6800, pageno = 102401, status = 0x1, ptnid = 59, indexid = 0, level = 0, pnextrno = 0.

Invalid transaction id: 102401, 0
DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role.

  • The stack trace following Error 624 shows functions:

scan_getrow 
apl__startscan 
startptnscan
xsc__sysimrslogs_setscan
xls_startscan
d_log
d_calllog
exec_dbcc

     Note: A complete stack trace is available under Attachments.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 SP03 PL02
  • In-Memory Row Storage (IMRS)

Product

SAP Adaptive Server Enterprise 16.0

Keywords

CR#809777, CR809777, 809777 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

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.