Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » Cumulative Update #7 fails
Add to briefcase

Cumulative Update #7 fails Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
Mike Hinds
Posted Tuesday, July 03, 2012 7:37 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 8:35 AM
Points: 527, Visits: 770
I've downloaded CU7 for SQL 2008R2 SP1, KB 2703282, and attempted to install it on test instances.

Only one was successful, out of seven or eight. All are SQL 2008R2, SP1, and are 64-bit Intel. All are virtual machines (VMs). Several were two-node failover clusters, and the rest are single-node instances.

The install wizard completes with Status "Failed" and a red "X" in the Update Progress pane.

The Summary...txt tells me to "review the log files", and provides the path to the detail log.

The fatal error appears to be the following:
---
2012-07-03 09:00:26 Slp: Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException: File c:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn\DllTmp64\sqlagentctr100.dll could not be copied to file path C:\Windows\system32\perf-MSSQL10_50.MSSQLSERVER-sqlagtctr.dll. ---> Microsoft.SqlServer.Configuration.ScoExtension.CopyFileException: File c:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn\DllTmp64\sqlagentctr100.dll could not be copied to file path C:\Windows\system32\perf-MSSQL10_50.MSSQLSERVER-sqlagtctr.dll. ---> Microsoft.SqlServer.Configuration.Sco.ScoException: The process cannot access the file 'C:\Windows\system32\perf-MSSQL10_50.MSSQLSERVER-sqlagtctr.dll' because it is being used by another process. ---> System.IO.IOException: The process cannot access the file 'C:\Windows\system32\perf-MSSQL10_50.MSSQLSERVER-sqlagtctr.dll' because it is being used by another process.
---

After the "failure", when SQL is restarted (or failed back in the case of a cluster), SELECT@@VERSION and Object Explorer show the new patch level - 10.50.2817.

Has anyone else had this experience? Does anyone know of or could suggest a workaround?

Regards, Mike
Post #1324394
Steve Jones - SSC Editor
Posted Tuesday, July 03, 2012 10:37 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 3:26 PM
Points: 31,425, Visits: 13,738
I found this: http://shaunjstuart.com/archive/2010/06/failure-when-upgrading-cluster-to-sql-2008-sp1-cu7/

Similar issue?






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1324500
Mike Hinds
Posted Tuesday, July 03, 2012 10:42 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 8:35 AM
Points: 527, Visits: 770
Steve Jones - SSC Editor (7/3/2012)
I found this: http://shaunjstuart.com/archive/2010/06/failure-when-upgrading-cluster-to-sql-2008-sp1-cu7/

Similar issue?


Interesting one, but his explanation is specific to clusters. Mine has come up with the same error on clusters and single-node instances alike.

Regards, Mike
Post #1324508
Robert klimes
Posted Tuesday, September 11, 2012 1:16 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 3:24 PM
Points: 890, Visits: 1,855
if you haven't found an answer yet may this will work.(http://blogs.msdn.com/b/karthick_pk/archive/2012/07/16/the-process-cannot-access-the-file-c-windows-system32-perf-mssql10-50-mssqlserver-sqlagtctr-dll-because-it-is-being-used-by-another-process.aspx)

I have had the same issues with CU2 for SQL Server 2008 R2 SP2. Haven't test the fix yet but will port when I do.

--edit
renaming the file specified in the details.txt file then running the CU installer again worked. CU installation completed successfully.

Bob
-----------------------------------------------------------------------------
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1357653
Mike Hinds
Posted Tuesday, September 11, 2012 1:38 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 8:35 AM
Points: 527, Visits: 770
Robert klimes (9/11/2012)
if you haven't found an answer yet may this will work.(http://blogs.msdn.com/b/karthick_pk/archive/2012/07/16/the-process-cannot-access-the-file-c-windows-system32-perf-mssql10-50-mssqlserver-sqlagtctr-dll-because-it-is-being-used-by-another-process.aspx)

I have had the same issues with CU2 for SQL Server 2008 R2 SP2. Haven't test the fix yet but will port when I do.

--edit
renaming the file specified in the details.txt file then running the CU installer again worked. CU installation completed successfully.


Interesting. I hope this is the fix we need. I'll definitely try it out.
Also, thanks for informing about SP2 CU2 (KB2740411, 08/31/2012), which I looked for but could not find when I started patching last week.

Regards, Mike
Post #1357669
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.