SAP Knowledge Base Article - Preview

3294719 - saptempdb full Error 1105 - SAP ASE for BS

Symptom

  • Database saptempdb has been extended from 25GB to 50GB but still reported error 1105:
    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.[/SAPAPO/TS_LOCKC]..." using enormous saptempdb space. i.e 2539844 pages, 38.75GB.
  • The table [/SAPAPO/TS_LOCKC] is huge containing 544023146 rows with size of 68GB:

name             rowtotal  reserved    data        index_size  unused  
---------------- --------- ----------- ----------- ----------- ------- 
/SAPAPO/TS_LOCKC 544023146 68750112 KB 25019168 KB 43728272 KB 2176 KB 


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP Netweaver 7.5
  • SAP Supply Chain Management 7.0

Product

SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver 7.5 ; SAP Supply Chain Management all versions ; SAP enhancement package 1 for SAP NetWeaver 7.0

Keywords

saptempdb, SAPTEMPDB, Error 1105, 1105, database full, /SAPAPO/TS_LOCKC, SCM , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , SCM-APO-FCS-MAP , Mass Processing , 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.