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.
SAP Knowledge Base Article - Preview