Wednesday, December 23, 2009

Fix "One or more field types are not installed properly. Go to the list settings page to delete these fields." Error in SharePoint CAML Query

Problem: I got this error when trying to retrieve list items using CAML SPQuery.

Root Cause: There was a field "Artifact ID" in the list, but the internal name was "Artifact",  so it resulted error! Adjusting the internal name in the Query XML fixed the problem.

In an another case,  Got this error:
"The following exception was thrown when trying to enumerate the collection: "One or more field
 types are not installed properly. Go to the list settings page to delete these fields."

One or more field types are not installed properly. Go to the list settings page to delete these fields.

This is because: XML is case sensitive, Field name was entered as "NotificationTo " instead of "NotificationTo" (Note the extra space!)

So the catch is: Always use Internal Name of the field and bear in mind, its case sensitive (E.g. NotificationTo and notificationto are not same!)

You might also like:
SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Document SharePoint Farm
Automatically generate SharePoint documentation.
*Sponsored


Wednesday, December 9, 2009

Run STSADM from anywhere by changing "Path" Environment Variable

Getting "'stsadm' is not recognized as an internal or external command, operable program or batch file." when trying to run stsadm command line tool? This is because stsadm tool is located at: C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN folder and when you try to access it from other folder (typically, command line opens in "C:\Users\Your-User-Name") , command shell may not be knowing where exactly stsadm.exe is located.

So, How to run stsadm from any directory from your SharePoint servers? Simple. Just add the stsadm's location to the "Path" Environment variable. here is how:
  1. Start > All Programs > Control Panel > System.
  2. Select Advanced System Settings, click the Environment Variables button.
  3. Under System Variables, Scroll to Path and click the Edit button.
  4. Add the following to the end of the Variable value field:
      ;C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN

For SharePoint 2010 it would be: ;C:\Program Files\Common Files\Microsoft Shared\web server extensions\14

Run STSADM from any directory
How About SharePoint 2010 and SharePoint 2013?
  • For SharePoint 2010, Set this path to: C:\Program Files\Common Files\microsoft shared\Web Server Extensions\14\BIN 
  • For SharePoint 2013, Its goes as: C:\Program Files\Common Files\microsoft shared\Web Server Extensions\15\BIN


You might also like:
SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Document SharePoint Farm
Automatically generate SharePoint documentation.
*Sponsored


You might also like:

Related Posts Plugin for WordPress, Blogger...