Monday, February 20, 2012

Problem upgrading clustered node to SP1

Hi

We just upgraded a sql 2K Active\Active 2 node cluster to SQL2005. The upgrade seemed to go OK.

We also managed to apply SP1 to Node 1 after an initial problem

But now when applying SP1 to NODE 2 we are getting this error

"A recently applied update, NULL, failed to install"

We had the same problem on NODE 1. Turns out after installing client connection tools and management tools SP1 succeeded. But it does not seem to work on Node2

And yes both nodes have been rebooted.

Any help is appreciated. thanks

Here is the error log

05/18/2006 11:39:57.414 ================================================================================
05/18/2006 11:39:57.414 Hotfix package launched
05/18/2006 11:39:57.430 Successfully opened registry key: SOFTWARE\Microsoft\Windows\CurrentVersion
05/18/2006 11:39:57.445 Successfully read registry key: CommonFilesDir, string value = C:\Program Files\Common Files
05/18/2006 11:39:57.461 Successfully opened registry key: SOFTWARE\Microsoft\Windows\CurrentVersion
05/18/2006 11:39:57.477 Successfully read registry key: ProgramFilesDir, string value = C:\Program Files
05/18/2006 11:39:57.602 Successfully opened registry key: SOFTWARE\Microsoft\Windows\CurrentVersion
05/18/2006 11:39:57.633 Successfully read registry key: CommonFilesDir, string value = C:\Program Files\Common Files
05/18/2006 11:39:57.633 Successfully opened registry key: SOFTWARE\Microsoft\Windows\CurrentVersion
05/18/2006 11:39:57.649 Successfully read registry key: ProgramFilesDir, string value = C:\Program Files
05/18/2006 11:39:57.664 Local Computer:
05/18/2006 11:39:57.664 Target Details: OSSQL12
05/18/2006 11:39:57.680 commonfilesdir = C:\Program Files\Common Files
05/18/2006 11:39:57.695 lcidsupportdir = x:\ae3976232fdba78db1a56fa98a9693\1033
05/18/2006 11:39:57.711 programfilesdir = C:\Program Files
05/18/2006 11:39:57.727 supportdir = \\OSSQL12\x$\ae3976232fdba78db1a56fa98a9693
05/18/2006 11:39:57.727 supportdirlocal = x:\ae3976232fdba78db1a56fa98a9693
05/18/2006 11:39:57.742 windir = C:\WINDOWS
05/18/2006 11:39:57.758 winsysdir = C:\WINDOWS\system32
05/18/2006 11:39:57.774
05/18/2006 11:39:57.789 Enumerating applicable products for this patch
05/18/2006 11:39:59.867 The patch installation could not proceed due to unexpected errors
05/18/2006 11:39:59.883
05/18/2006 11:39:59.883 Product Status Summary:
05/18/2006 11:40:00.024 Hotfix package closed

You can failover SQL resources to the second node and then try SP1 on that node. This is a peculiar problem and I doubt you can reproduce the problem.

No comments:

Post a Comment