SAP Knowledge Base Article - Preview

1931223 - Error SQL1105 "Can't allocate space for object..." - SAP ASE for Business Suite and SAP BW

Symptom

  • This KBA describes the various scenarios where you may encounter SQL1105 errors returned from SAP systems running on SAP ASE database. As well as describes how to avoid and resolve SQL1105 errors on SAP systems. Hence, please read the KBA carefully to see what will help to clear the SQL1105 in your specific scenario.

  • SQL1105 errors may arise during runtime (includes installation time) or during database recovery (ASE server start-up/boot)
    • For runtime failures, ASE is up and running, you see that work processes disconnect with a short dump with one of the following error messages which also appear in SM21 system log, in a work process developer trace (in the ASE errorlog it will be reported as "Msg 1105"):

[ASE Error SQL1105] Can't allocate space for object '<objectname>' in database '<dbname>' because 'default/system' 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.

[ASE Error SQL1105] Can't allocate space for object 'syslogs' in database '<dbname>' 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.

    • For recovery failures, you see that one or more of the ASE databases do not come online (and/or subsequently marked suspect) due to the Error 1105. Please refer to SAP Note 1810223 - "SYB: Recovery of a database fails with error 3475".

    • Warning message during Netweaver Patch installation/upgrades:

There is not enough free space in the database. The expected amount of space is #### MB but only #### MB are available. Note that you may encounter problems if you discontinue this process. We recommend that you extend the free space to meet the requirement.


Read more...

Environment

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

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver all versions

Keywords

DBSQL_SQL_ERROR, "Transaction log full", "dump transaction", disk, SQL1105, 1105, sp_dbextend, logsegment, device, log, full, "not enough free space", "no enough free space", "extend the free space", freespace, Msg 1105, extend, GA1105, "Guided Answer" , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , Problem

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.