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

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.

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

SXMSCLUP, SXMSCLUR, 1105, grow fast, archiving, deleting, LOGGING, LOGGING_SYNC , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem