Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Mar 24, 2015 at 12:44 AM

    Hello Karthik,

    You did a wrong thing here :(

    The error says there is problem in the logsegment of saptools instead you increased to your SID.

    Increase the space to saptools logsement you will not get the error.

    Regards

    Kiran K Adharapuram

    Add comment
    10|10000 characters needed characters exceeded