"Column may have been deleted by another using" error on populating list created through COM

Question

I am creating a list using COM for Sharepoint 2010.

below is a snippet for the same:

        CredentialCache myCache = new CredentialCache();
        myCache.Add(new Uri("myURL"), "NTLM", myCred);



        // declare the ClientContext Object 
        SP.ClientContext _clientcontext = new SP.ClientContext(_context);
        SP.Web _site = _clientcontext.Web;
        // declare a ListCreationInfo 
        SP.ListCreationInformation _listcreationinfo = new SP.ListCreationInformation();

        // set the Title and the Template of the List to be created 
        _listcreationinfo.Title = "NewListFromCOM";
        _listcreationinfo.TemplateType = (int)SP.ListTemplateType.GenericList;

        // Call the add method to the ListCreatedInfo 
        SP.List _list = _site.Lists.Add(_listcreationinfo);

        // Add Description field to the List 
        for(int i=1;i<4;i++)
        {
            someStr = "<Field Type='Number' DisplayName='Col0" + i + "'></Field>";
        SP.Field _Description = _list.Fields.AddFieldAsXml(@someStr, true, SP.AddFieldOptions.AddToDefaultContentType);
        }


        // declare the List item Creation object for creating List Item 
        SP.ListItemCreationInformation _itemcreationinfo = new SP.ListItemCreationInformation();

        // call the additem method of the list to insert a new List Item 
        SP.ListItem _item = _list.AddItem(_itemcreationinfo);

        _item["Title"] = "New Item from Client Object Model";

        for (int i = 1; i < 4; i++)
        {
            someStr="Col0"+i+"";
            _item[someStr] = 100 + i;
        }


        // call the update method 
        _item.Update();

I wanted to create columns like = Col01, Col02, Col03. Then create an item in the list, and update.

The list gets created successfully, but on updating I get an error:

        Column 'Col01' does not exist. It may have been deleted by another user.

Could someone pls help why this is happening? The list exists, and I have tried deleting it and running the code again. It doesnt work. I have tried using the static name (="_x0043_ol01") for Col01 but can't figure out how.

Really appreciate your help.

Answer 1

If what Arsalan suggested doesn't help then try loading column before trying to update them, as it has been done in this article

Also can you go to list through browser and check if columns are actually being created or not.

EDIT

Try enabling the retention in the parent content type and re-publish the associated content type.

Similiar Problem

Hope it helps.

Answer 2

call _list.Update(); after the loop of adding fields

Use following code for adding List Item:

// call the additem method of the list to insert a new List Item 
SP.ListItem _item = _list.AddItem();

_item["Title"] = "New Item from Client Object Model";

for (int i = 1; i < 4; i++)
    {
        someStr="Col0"+i+"";
        _item[someStr] = 100 + i;
    }


// call the update method 
_item.Update();

No need for ItemCreationInformation

I hope this helps

Answer 3

In my list, the Static Name and Internal Name seem to be the same. I am not sure if this is the case normally. Using the Display Name was definitely failing.

Here is what worked for me:

1. adding _list.update();

2. Using static name as -

   _item["_x0043_ol03"] = comboBox1.SelectedText;
   

I just want to say thank you to the community, specially @ArsalanAdamKhatri and @TimeToShine . Thank you for all the time and energy you put into helping queries of us newbies! :)