SAP Knowledge Base Article - Preview

3577364 - Error : 1105 Can't allocate space for object 'temp worktable' in database 'saptempdb' because 'system' segment is full -SAP ASE

Symptom

  • In the ASE error log below error reported even Database saptempdb has been extended.

      Error: 1105, Severity: 17, State: 3
Can't allocate space for object 'temp worktable' in database 'saptempdb' because '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. 

  • There is long ASE running task "update index statistics <SID>.SAPSR3.[GRACACTUSAGE]..." using enormous saptempdb space.
  • In the ATM log

Update statistics of SID.SAPSR3.GRACACTUSAGE failed
    Failed to insert row into worktable, when projecting base table on to work table for collecting statistics.
    Server 'SID', Line 1:
    Msg 1764, Level 18, State 1:
    Server message:
    Can't allocate space for object 'temp worktable' in database 'saptempdb' because '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.

  • The table [GRACACTUSAGE] is huge and manual update statistics not help.


Read more...

Environment

  • SAP Adaptive Server Enterprise  (ASE) 15.7 and 16.0 for Business Suite.

Keywords

saptempdb, Error 1105, Msg 1764, database full, GRACACTUSAGE,'temp worktable'. , 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.