Pankaj Surti's Blog

I got the following exception when I add the custom web part.

Unable to add selected web part(s).

WPIndexingOutcomeSummary: Exception occured. (Exception from HRESULT: 0x80020009 (DISP_E_EXCEPTION)

There is very little information MOSS 2007 leaves for such exception. (The SharePoint 2010 is better in this space). But anyhow I had logs/blogs and reading I was able to narrow down the error using this blog.

 By reading the blog I did not get any information what is the cause and resolution. Specially read the comments lines by Mark Strokes. Also best practices is http://msdn.microsoft.com/en-us/library/aa973248(office.12).aspx

 Mark Stokes – Sept. 23, 2008

I also had this issue and in my case, it was because my web part was accidentally putting a using statement around SPWeb web = SPContext.Current.Web

Bad Bad.  Correcting this sorted the problem.

CAUSE

To add any web part in the MOSS 2007 site on the XXXX Client Site Def sites it threw the following exception. In the ULS logs the following was the information thrown for any web part(s) (Custom or OOB). The key error message is highlighted in yellow.

01/28/2011 08:21:32.23              w3wp.exe (0x1350)                                       0x0C24       Windows SharePoint Services                          General                                          8e2s                        Medium    Unknown SPRequest error occurred. More information: 0x80020009      

01/28/2011 08:21:32.52              w3wp.exe (0x1350)                                       0x0C24       Windows SharePoint Services                          Web Parts                                      89ku                        High           

Failed to add webpart http%253A%252F%252Fwin%252Dc0mtbrojocq%253A22222%252Fsites%252FDemo%252F%255Fcatalogs%252Fwp%252FMSContentEditor%252Edwp;Content%2520Editor%2520Web%2520Part. 

Exception Microsoft.SharePoint.WebPartPages.WebPartPageUserException: Exception occurred. (Exception from HRESULT: 0x80020009 (DISP_E_EXCEPTION))    

at Microsoft.SharePoint.WebPartPages.SPWebPartManager.SaveSomeChanges(SPLayoutProperties layoutProperties)    

at Microsoft.SharePoint.WebPartPages.WebPart.SaveSomeChanges(SPLayoutProperties layoutProperties)    

at Microsoft.SharePoint.WebPartPages.SPWebPartManager.WPSaveSomeChanges(SPLayoutProperties layoutProperties)    

at Microsoft.SharePoint.WebPartPages.SPWebPartManager.MakeSpaceForWebPart(WebPart webPartToPlace, Int32 zoneIndex, String zoneID, Boolean storeInPendingChangesList)    

at Microsoft.SharePoint.WebPartPages.SPWebPartManager.OnWebPartAddingCore(SPSupersetWebPart superset, Boolean throwIfLocked)    

at Microsoft.SharePoint.WebPartPages.SPWebPartManager.AddWebPartInternal(SPSupersetWebPart superset, Boolean throwIfLocked)    

at Microsoft.SharePoint.WebPartPages.SPWebPartManager.AddWebPartInternal(SPSupersetWebPart superset)    

at Microsoft.SharePoint.WebPartPages.WebPartQuickAdd.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)

RESOLUTION

In the code there were three files used the line within using statement.

“using (SPWeb web = SPContext.Current.Web)”

The three files are:

  C:\DMS\DMS\Source Code\UI\Web\WebForms\IndexingPage.aspx.cs(26):                    //using (SPWeb web = SPContext.Current.Web)

  C:\DMS\DMS\Source Code\UI\Web\WebForms\ViewIndexingProperties.aspx.cs(162):            //using (SPWeb web = SPContext.Current.Web)

  C:\DMS\DMS\Source Code\UI\Web\Webparts\CAEL.DMS.UI.Webparts\Administration.cs(35):                //using (SPWeb web = SPContext.Current.Web)

I commented the using keyword and recompiled the code and deployed to VM I was able to add the web part.

So in summary:

1. The SPContext.Current.Web should NEVER be within using statement. By putting in the using statement it is automatically destroyd and it should never be destroyed.
2. Since the above “SPContext.Current.Web” was used in the using statement at later time when I tried to add the web part I got the exception “     Unknown SPRequest error occurred. More information: 0x80020009” in the ULS log.
3. By commenting the using statement and accesing the variable “SPContext.Current.Web” as is correct fix.

I hope if you get similar error and this information helps you.

Thanks,

-Pankaj Surti

At the client side I was asked to create a site using their legacy code. The code failed to create a new site and gave an error the “site already exists”. In the CA I was able to see the site in Site Collection List. However, I could not delete the site. The site had some orphaned objects.

Other diagnosis is, when I ran the following command

stsadm -o enumsites http://demo

I noticed in the output the good site listed correctly but the bad or corrupted site had an exception (as seen below).

  <Site Url=”http://demo/sites/VM” Owner=”EDLINK\psf” ContentDatabase=”WSS_CLIENTS” StorageUsedMB=”35034.6″ StorageWarningMB=”0″ StorageMaxMB=”0″ />
  <Site Error=”The system cannot find the path specified. (Exception from HRESULT: 0x80070003)” />
</Sites>

Did some search for above error/exception and noticed it is something to do with the Orphaned Site objects.

To resolve the problem, I had to attach and detach the content database. The details steps are following. I hope this helps resolving your problem.

— Check for no orphans… Note: you may or may not see the orphaned objects. I always noticed zero count for the problem.

STSADM -o preparetomove -ContentDB DEMO-SQL1:WSS_CLIENTS -site http://demo
— Prepare to move
— Look http://technet.microsoft.com/en-us/library/cc262122(v=office.12).aspx
STSADM -o preparetomove -ContentDB DEMO-SQL1:WSS_CLIENTS -site http://demo

— Dettach the content database
stsadm -o deletecontentdb -url http://demo -databasename WSS_CLIENTS -databaseserver DEMO-SQL1

— Attach content DB
stsadm -o addcontentdb -url http://demo -databasename WSS_CLIENTS -databaseserver DEMO-SQL1

—
— check for no orphans, if it was present before hopefully the count will be zero this time.
stsadm -o databaserepair -url http://demo -databasename WSS_CLIENTS

—
— UNDO Prepare to move
— Look http://technet.microsoft.com/en-us/library/cc262122(v=office.12).aspx
STSADM -o preparetomove -ContentDB DEMO-SQL1:WSS_CLIENTS -site http://demo -undo

Thanks,

-Pankaj Surti.