Skip to Content
0
Former Member
Jun 21, 2015 at 02:50 PM

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

1314 Views

Hi All,

We are getting below error in our Production System frequently.

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.

When ever the above issue is occurring THEN we are adding the space to saptools database and the related file system (/sybase/GTT/sapdiag) & it is running out of space now.

FYI.

We have not enabled the Transaction Log backup as we have space issues. Please advice for the permanent solution.

Regards,

Karthik