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

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 on 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 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, 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, or in the ASE errorlog (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.

ASE is up and running during this time and is largely unaffected by these errors.

  • 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

Warning message during - Netweaver Patch installation:

  • 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
  • SAP Solution Manager 7.x

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", "", SQL1105, 1105, sp_dbextend, logsegment, device, log, full, "not enough free space", "no enough free space", "extend the free space", freespace   , KBA , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , BW-SYS-DB-SYB , BW on Sybase ASE Database Platform , Problem

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.