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 for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.