SharePoint Orphans Analyzer Remove (optional) orphaned attachments in SharePoint Discussion Board
Download

SharePoint Orphans Analyzer Ranking & Summary

SharePoint Orphans Analyzer Tags

analyzer SharePoint orphaned attachment remover remove orphaned attachment orphan attachment analyzer orphan attachment discussion Usenet discussion Discussion board orphaned discussion list

SharePoint Orphans Analyzer Description

The SharePoint Discussion Board Orphaned Attachments Analyzer was developed to be a WinForm 2.0 application that helps SharePoint Administrators and/or developers to find and remove (optional) orphaned attachments in SharePoint Discussion Board. When you delete a Discussion Board Item (using SharePoint object model or UI) if the item has attachments, those are not deleted. They became orphans and cannot be managed by UI or code anymore. The only way I found to manage (ie delete) these orphaned attachments is to deal directly in the SharePoint databases. These orphans don't seems to be a problem until you try to export a WebSite using the "stsadm -o export" command or the Content Migration API, then you could get this message : - FatalError: This constraint cannot be enabled as not all values have corresponding parent values. - at System.Data.ConstraintCollection.Add(Constraint constraint, Boolean addUniqueWhenAddingForeign) - at System.Data.DataRelationCollection.DataSetRelationCollection.AddCore(DataRelation relation) - at System.Data.DataRelationCollection.Add(DataRelation relation) - at System.Data.DataRelationCollection.Add(String name, DataColumn[] parentColumns, DataColumn[] childColumns) - at Microsoft.SharePoint.Deployment.ListItemObjectHelper.GetNextBatch() - at Microsoft.SharePoint.Deployment.ObjectHelper.RetrieveDataFromDatabase(ExportObject exportObject) - at Microsoft.SharePoint.Deployment.ListItemObjectHelper.RetrieveData(ExportObject exportObject) - at Microsoft.SharePoint.Deployment.ExportObjectManager.GetObjectData(ExportObject exportObject) - at Microsoft.SharePoint.Deployment.ExportObjectManager.MoveNext() - at Microsoft.SharePoint.Deployment.ExportObjectManager.ExportObjectEnumerator.MoveNext() - at Microsoft.SharePoint.Deployment.SPExport.SerializeObjects() - at Microsoft.SharePoint.Deployment.SPExport.Run() using the tool provided by this project, you can verify if there are orphaned attachments in the SharePoint WebSite Discussion Board (in fact it tests all Lists in the WebSite, but orphans should only appears in Discussion Board), and choose if you want to remove them or not.

SharePoint Orphans Analyzer Related Software