SAP Knowledge Base Article - Preview

3322249 - SYB: PI tables SXMSCLUP or SXMSCLUR is very huge and grows fast which causes frequent error 1105 for the <SID> database - SAP ASE for BS

Symptom

1.  You can see frequent error 1105 for <SID> database as below,

Error: 1105, Severity: 17, State: 4
Can't allocate space for object '<object_name>' in database '<SID>' 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.

2. From DBACOCKPIT -> Space -> Tables and Indexes -> Tables, you can see the most largest tables in the <SID> database are SXMSCLUP or SXMSCLUR or both, and they grow fast, maybe >10G per day.



Read more...

Environment

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

    Product

    SAP Adaptive Server Enterprise all versions ; SAP NetWeaver all versions

    Keywords

    SXMSCLUP, SXMSCLUR, 1105, grow fast, archiving, deleting, LOGGING, LOGGING_SYNC , KBA , BC-DB-SYB , Business Suite 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.