SAP Knowledge Base Article - Preview

2618842 - Long running internal 'sort_local' transaction during cursor processing may cause tempdb log full scenario.

Symptom

  •  ASE logs show error 1105

Error: 1105, Severity: 17, State: 2

Can't allocate space for object 'temp worktable' in database 'tempdb' because 'system' segment is full/has no free extents.


Read more...

Environment

  • SAP Adaptive Server Entreprise (ASE) 15.7
  • SAP Adaptive Server Entreprise (ASE) 16

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

1105,tempdb,cursor,sort,sort_local,791652,CR791652 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

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.