Solved

WSS 3.0 Restore Error

Posted on 2011-03-14
6
701 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
  • 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
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 

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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
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…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

747 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now