1961388 - Signal 11 stack trace containing xact_beginupdate followed by error 4720 and error 4701 - ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

1961388 - Signal 11 stack trace containing xact_beginupdate followed by error 4720 and error 4701 - ASE

Symptom

  • The ASE errorlog reports a stack trace following a signal 11 (Unix) or SQL Server system exception message (Windows) with the stack containing modules:
xact_beginupdate()
trunctaberr()
trunctab__phys()
trunctab()
droperr()
dropo()
drop_with_retry()
tmp_alldrop()
  • Error 4720 and 4701 reported:

Error: 4720, Severity: 16, State: 1
Cannot truncate table '%' because there are one or more isolation level 0 scans, or REORG command, active on the table.

Error: 4701, Severity: 11, State: 1
Cannot truncate table '%', because this table does not exist in database 'tempdb'.

  • As a result, a phantom spid with an open transaction may be left behind preventing the transaction log from truncating and resulting in error 1105

Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7

Product

SAP Adaptive Server Enterprise 15.7

Keywords

stacktrace
xact_beginupdate+0x5d3()
trunctaberr
trunctab__phys+0x73c()
trunctab+0x12f5()
dropo+0x162d()
drop_with_retry+0x1be()
tmp_alldrop+0x3da() , 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.