SAP Knowledge Base Article - Preview

3203948 - Running update index statistics raising Error 2628 - SAP ASE

Symptom

  • Database maintenance job running update index statistics across many tables with DOL locking scheme;
  • Table has many rows (900 million row count), table also has several non-clustered indexes and an unique clustered index, getting error/stacktrace:

Error: 2628, Severity: 21, State: 2
In database 'servername', page 45021021 is linked forward to page 45021048, but that page is linked backward to page 53088753. Please report this internal error to SAP Technical Support.

SQL causing error : update INDEX statistics <tablename>

curdb = 8 tempdb = 2 pstat = 0x10000 p2stat = 0x101000
lasterror = 2628 preverror = 0 transtate = 1

kernel  pc: 0x0000000001c8287b bt__getnextscanpg+0x165b()
kernel  pc: 0x0000000001c80032 bt__handle_pagedone+0x122()
kernel  pc: 0x0000000001c7c846 bt_getnext+0xca6()
kernel  pc: 0x0000000001c5a212 dol_bt_getnext+0x2f2()
kernel  pc: 0x0000000001bce453 getnext+0x653()
kernel  pc: 0x00000000021c8486 ups_deadlock_getnext+0x36()
kernel  pc: 0x00000000021c806b ups_build_gather_stats+0x36b()
kernel  pc: 0x00000000021c1508 ups_build+0x498()
kernel  pc: 0x00000000021bd419 ups__updstats+0x4f9()
kernel  pc: 0x00000000021be2a7 ups__updstats_driver+0x2b7()
kernel  pc: 0x00000000021bc7a1 update_statistics+0x631()
kernel  pc: 0x00000000021bb261 ups_main+0x571()


Read more...

Environment

SAP Adaptive Server Enterprise 16.0

Product

SAP Adaptive Server Enterprise 16.0

Keywords

Error 2628, update index statistics, buffer, DOL, data only, locking scheme, locking , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Known Error

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.