<< Helpful SharePoint Query String Parameters and JavaScript | Home | Unable to load unit test - the assembly was not built with any known testing framework >>

SharePoint ErrorCode 0x81020014 on CAML Update

Recently while working on a client SharePoint project I encountered the following error code and message while executing a CAML update statement against a list: 
<Results xmlns=\"http://schemas.microsoft.com/sharepoint/soap/\">
<Result ID=\"1,Update\">
    <ErrorCode>0x81020014</ErrorCode>
    <ErrorText>One or more field types are not installed properly. Go to the list settings page to delete these fields.</ErrorText>
<z:row ...  xmlns:z=\"#RowsetSchema\" /></Result>
</Results>
Frankly, the error message wasn't very helpful and I didn't see the issue right away but then I saw it -- I had used the wrong internal column name. The actual internal name in this case had a trailing 1 at the end of it. After using the correct name there was no need to "delete these fields" since the fields were indeed properly installed. It would have been more helpful if the message had said something like "the column you are trying updated doesn't exist", or "check your column names". Hopefully this helps someone else or perhaps just me in the future.

posted @ Monday, February 08, 2010 10:10 AM

Feedback

# re: SharePoint ErrorCode 0x81020014 on CAML Update

Not sure if you can still remember, but how do I locate the internal column name and find the 1, if I am not sure which list/library it is on? via Sharepoint Manager 2007? 8/15/2011 8:50 PM | Ezs

# re: SharePoint ErrorCode 0x81020014 on CAML Update

If you know what library it is in then you can just look at the query string when you pull up the column in the list settings. The URL should say something like field= and the value would be the internal name. 8/15/2011 10:04 PM | blogadmin
Post a comment





 

Please add 1 and 8 and type the answer here: