Error running SQL and EXEC commands in parallel

on Tuesday 5 June 2012

Error running SQL and EXEC commands in parallel 

This issue has occurred when we do applying the patches on the Application Tier.
The cause of this is auto patch previous sessions are still exists in the server and failing the ad workers with the following error.
 Error

11 workers have quit.  Waiting for 9 more.

12 workers have quit.  Waiting for 8 more.

 All workers have quit.

 Completed: file apgtxlat.sql on worker  1 for product ap  username AP.

 Time is: Sat May 26 2012 21:31:09

 Error running SQL and EXEC commands in parallel

 You should check the file

/applprod2/uat3/appluat3/admin/DEV/log/u7023348.drv2.log  for errors.

Solution:

Kill the ad patch sessions and try to apply the patch again.

1.Mydb>ps -eaf | grep adpatch
           OR
  Mydb>ps -efa | grep adworker

2.Mydb>kill -9 <pid>


0 comments:

Post a Comment