Approval Status column showing in edit document properties
I have run into a weird issue with the 'Approval Status' column. Even though require approval is turn off, the column is still displaying in my edit properties. When I go in under Document Library Settings, it does not appear in the list of columns. The values in the drop down are appearing as: 0;#Approve 1;#Rejected 2;#Pending When I try to save after editing properties (without changing any values), I get the message: Failed to get value of the "Approval Status" column from the "Moderation Status" field type control. See details in log. Exception message: Input string was not in a correct format.. To reiterate, this column is not showing up in document library settings, so I cannot remove it. I am running WSS 3.0. Logging is turned off due to disk space issues. Thanks, Dustin
January 17th, 2012 5:40pm

Dustin, Is it possible that the EditForm.aspx page for your list has been customized? If so, it is possible that the column is being displayed in a custom list form and just needs to be removed. If you need to retain the customization then you can manually edit the page to remove the column; if you don't need the customization you may be able to remove the custom list form on the page and restore the default list form. Hope that helps, Chanda
Free Windows Admin Tool Kit Click here and download it now
January 18th, 2012 9:32am

Hi, I too have faced this issue. I managed to resolve this by executing the code. I am providing that over here so that it will help you: using System; using System.Collections.Generic; using System.Linq; using System.Text; using Microsoft.SharePoint; namespace DeleteWorkflowColumnsColumns { class Program { static void Main(string[] args) { String siteUrl = YourSiteUrl; String listName = YourListName; try { using (SPSite site = new SPSite(siteUrl)) { using (SPWeb web = site.OpenWeb()) { web.AllowUnsafeUpdates = true; SPList listSource = web.Lists[listName]; String[] columnNames = { "YourColumn1", "YourColumnName2", "YourColumnName3" }; for (int i = 0; i < columnNames.Length; i++) { SPField fieldtoBedeleted = listSource.Fields[columnNames[i]]; fieldtoBedeleted.AllowDeletion = true; fieldtoBedeleted.Sealed = false; fieldtoBedeleted.Delete(); listSource.Update(); } web.AllowUnsafeUpdates = false; Console.WriteLine("The columns are deleted successfully"); Console.ReadLine(); } } } catch (Exception e) { Console.WriteLine(e.Message); Console.ReadLine(); } } } } The same was used to remove some columns created while applying IRM policies. You can refer this at: http://rahulrashu.blogspot.com/2011/10/how-to-remove-columns-barcode-barcode.html http://social.technet.microsoft.com/wiki/contents/articles/5175.aspx Alternatively you can do the same with the slight modifications in the powershell scripts defined at: http://social.technet.microsoft.com/wiki/contents/articles/5207.aspx I hope this will help you out. Thanks, Rahul Rashu
January 18th, 2012 2:34pm

Thanks for the replies. Chanda, the page does not appear to be customized when I go in through SharePoint designer. Rahul, I will test out the code and see if that works, thanks for the suggestion.
Free Windows Admin Tool Kit Click here and download it now
January 19th, 2012 2:35pm

Sorry for the long delay in the reply. It took me a while before I had some time to test this. I ran the powershell script and received the following error: "You cannot delete a base type column." Thanks, Dustin
February 23rd, 2012 4:37pm

It appears as though an addon running on top of our SharePoint server was causing this abnormal behavior. When the document library was recreated and the files were copied over, they did not have the duplicate Approval Status column.
Free Windows Admin Tool Kit Click here and download it now
February 24th, 2012 1:55pm

It appears as though an addon running on top of our SharePoint server was causing this abnormal behavior. When the document library was recreated and the files were copied over, they did not have the duplicate Approval Status column. What was that addon? I'm seeing the same situation--the Approval Status column showing up on the Edit form in the same funky manner. The catch is, we need content approval; deleting the column isn't an option. Re-creation is a last resort, as it's also a relatively large list whose version history would be preferrable to retain.Bob
May 26th, 2012 9:40am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics