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.
SAP Knowledge Base Article - Preview