Share via

Side Effect with SharePoint AugustCU 2009 - Problem with Attach Contentdb

  • Article

[update: 02.10.2009] the product group release a new version of AugustCU with build level 12.0000.6514.5004 

Hello @all,

today we could investigate an important issue with upgrade to AugustCU. (this happens only with AugustCU build level: 12.0000.6514.5002)

Normally it's every time a good idea to detach the contentdb's before installing the patches/service packs. Reattach them after the update of the Farm was successful.

  1. detach contentdb
  2. install wss / moss patches
  3. run psconfig / configuration wizard
  4. reattach contentdb back to sharepoint

On upgrading to AugustCU you can see something like this on point 4.

stsadm -o addcontentdb

Callstack from ULS logs:

General                        72ju High     stsadm: Index was outside the bounds of the array. Callstack:    at System.Data.SqlClient.SqlDataReader.ReadColumnHeader(Int32 i)      at System.Data.SqlClient.SqlDataReader.IsDBNull(Int32 i)     at Microsoft.SharePoint.Administration.SPContentDatabase.GetDatabaseInformation(String name)     at Microsoft.SharePoint.Administration.SPContentDatabase.get_DatabaseId()     at Microsoft.SharePoint.Administration.SPContentDatabaseCollection.UseDatabaseId(SPFarm farm, SPContentDatabase db)     at Microsoft.SharePoint.Administration.SPContentDatabaseCollection.Add(Guid newDatabaseId, String strDatabaseServer, String strDatabaseName, String strDatabaseUsername, String strDatabasePassword, Int32 warningSiteCount, Int32 maximumSiteCount, Int32 status, Boolean provision, Boolean allowUpgrade, Boolean fl...

To avoid this problem it requires an other migration path:

    1. detach contentdb
    2. install wss / moss patches
    3. run psconfig / configuration wizard
    4. reattach contentdb back to sharepoint

If it's not possible to do this on production then you can also upgrade the contentdb over a TEST-Farm to upgrade the content database schema to augustCU. Then it looks like:

    1. detach contentdb
    2. install wss / moss patches on production farm
    3. run psconfig / configuration wizard on production farm
    4. attach contentdb to TEST-FARM
    5. upgrade TEST-FARM
      1. install WSS / MOSS augustCU
      2. run psconfig
    6. if upgrade of TEST-FARM runs successful then
      1. detach contentdb from TEST-FARM
      2. attach contentdb to product-FARM

kind regards

Patrick