Symptom
On SAP ASE systems with ASE parallelism configured:
- tempdb database runs out of log space (Error 1105) during ASE parallel query execution
- The parallel queries involve Hash Join operations
- These spids hang and cannot be terminated via ASE KILL command in isql.
- The stacktrace for these spids references the following functions:
uwpredisconnect
err_disconnect_allchildren
err_pll_primary_processing
On systems running SAP BW applications and SAP Solution Manager systems:
- the report SAP_BWTOOLPGM_SYB (executed via t-code SE38) shows several Infocubes with more than 1000 partitions
- Multiple occurrences of Error 540 are seen in the ASE errorlog (see SAP KBA 2833526)
- stacktraces are reported in the ASE errorlog referencing LeHash functions (see SAP KBA 3126590)
- serveral ASE processes (spids) are hung and cannot be terminated via ASE KILL command in isql.
- The stacktrace for these spids references the following functions:
uwpredisconnect
err_disconnect_allchildren
err_pll_primary_processing
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
- SAP NetWeaver (NW) - All versions
- SAP Solution Manager (SOLMAN) 7.2
- SAP Adaptive Server Enterprise (ASE) 16.0
Product
SAP NetWeaver 7.5
Keywords
tempdb, 1105, parallelism, 'parallel query', kill, 823671, CR 823671, CR823671,err_pll_secondary_processing , KBA , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.