Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Can't allocate space for object 'syslogs'

Hi All, We have added the space to log file as below getting warning, is there any issue with the database in the future. 2> go 3> alter database TST log ON TST_log_001='5000m' 4> go Extending database by 320000 pages (5000.0 megabytes) on disk TST_log_001 Processed 125 allocation unit(s) out of 1250 units (allocation page 10837504). 10% completed. ..... 80% completed. Processed 1125 allocation unit(s) out of 1250 units (allocation page 11093504). 90% completed. Processed 1250 allocation unit(s) out of 1250 units (allocation page 11125504). 100% completed. Got the below warning: Warning: Using ALTER DATABASE to extend the log segment will cause user thresholds on the log segment within 128 pages of the last chance threshold to be disabled. I have got actual error in SM21 as follows: > [ASE Error SQL1105][SAP][ASE ODBC Driver][Adaptive Server > Enterprise]Can't allocate space for object 'syslogs' in > database 'saptools' because 'logsegment' segment is full/has > no free extents. If you ran out of space in syslogs, dump th > transaction log. Otherwise, use ALTER DATABASE to increase > the size of the segment. [ASE Error SQL1105][SAP][ASE ODBC > Driver][Adaptive Server Enterprise]Can't allocate space for > object 'syslogs' in database 'saptools' because 'logsegment' > segment is full/has no free extents. If you ran out of space > in syslogs, dump the transaction log. Otherwise, use ALTER > DATABASE to increase the size of the segment. Please suggest, what to do on this. Regards, Karthik

Former Member
replied

Karthik,

No

There is a space crunch in log device and you increased the data device and that too you gave the log device to data

This is wrong, kindly increase the log device of the database with the available log device.

Please update your contact number I will call you if you need

Regards

Kiran K Adharapuram

2 View this answer in context
Not what you were looking for? View more on this topic or Ask a question