SAP Knowledge Base Article - Preview

2642040 - A query running with parallel mode returns no result after ASE upgrade - SAP ASE

Symptom

  • A query running with parallel mode returns no result after ASE upgrade to 16.0 SP03. 
  • sp_who results shows that worker processes are in 'sync sleep'.
    17   17 sleeping   sa       (omit)     SELECT          
    17   18 sync sleep sa       (omit)     WORKER PROCESS  
    17   19 sync sleep sa       (omit)     WORKER PROCESS
  • A coordinating thread is sleeping at pipe_read()
    dbcc stacktrace(17) 
    pipe_read
  • Two Worker threads are sleeping at uwrecv()
    dbcc stacktrace(18)
    uwrecv

Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0 SP02 or higher.

Product

SAP Adaptive Server Enterprise 16.0

Keywords

DTA, Dynamic Thread Assignment, merge join , KBA , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.