Unable to run SharePoint configuration wizard - Error”Unable to upgrade SharePoint Products and Technologies because an upgrade is already in progress."

This article is about an error generated when running configuration wizard in WSS 3.0 / MOSS 2007. The scenario is like this. The SharePoint environment was running with WSS 2.0 and tried to upgrade to WSS 3.0. The WSS 2.0 was installed with a default instance of SharePoint Database (Express /Embedded edition of SQL) and while upgrading the SQL instance got corrupted. But the SharePoint was still considering the timer service in progress . But looking at the Timer job status in Central administration the upgrade timer job was not progressing and it got stuck at a point.

As we need to create a new Config DB , we have tried detaching the server from farm. It was giving this error message

image

The reason behind this was the timer job was in stuck state and unable to progress that in intern made any changes to config DB not successful.

The steps that can be taken forward to correct the issue is :-

1. Stop the Windows SharePoint Services Timer service.
2. On the SharePoint Server where Central Administration Site is hosted browse to C:\Documents and Settings\All Users\Application Data\Microsoft\SharePoint\Config\<guid>
3. Move all the xml files to another location.
4. Also backup the cache.ini file. Then Edit the cache.ini and replace the current value with "1".
5. Restart the Windows SharePoint Services Timer service. New xml files will start appearing in the guid folder.
6. Verify the cache.ini now contains its previous value (or verify that the value is no longer "1"; any non-1 value is fine).
7. Run the command from the sharepoint server "stsadm -o setproperty -pn command-line-upgrade-running -pv no" (without quotes)
8. Run the command from the sharepoint server "stsadm -o execadmsvcjobs" (without quotes)
9. Run the command from the sharepoint server "psconfig -cmd upgrade -inplace b2b -wait -force" (without Quotes)
10.Run configuration wizard and disjoin from farm

Comments

  • Anonymous
    January 01, 2003
    @Ramesh  try   C:ProgramDataMicrosoftSharePointConfig

  • Anonymous
    December 23, 2010
    This is very helpful! Step 10 is not applicable for every one, it need to be performed only when you want to disjoint from farm. Rest of steps 1 thru 9 are very helpful! Thank you for putting up this info.

  • Anonymous
    May 17, 2011
    This is really a good content It solved my problem of configuration wizard. Thanks Manu for this blog post

  • Anonymous
    September 22, 2011
    Hi, Where I can find  C:Documents and SettingsAll UsersApplication DataMicrosoftSharePointConfig<guid> files in Windows  2008 R2 Server. Thanks Ramesh

  • Anonymous
    February 07, 2012
    FYI for reference, on SP 2007, getting this msg on SP3 install, step 9 was all it took to clear the message.

  • Anonymous
    March 07, 2012
    @Ramesh  try   C:ProgramDataMicrosoftSharePointConfig