Paul Galvin's (old) SharePoint space [SharePoint

Just another WordPress.com site

MOSS Tells Me My Column Name is Reserved or In Use … But It’s Not

UPDATE 12/04/07: See this Microsoft KB (http://support.microsoft.com/kb/923589) for related information.

Actually, it turns out it is, but tricksy MOSS had to make it difficult.

My customer does some development work on his MOSS site over the weekend.  It’s a bit of a jumble as to what he actually did, but the end result is this:

  • He tries to add a site column called "Quantity" and MOSS replies: "The column name that you entered is already in use or reserved.  Choose another name."
  • He attempts to add it to another environment and that works.  Therefore, "Quantity" is not a reserved name.
  • He tries to find an existing site column named "Quantity" in that site collection.  He cannot find it.

I did some research,  and even some coding, waxed philosophical and finally found that a column named Quantity did, in fact, exist.  It was in the "_Hidden" group.  Hence, we could not find it via the SharePoint user interface.

How did it get there?  I do not know, but I have a theory (or as my wife would call it, "blah blah blah").  Somewhere along the line, a fabulous forty template was added and probably activated at a site in the site collection.  It was then deactivated (or the site removed).  The site column, however, remained but in the "_Hidden" group.  If someone knows better, please let me know via email or post in the comments.

SharePoint was telling the truth.  It’s hardly worth pointing out that that message is not as helpful as it could be.  It would be nice to see that message fork into two different messages in the future: 1) Say that the column name is reserved or it is not. 2) If it’s not reserved, show the site, or at least the group, where the column name is already used.

</end>

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: