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 you can see one of the message (or both) 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 you can see one of the message in this format:

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

Product

SAP Adaptive Server Enterprise 15.7 ; SAP ERP 6.0

Keywords

"SQL Fehler 1105", "SQL1105", "Database error 1105" , KBA , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , How To

About this page

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

Search for additional results

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