Solved

WSS 3.0 Restore Error

Posted on 2011-03-14
6
716 Views
Last Modified: 2012-05-11
I attempted a web application and content database restore by using the Central Administration web site because I was getting this error when accessing a List that I want to delete:

Exception occurred. (Exception from HRESULT: 0x80020009 (DISP_E_EXCEPTION))  

The restore failed with this error messasge:

Object WSS_Content failed in event OnPostRestore. For more information, see the error log located in the backup directory

Below are the error messages from the log file.  Can someone tell me how to fix the error so that I can do a complete restore?

[SPManager] [ERROR] [3/14/2011 10:49:36 AM]: NeedsUpgrade [Basic Meeting Workspace - %LCID%1033 - %GTID%_GLOBAL_#2 - %TMPLID%MPS#0
     A site to plan, organize, and capture the results of a meeting. It provides lists for managing the agenda, meeting attendees, and documents.

] failed.
[SPManager] [ERROR] [3/14/2011 10:49:36 AM]: Data is Null. This method or property cannot be called on Null values.
[SPManager] [ERROR] [3/14/2011 10:49:36 AM]:    at System.Data.SqlClient.SqlBuffer.get_Int32()
   at System.Data.SqlClient.SqlDataReader.GetInt32(Int32 i)
   at Microsoft.SharePoint.Upgrade.SPWebTemplateSequence.get_WebTemplateVersion()
   at Microsoft.SharePoint.Upgrade.SPWebTemplateSequence.get_NeedsUpgrade()
   at Microsoft.SharePoint.Upgrade.SPManager.NeedsUpgrade(Object o, Boolean bRecurse)
[SPManager] [ERROR] [3/14/2011 10:49:36 AM]: ReflexiveUpgrade [Basic Meeting Workspace - %LCID%1033 - %GTID%_GLOBAL_#2 - %TMPLID%MPS#0
     A site to plan, organize, and capture the results of a meeting. It provides lists for managing the agenda, meeting attendees, and documents.

] failed.
[SPManager] [ERROR] [3/14/2011 10:49:36 AM]: Data is Null. This method or property cannot be called on Null values.
[SPManager] [ERROR] [3/14/2011 10:49:36 AM]:    at System.Data.SqlClient.SqlBuffer.get_Int32()
   at System.Data.SqlClient.SqlDataReader.GetInt32(Int32 i)
   at Microsoft.SharePoint.Upgrade.SPWebTemplateSequence.get_WebTemplateVersion()
   at Microsoft.SharePoint.Upgrade.SPWebTemplateSequence.get_NeedsUpgrade()
   at Microsoft.SharePoint.Upgrade.SPManager.NeedsUpgrade(Object o, Boolean bRecurse)
   at Microsoft.SharePoint.Upgrade.SPManager.ReflexiveNeedsUpgrade(Object o, Boolean bRecurse)
   at Microsoft.SharePoint.Upgrade.SPManager.Upgrade(Object o, Boolean bRecurse)
   at Microsoft.SharePoint.Upgrade.SPManager.ReflexiveUpgrade(Object o, Boolean bRecurse)
[SPManager] [INFO] [3/14/2011 10:49:36 AM]: Resetting the status of PersistedUpgradableObject: SPContentDatabase Name=WSS_Content Parent=SPDatabaseServiceInstance Name=Microsoft##SSEE to Online.
[SPManager] [DEBUG] [3/14/2011 10:49:36 AM]: Using cached [SPContentDatabase Name=WSS_Content Parent=SPDatabaseServiceInstance Name=Microsoft##SSEE] NeedsUpgrade value: False.
[SPManager] [INFO] [3/14/2011 10:49:37 AM]: Inplace Upgrade session finishes. root object = SPContentDatabase Name=WSS_Content Parent=SPDatabaseServiceInstance Name=Microsoft##SSEE, recursive = True. 2 errors and 0 warnings encountered.

Open in new window

0
Comment
Question by:waverazor
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 6

Accepted Solution

by:
psv1973 earned 250 total points
ID: 35130263
It looks like your trying to restore list items/documents that have required fields. However the data for the required fields isn't there. i.e. your data is invalid.

Does your restore recreate the site ok? Does it put most of the data back and do just the invalid items fail?
0
 

Author Comment

by:waverazor
ID: 35130504
It appears that the restore recreates the site mostly ok.  I can access the site and it seems that most items are back.  I don't know which items failed to restore.
0
 
LVL 6

Expert Comment

by:psv1973
ID: 35130597
You might want to have a look in the ULS logs (14/logs) at around 3/14/2011 10:49:36 AM. There should be some more information in there.

You could also try to user stsadm -o restore and include the showtree option:

http://technet.microsoft.com/en-us/library/cc262087(office.12).aspx
0
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 

Author Comment

by:waverazor
ID: 35130745
Do you mean C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\LOGS instead of 14/logs?
0
 
LVL 6

Expert Comment

by:psv1973
ID: 35130975
Yes, for sp 2007 that's right
0
 

Author Closing Comment

by:waverazor
ID: 35151269
Restored to latest backup that did not produce errors.
0

Featured Post

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Pimping Sharepoint 2007 without Server-Side Code Part 1 One of my biggest frustrations with Sharepoint 2007 in the corporate world is that while good-intentioned managers lock down the more interesting capabilities of Sharepoint programming in…
We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…

724 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question