08 May, 2012

Cannot delete a Corrupted lookup Column from the list

Issue : Just Today i came accross a issue in Which the User had a List with many columns and One of the column Which was a look up column was corrupted

used to give a error "Unknown Error"

We were not able to Delete or edit the column

After a lot of research we found a work around to delete the Column

Checked the Url and found the below

/_layouts/FldEditex.aspx?List=%7B37920121%2D19B2%2D4C77%2D92FF%2D8B3E07853114%7D&Field=Product%5Fx0020%5FDescription

Which is a wrong url it should be

/_layouts/FldEdit.aspx?List=%7B37920121%2D19B2%2D4C77%2D92FF%2D8B3E07853114%7D&Field=Product%5Fx0020%5FDescription

Just remove ex from FldEditex.aspx => FldEdit.aspx

And you will be able to get to the inside of the column where you can edit or Delete the column .

Cause - Unknown

13 comments:

  1. Thanks Amol. It works. Helped me fix a corrupt look up column. Cheers!!

    ReplyDelete
    Replies
    1. No problem Manjeet :) Always welcome. Do let me know in case of any queries/questions, Thank you!

      Delete
  2. Worked for me. thanks

    ReplyDelete
    Replies
    1. my pleasure :) Do let me know in case of any queries/questions, Thank you!

      Delete
  3. Love it!! Knew there had to be an easy way. Thanks!!!!!!

    ReplyDelete
  4. Most helpful. Immortalized in our team's SharePoint Admin Knowledge Base. Thank you for sharing this with the community.

    ReplyDelete
    Replies
    1. Thank you for your appreciation :) Do let me know in case of any queries/questions, Thank you!

      Delete
  5. very valuable information! My issue has been fixed... Thanks Amol!!!

    ReplyDelete
  6. Hi, Even I am not able to delete the custom lookup field in sharepoint list.
    Note: I have created list through vs2010 wsp.


    Please Advice..

    ReplyDelete
  7. Hi, Even I am not able to delete the custom lookup field in sharepoint list.
    Note: I have created list through vs2010 wsp.
    Field ID="{BC2682F3-F9C9-4D16-BCBE-D4F0A1628A3A}" Type="Lookup" Name="Name" DisplayName="Name" List="Lists/NameList" Mult="TRUE" ShowField="DocName" EnableLookup="TRUE" IsRelationship="TRUE" Overwrite="TRUE" Required="FALSE" Sealed="FALSE"

    Please Advice..

    ReplyDelete
    Replies
    1. Could you please try to delete that column by using SharePoint designer (SPD) 2010?

      I am pretty much sure that its been possible by using SPD.

      Please check and let me know the results, Thank you.

      Delete
  8. Many thanks, Amol, you saved me hours of trouble-shooting!

    ReplyDelete

Your feedback is always appreciated. I will try to reply to your queries as soon as possible- Amol Ghuge

Note: Only a member of this blog may post a comment.