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 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
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.