SAP Knowledge Base Article - Preview

1836607 - How to solve error 1105 "Can't allocate space for object..." in saptools database - SAP ASE for Business Suite

Symptom

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

  • From SM21, one of the message (or both) is seen in this format:

Database error 1105 at EXE
> [ASE Error SQL1105][SAP][ASE ODBC Driver][Adaptive Server
> Enterprise]Can't allocate space for object '<object_name>' in
> database 'saptools' because 'default' 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.#
Database error 1105

Database error 1105 at EXE
> [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.#
Database error 1105

  • And from a developper trace file, one of the message in this format is seen:

C  ERROR: -1 in function ExeNormalModify (execute) [line 24417]

C  (1105) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]Can't allocate space for objec
C  t '<object_name>' in database 'saptools' because 'default' segment is full/has no
C  free extents. If you ran out of space in syslogs, dump the transaction log. Othe
C  rwise, use ALTER DATABASE to increase the size of the segment.
 
C  ERROR: -1 in function ExeNormalModify (execute) [line 24417]
C  (1105) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]Can't allocate space for objec
C  t 'syslogs' in database 'saptools' because 'log' segment is full/has no
C  free extents. If you ran out of space in syslogs, dump the transaction log. Othe
C  rwise, use ALTER DATABASE to increase the size of the segment.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 and 16.0 for Business Suite
  • SAP Netweaver (All versions)

Product

SAP Adaptive Server Enterprise 15.7 ; SAP ERP 6.0

Keywords

"SQL Fehler 1105", "SQL1105", "Database error 1105", GA1105, "Guided Answer" , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.