Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Cumulative Update #7 fails Expand / Collapse
Author
Message
Posted Tuesday, July 3, 2012 7:37 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Today @ 6:13 AM
Points: 757, Visits: 1,034
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?


Mike Hinds
Senior Database Administrator
1st Source Bank
MCP, MCTS
Post #1324394
Posted Tuesday, July 3, 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 @ 9:20 PM
Points: 33,951, Visits: 18,063
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
Posted Tuesday, July 3, 2012 10:42 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Today @ 6:13 AM
Points: 757, Visits: 1,034
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.


Mike Hinds
Senior Database Administrator
1st Source Bank
MCP, MCTS
Post #1324508
Posted Tuesday, September 11, 2012 1:16 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, July 19, 2016 11:40 AM
Points: 1,836, Visits: 3,381
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
-----------------------------------------------------------------------------
How to post to get the best help
Post #1357653
Posted Tuesday, September 11, 2012 1:38 PM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Today @ 6:13 AM
Points: 757, Visits: 1,034
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.


Mike Hinds
Senior Database Administrator
1st Source Bank
MCP, MCTS
Post #1357669
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse