Solved

WSS 3.0 Restore Error

Posted on 2011-03-14
6
704 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Microsoft SharePoint Foundation 2010 and Microsoft SharePoint Server 2010 do not offer the option to configure the location of the SharePoint diagnostic trace log files during installation.  This can, however, be configured through Central Administr…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
A company’s greatest vulnerability is their email. CEO fraud, ransomware and spear phishing attacks are the no1 threat to a company’s security. Cybercrime is responsible for the largest loss of money to companies today with losses projected to r…

947 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

24 Experts available now in Live!

Get 1:1 Help Now