Blog Pages

SAP ASE (Sybase) - The transaction log in database sales is almost full. Your transaction is being suspended until space is made available in the log.

Error message:
The transaction log in database sales is almost full.  Your transaction is being suspended until space is made available in the log.

Will be repuduced whan trying to work with a table in the database.

Cause: 
Log space is full.
Check it using:

sp_helpdb <DBNAME>
sp_helpdevice <DEVICENAME>

Solution:
use master
go
disk resize name = "<DEVICENAME>", size = "500M"
go
alter database sales log on <DEVICENAME> = "500M"
go

No comments:

Post a Comment