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.