Error SQL1105 "Can't allocate space for object..." - SAP ASE

One of following errors can be observed:

Error 1105 Can't allocate space for object '<object_name>' in database 'saptools' because 'default' segment is full/has no free extents

Error 1105 Can't allocate space for object 'syslogs' in database 'saptools' because 'logsegment' is full/has no free extents

Error SQL1105 "Can't allocate space for object..." "

Identify the device which having the size issue by following options.

Option 1 :- DB13 ---> Database ---> Space ---> Devices

Option 2 :- sp_helpdb

Once the device has identified then based on the space availability on you server you can size the device or create new device.

If the error message is reported on "default segment", then add the new space on device <data_device_name>

Resize Device

use master
go
disk resize name=<existing_data_device_name>, size = '<size in GB>M' 
go
alter database <dbname> on <existing_data_device_name> = '<size in GB>M' 
go

If the error message is reported on "log segment" then add the new space

use master
go  
disk resize name = "<log_device_name>", size = "<size>M"
go  
alter database <dbname> log on <log_device_name> = "<size>M"
go

Share this

Basis Genie