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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.