?
Solved

WSS 3.0 Restore Error

Posted on 2011-03-14
6
Medium Priority
?
720 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 750 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
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 

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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

There is one common problem that all we SharePoint developers share: custom solution deployment. This topic can't be covered fully in this short article, so all I want to do in this one is to review it from a development-to-operations perspectiv…
For SharePoint sites, particularly public-facing ones, there are times when adding JavaScript, Meta Tags, CSS Styles or other content to the page <head> section is more practical than modifying master pages.  For instance, you could add the jQuery l…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

752 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