.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Problem updating a managed metadata column value

Posted By:      Posted Date: October 27, 2010    Points: 0   Category :SharePoint


I have a document library where I've added a managed metadata column that contains a list of city names.
So far so good, I can add documents and set a value for this column.

The problem starts when modifying a city name. E.g. I change New York into Washington.
All items that were linked to New York will still show New York and not Washington.
When adding a new document I can pick Washington from the list of cities, but in my view it will still show New York (even though I picked Washington and there is no sign of New York in the values). When opening "view properties" it will still show New York. When opening "edit properties" it will show Washington.

This is very confusing to users (and also for me)!
Is there a timer job or something that should run before all items will use the correct updated value ?

View Complete Post

More Related Resource Links

Provision DocumentLibrary with Managed Metadata column

Via the SharePoint 2010 UI I've created a DocumentLibrary and added a new column of type Managed Metadata. I've associated a TermSet with this column and all works fine. Now I need to create a deployment package in Visual Studio 2010. It is easy enough to create the Document Library. I've followed the below steps 1. Create empty SharePoint 2010 project 2. Added new Empty Element to the project. In the Elements.xml I have <Field ID="{15712E76-A603-43AB-885E-CE48BD216381}" Type="TaxonomyFieldTypeMulti" Name="DocTags" DisplayName="DocTags" ShowInDisplayForm="TRUE" ShowInEditForm="TRUE" ShowField="Term1033" Required="FALSE" StaticName="DocTagsInternal" Group="NotSure"/> 3. Added ContentType to the project. Added FieldRef elements to the Element.xml 4. Added List Definition From Content Type and associated it with the above Content Type. 5. Created a List Instance of the above List Definition. 6. Build and Deploy. 7. Associate the column with a Term Set. 8. Add Document to the Document Library. I can select a Term from the applicable TermSet, but when I save the document I get: Failed to get value of the "DocTags" column from the "Managed Metadata" field type control.  See details in log. Exception message: Invalid field name. {00000000-0000-0000-000

search on managed metadata column values

I am trying to search on a managed metadata column in a list.  I have the managed metadata as a mapped property (these are automatically set up actually). I have a column frequency (daily, weekly, monthly, yearly) I can enter a search box owstaxIdFrequency=#a132a333-39f1-4737-9ad4-a932482e025f   //this is the taxonomy guid for Daily.  This shows results. How do I search on the word "Daily" in the frequency column?  (I just want to figure it out on a simple search first meaning just using one search box)   I noticed that there are extra maped columns for managed metadata columns (owstaxIdFrequency also has owstaxIdFrequencyx0020Tag, I tried owstaxIdFrequencyx0020Tag="Daily", but it didn't work)

Add managed metadata column to list - access denied + terms not visible in lists


Firstly the following is not a problem for users given "Full Control" (and possibly other permission levels might work) at the web application level in central admin.

For any other user with permissions set at site collection level, even "site owners" (full control) , these problems arise.

  1. When adding managed metadata columns to a new document library list, clicking save results in multiple access denied errors getting logged (as seen using UlsViewer) and an exception is raised (sharepoint error page)
  2. In existing document library lists managed metadata column headings are displayed in list views but the terms text is not displayed.
This problem shows up even if the logged on user is the term set owner.  "Available for tagging" is enabled, submissions policy is closed.
Looking at http://<the-site-domain>/Lists/TaxonomyHiddenList/AllItems.aspx and then checking list permissions I can see that "All Authenticated Users" has Read permission level.
Integrated windows authentication - NTLM + Claims Based Authentication is the only authentication method used. It's an intranet site. 

Thanks in advance for any help.

Managed metadata column not displaying data



We are in process of rolling out our new intranet on SharePoint. Two days away from the launch we have run into a strange problem. We have various custom content types and within that we have custom columns which are managed metadata. The columns are then exposed in various document libraries and users choose appropriate metadata when adding the documents to the library. Everything was working fine, until yesterday all of a sudden we were not able to see any data in the columns which were managed metadata columns. But if we edit the properties of the document we can see the field is populated.

Another strange thing is that if the user has full permission in central admin they can see the metadata in the columns, but anyone else (including site owners) cannot.

Can anyone please shed some light on this and if someone knows how to resolve this?



Managed Metadata column not grouping correctly



I'm trying to group a list by a Managed Metadata column, it works fine with my farm admin/site collection admin user account however i can't get it to work for any other user account. I've tried giving one of the other user accounts term store admin but still no luck. With these user accounts all i get is one group which contains all items regardless of what term is selected for the item. The single group displays as an empty term e.g. it looks something like 'MetaData Column: (80)'. However if you look at individual columns you can see what term has been selected.

If it makes any difference I'm experiencing the issue while using an Enterprise Wiki site, I'm trying to group pages in the pages library by the 'Wiki Categories' column. I've set the field to point to a new term set and disabled multiple entries.

Any ideas?

Possible bug in SP2010 - Managed metadata column and STP document library template


Hello I have a problem with managed metadata on two different servers and would like to ask you to try it.

I assume you have managed metadata service running.

1, Open some document library in some site
2, Create column - managed metadata type and select some termset and set it as required.

3, Upload a document and fill in metadata when you will be asked.

4, Then edit properties and check, that metadata are there.

5, Save this library as template.

6, Deploy document library from this template and try steps 3+4.

My problem is, you can select metadata, but they are not saved. e.g. when you check document properties managed metadata are not there.

Can you confirm this behavior ?
Thank you very much.


P.S.: one more weird thing. If you do metadata filling using office 2010 compatible application. Metadata remain there, but they are not visible in document library properties.

Tomas Paulas MCP,MCSA,MCSA-Messaging

problems with filtering managed metadata column


I like managed metadata in many way, but there´s several things I can´t get "right":

- In a document library I have managed metadata columns. If i filter with one column (say I filter Europe in column Continents) , every other column take´s away unrelevant filtering options (Country column should only show European cuntries) , except the  managed metadata columns, wich show everyting. Why? Can I change that?

- I have a long list of terms in a managed metadata column. When I try to filter that column, I have to press "more" severel times to get the term I want to filter on. Is it posible to see all terms at ones or se more that 20 terms before I have to click on "more"?

Thanks for helping me,


Managed Metadata column in DataSheet View


i am unable to edit managed metadata columns in the DataSheetView, i have other columns which are number, text field type which i am able to edit. So the view is not readonly, it is only when i click cell with the managed metadata column i get the readyonly prompt.

Evironment : Sharepoint 2010, Office 2007 and a pissed off customer

Appreciate any help



I am what i am

Read Only Managed Metadata column in DataSheet View


i am unable to edit managed metadata columns in the DataSheetView, i have other columns which are number, text field type which i am able to edit. So the view is not readonly, it is only when i click cell with the managed metadata column i get the readyonly prompt.

Evironment : Sharepoint 2010, Office 2007 and a pissed off customer

Appreciate any help

I am what i am

Cannot copy the value of a managed metadata column from one list to another


I have a problem when trying to copy a value of a managed metadata column from one list to another by a Sharepoint Designer (SPD) Workflow

I have two lists. "Locations" and "Employees". "Locations" has a Content Type integrated that has a Site Column of the type managed metadata named "Geographic Location". This Managed Metadata column describes the geographic location from continent down to the city name. I also have a Content Type for the "Employee" list. This one contains a lookup column "Location Abbreviation" on the title column of the "Locations" list and the same managed metadata column "Geographic Location". Now my Workflow is created to work with the Content Type "Employee" and goes like this:

Set current item:Geographic Location to Locations:Geographic Location (where Current Item:Location Abbreviation equals Locations:Location Abbreviation (Lookup Value (As Text)))

But the workflow always reports "Error occured". The message is:

"The workflow could not update the item, possibly because one or more columns for the item require a different type of information."

But is is very unlikely that this message is useful as both columns use the same Site Column. Do you have any Ideas?

Managed Metadata Service Application Problem



I've been trying for a whole day to configure managed metadata services on a windows server 2008 R2 environment but I keep getting this error:

The Managed Metadata Service or Connection is currently not available. The Application Pool or Managed Metadata Web Service may not have been started. Please Contact your Administrator.

I've tried searching for a resolution and here's what I got:

  1. Change the application pool account / Check that the pool is running.
  2. Download hot fixes KB981002 and KB976462.
  3. IISRESET / Restart the server.
  4. Ensure that Managed Metadata service is running.

The third solution worked for me in my development environment which is Windows 7, but I couldn't get it to work in Windows server 2008 R2 which is the production environment.

Any help would be appreciated :)

Problem inserting into XML column

I have a C# application that inserts XML into Sql Server 2005.  When the message is more than 300 lines or so, it doesn't make it there.  The data shows in the application variables (stringWriter) but doesn't get inserted and that's confirmed looking in Profiler. The stored procedure is simply:          usp_WS_OrderEntry_InsertWSOrder @doc=@p1,@WSOrderId=@p2 output       INSERT INTO WS_OrderEntry_Order (OrderXML)       VALUES(@doc)  ..... C# .....             tableAdapter.usp_WS_OrderEntry_InsertWSOrder(stringWriter.ToString(), ref wsOrderId); .... In any cases, the variable "stringWriter" contains the data (as text). In profiler for a successfull call: declare @p1 xml set @p1=convert(xml,N'<OrderHeader><CustomerNumber>1234</CustomerNumber><Pr.....</PO></ShipToName> declare @p2 int set @p2=1077 exec dbo.usp_WS_OrderEntry_InsertWSOrder @doc=@p1,@WSOrderId=@p2 output select @p2 In unsuccessfull call: It shokes on the convert part and doesn't display any data (and doesn't insert as well).  I looked in LOGs, events and didn't find anything. Any help appreciated.  Thanks.

Problem updating records with LINQ, Concurrency?

 My project includes a grid view with some updtable fields, some fields throw an error on update and some do not and it does not really make sense. WORK_STATION_ID does not cause an error, ROOM _ID cause an error, both are int? (I am using c#) and for update I use the code liste below.using (DataClassesDataContext db = new DataClassesDataContext()) { var product = (from p in db.ASSETs where p.ASSET_ID == ASSET_ID select p).Single(); product.WORK_STATION_ID=WORK_STATION_ID; product.ROOM_ID=ROOM_ID; db.SubmitChanges(); }    Row not found or changed. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.Linq.ChangeConflictException: Row not found or changed. Source Error: Line 93: Line 94: Line 95: db.SubmitChanges(); Line 96: Line 97: Source File: C:\Projects\TEST_II\trunk\ObjectDataSourceLibrary\AssetController.cs Line: 95 Stack Trace: [ChangeConflictException: Row not found or changed.] System.Data.Linq.ChangeProcessor.SubmitChanges(ConflictMode failureMode) +963417 Syst

wpf charting column series data binding problem

I'm trying to build a chart using the columnSeries from the wpf toolkit and I appear to be having trouble with the data binding. Here is the xaml: <Grid>    <chartingToolkit:ColumnSeries Height="18" HorizontalAlignment="Left" Margin="188,169,0,0" Name="columnSeries1" VerticalAlignment="Top" Width="18" IndependentValueBinding="{Binding Path=Date}" DependentValueBinding="{Binding Path=Value}" /></Grid> In the code behind, I'm calling a stored procedure and putting the result in a datatable like this: string connString = ConfigurationManager.ConnectionStrings["string"].ConnectionString;            using (SqlConnection cn = new SqlConnection(connString))            {                DataTable dt = new DataTable("T1");                cn.Open();                SqlCommand cmd = new SqlCommand("T1_sp", cn);                cmd.CommandType = CommandType.StoredProcedure;                  SqlDataAdapter da = new SqlDataAdapter(cmd);                da.Fill(dt);                columnSeries1.ItemsSource = dt.DefaultView;                cn.Close();            } No error is being generated but I'm not getting a column chart either. If I take the same command and put it into a datagrid, it works fine. What do I need to do to get this into my column chart? If it helps,

How to maximize use of managed metadata in the document library?

We are creating new Intranet portal based on SharePont 2010 and we have document library with 100-200 documents. Old Intranet is based on previous version of SharePoint. End-users did not like the usability of the document library as it was hierarchical. Users needed to know, which was the folders and its subfolder to find out where is the document. We are currently investigating if we can solve this problem by using managed metadata. We know how to define term set and how to give metadata to the document, but we don't know what is the most usable way to utilizem them in the document library. Let say that end-user would like to see all documents that has managed metadata "User Guide". How to configure document library so that users see only those documents. Not all our users are skilled and we have to provide very intuitive way to search relavant documents to them. Some predefined metadata dropdown would be great.Kenny_I

Setting Managed MetaData default values on site creation

I am working on a project where the requirement is to have specific document content types.  I have therefore create a site columns feature which creates all my columns, I have a Site Contentypes feature which creates all my content type and I have list templates based on my content types.  I also have created a couple of Site definition features which create specific list instance based on my list template As part of my content types I have created a few Managed Metadata fields which I wanted to set defaults for on the creation of my sites.  I have therefore created a feature which is right at the end of the WebFeatures section in my ONET.xml.  This features enumerates through all lists, looking for specific column names(managed metadata columns) and looks to set these to specific values.  The code to set the default value on the field is: TaxonomyField documentCategoryField = (TaxonomyField)library.Fields["Document Category"]; if (documentCategoryTerm != null) { documentCategoryField.DefaultValue = documentLibraryDefault.ToString(); documentCategoryField.Update();                                                     }                         &n
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend