2409396 - Error 1514: Sort failed because it attempted to allocate page xxx and found that the page was busy. - SAP ASE

• Received Error 1514:

Error: 1514, Severity: 21, State: 2
Sort failed because it attempted to allocate page 11728 and found that the page was busy. Buffer BUF=0xc000000f6f503068, MASS=0xc000000f6f503068, Buf#=0, page=0xc000000f56d0a800, dbid=2, Mass vdevno=11, vpage=9680, Buf lpage=11728, Mass stat=0x1008, Buf stat=0x1, size=2048, cid=4 ('tempdb_cache'), Pinned xdes=0x0000000000000000, spid=0 contains a cached and referenced page with ptnid 24 indid 2 and status 0x802.

• It was followed by Error 2628 and multipe Errors 839, for example:

Error: 2628, Severity: 21, State: 3
In database 'tempdb', page 221456 is linked forward to page 239769, but that page is linked backward to page 11644. Please report this internal error to Sybase Technical Support.
Error: 839, Severity: 21, State: 1
Grabbed buffer dirty but not writing: BUF=0xc000000f6b9846c8, MASS=0xc000000f6b9846c8, Buf#=0, page=0xc000000f38328800, dbid=0, Mass vdevno=11, vpage=219408, Buf lpage=221456, Mass stat=0x4010010, Buf stat=0x0, size=2048, cid=4 ('tempdb_cache'), Pinned xdes=0x0000000000000000, spid=0.

• SAP Adaptive Server Enterprise (ASE) 15.5
• SAP Adaptive Server Enterprise (ASE) 15.7

CR740730, CR#740730, 740730, StoreIndex, reformatting, subquery , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed