SAP Knowledge Base Article - Preview

2636610 - Recieving errors Msg 277, Level 16, State 1:

Symptom

use master
go
sp_dboption tempdb, "ddl in tran", "true"
go
use tempdb
go
checkpoint
go
if object_id("proc1") <> 0
        drop proc proc1
go
create proc proc1 as
begin
        create table #tab1 (col1 int)
        drop table #tab1
end
go
begin tran
exec proc1
commit tran
go

 

Msg 277, Level 16, State 1:
Server 'myserver', Procedure 'proc1', Line 4:
There was a transaction active when exiting the stored procedure 'proc1'. The temporary table '#tab1' was dropped in this transaction either explicitly or implicitly. This transaction has been aborted to prevent database corruption.
Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRAN is missing. Previous count = 1, Current count = 0.


Read more...

Environment

SAP Adaptive Server Enterprise (all versions)

Product

SAP Adaptive Server Enterprise 15.7

Keywords

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-REP , Sybase Replication Server (standalone) , Problem

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.