I'm having trouble with a particular Windows update - KB2463332. It's an SQL Service Pack 4 update, if that makes any difference. Anyway, the update says that it has successfully installed, but the next time that WSUS is run, it appears as a Windows update that needs to be installed. This has been going on for 3 months now. I've rebooted several times, even doing a "clean" reboot without any non-Windows services or startup programs running, thinking that they might be conflicting with this update.

 

Below is a snippet from the CBS log, which gives a small indication of what might be wrong. Unfortunately, anything that I've found on this subject will not work on Server 2008 - only Windows 7 or Vista. And most other solutions are meant for the Internet based Windows updates, and not WSUS. If anyone has any knowledge on how to fix this, I would really appreciate it. Thanks in advance.

 

Jeff

 

2011-10-04 09:19:55, Info CBS Session: 30179992_1317406979 initialized by client WindowsUpdateAgent.

2011-10-04 09:19:55, Info CBS Failed to internally open package. [hrESULT = 0x800f0805 - CBS_E_INVALID_PACKAGE]

2011-10-04 09:19:55, Info CBS Session: 30179992_1317406980 initialized by client WindowsUpdateAgent.

Try to remove this server from WSUS, redo your update via Windows Update and this should solve your problem... I think...

That sounds way too easy! But I'll give that a try. Thank you!

OK, I removed it from WSUS by "deleting" the server in the list of computers, rebooted, ran the update in question, and rebooted again. I figured that if the update required a reboot to install, I would give it every chance possible to install. Unfortunately, none of it worked and the update still shows as being needed. I guess I have some questions here...

 

Looking in Control Panel - Windows Updates - View Update History, it says that this update has installed sucessfully. Several times, in fact. Is this really the case, or is this just a file that remains in some "windows update install cache" that I can delete? Or is it really expecting me to download and install it? It doesn't seem to be downloading, because a 55 MB file would take longer to download before trying to install.

 

The CBS log says gives the exact same message as above, that the package is invalid and can't be opened, or some such thing. This leads me to believe that I should removed this update from the aforementioned "windows update install cache" (wherever that is) and delete that file. Then go out and request windows updates again and see if that file downloads. I would think that would cure a corrupt file download, which it seems is the case. Is that a fair assessment, and how would I go about doing that? Thanks in advance.

To delete the cache erase this folder:

 

%Windir%\SoftwareDistribution\Download

 

Is there a packet filtering system on your network? It may modify the package...

I deleted the download folder, and also the DataStore folder after I shut off the Windows Update Service. I then restarted the Windows update service, checked for updates, and found the errant update, downloaded and installed it. The update history says that it installed successfully, but I am going to reboot the server at lunch time and then check for Windows updates again. Hopefully, I won't see this particular update ever again. I will reply to this post with the status after rebooting and checking for updates. Thank you.

OK, just to update here, my Windows - System - Event Viewer says that this update is scheduled to install at 4:00 AM tomorrow morning. You mentioned earlier to change the option to just have it download the updates and let me choose when to apply them. Unfortunately, the option(s) to change this are grayed out and I am not able to change them. I will just wait until 4:00 AM tomorrow and hopefully it will update automatically at that time.

Mhhh I'm not really sure it will work... I can't see why it should install the update tomorrow instead of when you rebooted your server :/

 

Anyway let's cross our fingers...

 

Regarding the time that cannot be changed, this can happens, and there's a (good?) reason... but actually I can't remember why eheh.

 

Waiting for your update!

It turns out that WSUS had changed a GPO, so I edited the GPO to update at 5:00 PM everyday so hopefully I will be able to reboot tonight. Thanks again.

Sadly, I'm still getting the same message after clearing the aforementioned Windows update folders of any updates, and also doing multiple reboots. I have NOT however, tried the "clean reboot" where I disable all non-Microsoft services like anti-virus, Acronis backup services and the like. I do run a SonicWall router with packet filtering, intrusion prevention service and gateway anti-virus. I have not seen any errors in the logs there, but perhaps it is still modifying the package somehow.

 

From the CBS log:

2011-10-13 09:19:55, Info CBS Failed to internally open package. [hrESULT = 0x800f0805 - CBS_E_INVALID_PACKAGE]

I'm quite sure your packet filter is modifying something. I had an issue where my PF allowed an update from microsoft if it was in english / italian / french but not if in german.

 

So, tell me if you are running SQL 2005 EXPRESS or not. I can download it, compress, add a password and upload somewhere. So you can download it without the filter (most of PF system allows password protected archives if not configured in others ways).

 

Let me know.

OK, here is what I've tried after our last communication... I turned off gateway anti-virus and also intrusion prevention service on my SonincWall router. Then I stopped the Windows Update service and deleted the software distribution\Datastore and download folders. Then via MSConfig, I changed the config so that only Microsoft Services would load and rebooted the server and checked for Windows updates. I chose the download and install now option (that's the only option it gives me. Installing later is grayed out) installed it and the rebooted with only MS services (no backup and/or anti-virus services started) and checked windows updates again. It again said that I needed to download and install the SQL service pack 4 update. I tried again with the aforementioned Windows and router settings disabled. Still no luck.

 

I checked the router settings, but maybe I'm not understanding what "packet filtering" is on this router, and not properly disabling what I need to disable to get it to work as the CBS log still gives me the same "invalid package" message as before. Any help is appreciated. Thank you.

By the way, yes, it is MS SQL 2005 EXPRESS, and not the full version. I tried downloading the full executable of SQL 2005 Express, but that seemed to have issues also, and crashed during installation. But that is not surprising, since I'm very weak in my knowledge of SQL implementation and use. Thanks again.

I'm downloading files, when ready, I will give you the links.

Thank you. I will await posting of the link.

Sooo here you are:

 

https://skydrive.live.com/redir.aspx?cid=118be0990f970226&resid=118BE0990F970226!702

 

I splitted all the files because skydrive has a limit of 100 mb, also there's a 32 and 64 bits version.

 

Password for archives:

server2008forum

Thank you so much for uploading these! I am in the process of downloading them now and will see if I can try the installation tomorrow.

OK, I've tried this several times now, and whatever file I choose, the error log file says it's the wrong operating system. I don't know if this should be in the Server 2008 forum, or if there's an SQL forum that this would be better suited for. I've turned off the anti-virus services and tried it, turned off the SQL and tried it (I think this needs to be on), and I've tried a clean boot and tried it. I'm out of ideas, and any help would be appreciated. Thank you.

The only thing you can do is to open a topic on the official forum of SQL from Microsoft: http://social.msdn.microsoft.com/Forums/en/category/sqlserver