- Large tempdb already configured
- Can't allocate space for object 'temp worktable' in database 'tempdb' because 'system' segment is full/has no free extents.
- Query contains several join conditions
- Server is configured with allrows_dss. Testing with allrows_oltp or allrows_mix did not help
- Increasing the 'optimization timeout limit' to as large as 40% did not help
- With 'forceplan on', query executes fast and tempdb does not run out of space
SAP Adaptive Server Enterprise 16.0 SP03 PL0x
1105, temp worktable, forceplan , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
About this pageThis 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.