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.

Product

SAP Adaptive Server Enterprise 16.0

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.