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

• 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

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

DTA, Dynamic Thread Assignment, merge join , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem