Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Field says it's deleted after adding to view

(0) ShareShare
ReportReport
Posted on by

I was recently tasked with making some custom changes to a client's brand new CRM 2011 system. They wanted an additional field added to the Opportunity entity for a "Topic Category". It was designed to be an option set and be available on multiple entities so I created a global option set for the task. On the Opportunity entity itself, I created a new option set field and used the global option set for the options.

I'm able to add it to the form fine, however, when I try to add it to the views I run into an error saying that the field has been deleted and that I need to remove the field before I can save the view.

The exact error is:

This field has been deleted. To use or save this saved view, you must remove the field.

http://imgur.com/O8NUrEP/

After turning on tracing and reviewing the logs, I managed to get this error:

The column, fetchxml, has invalid fetch. Error : 'SystemUser' entity doesn't contain attribute with Name = 'bsb_topiccategory'.

This was created when trying to save the view with the newly created field 'bsb_topiccategory' on it. Saving it seemed to be the only way to pop an error out to the log. All of that being said, I'm not entirely sure how to handle the error.

Of course, I considered adding the field to systemuser as well, however, as I'm new to Dynamics, I didn't want to make matters worse with an ignorant decision based on lack of experience.

This question was already asked at StackOverflow and they pretty much gave up trying to help.

Any and all help is appreciated.

*This post is locked for comments

  • RE: Field says it's deleted after adding to view

    I just wanted to thank you.  It's hard for me to fathom that an administrator to a system wouldn't have read/write access, but thank god you knew.

    I really can't thank you enough.

  • RE: Field says it's deleted after adding to view

    This may be a dumb question, however, is there a way to update permissions to Read/Write outside of the system.  

    It doesn't allow me to change my privilege level when logged in on the account I'm trying to change, and on top of that, I can't create another user, as we're at our limit.

  • Verified answer
    ScottDurow Profile Picture
    ScottDurow 19 on at
    RE: Field says it's deleted after adding to view

    Hi,

    Sorry - I should have described this better.

    As long has you have the 'System Administrator' security role - you will still have administration access even if you have a Read/Write license. The Administrator license is a cut down version of the Full license that only gives you partial access. You must have *both* the System Administrator Role and the Read/Write license.

    Hope this helps,

    Scott

  • RE: Field says it's deleted after adding to view

    Is there a way to have both?  

    Admin & Read/Write?

    I only saw a drop down on the user form to choose either or.

    I don't want to take away admin access on the only administrator user we have.

  • Suggested answer
    ScottDurow Profile Picture
    ScottDurow 19 on at
    RE: Field says it's deleted after adding to view

    Hi,

    You need to have a full read/write license assigned to your user in order to do customizations - so if you only have an Administration license then this probably is the issue.

    Hope this helps,

    Scott

  • RE: Field says it's deleted after adding to view

    @ScottDurrow  -  Admittedly, my skill level is lacking.  After taking another look at the view under the opportunity entity, I couldn't find a way to download said fetchxml.  Could I get some pointers on how to accomplish this?

  • RE: Field says it's deleted after adding to view

    This is a fresh install of MS Dynamics 2011 CRM

    Both CRM and Database are on version 5.0.9690.3448

    There is only one organization added, as this was all the client requested.

    @ScottDurrow  -  I'm not entirely sure what constitutes full access over administrative access (sorry, this is my first experience with Dynamics).  I checked the sysop user we have installed for access to their system and that account is at System Administrator level.  The only thing that I can change the access level to is Read/Write, and I'm not sure that would be what I'm looking for.

    As for the fetchxml, I'll see what I can come up with shortly.

    Thank you guys for all your help.  It's appreciated.

    Alex

  • RE: Field says it's deleted after adding to view

    Hello,

    Is it CRM 2011 Online or On Premise ?

    If On Premise, what is the update rollup installed on CRM server ?

    Also verify if CRM and Database both are on the same update rollup via deployment manager if not ensure both are at same rollup version ?

    Are you seeing the same behavior on other organization in the same deployment ?

    Thanks

  • Suggested answer
    ScottDurow Profile Picture
    ScottDurow 19 on at
    RE: Field says it's deleted after adding to view

    Hi,

    It could be that the fetchxml has been changed on this view so that it can't be edited in the designer - can you add any other fields without problems - or is it only this one? Can you download the fetchxml of the view you are the field to and post it?

    Also, it's worth asking -  I've seen similar issues if your user only has Administrative level licensing - rather than full access?

  • RE: Field says it's deleted after adding to view

    I've already tried all of these suggestions.

    Any custom field added acts the same way.  If I've created it, it won't allow me to add it to a view.  

    I've recreated the field several times to see if it would potentially fix itself with no luck.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,432 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans