Sunday 26 February 2012

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

Hi,

An issues was reported to me where a developer was trying to use a  CAML query and was getting this error:
"One or more field types are not installed properly. Go to the list settings page to delete these fields". I checked the fields and they fine I executed few other queries and found that they were working fine. This was a clear indication that there was something wrong in the query rather than in the list settings. I found that the query had a column "Approval Status". To verify if it is causing the issue or not I executed  a small piece of code to get the internal name and I found that the internal name of this field is "_ModerationStatus". I changed the value in the query and it worked fine.

I am sharing this so that it will be helpful for someone facing this. I am attaching a small piece of code for reference


SPQuery query = new SPQuery();
                String camlQuery = "<Where><Eq><FieldRef Name='_ModerationStatus'/><Value Type='Text'>Pending</Value></Eq></Where>";
                query.Query = camlQuery;
                SPListItemCollection items = list.GetItems(query);

I hope this will help you out.

Unable to create a new Group in Manged Metadata Service in Sharepoint 2010

Hi,

An issue was reported to me where one of the farm administrator was not able to create a new group in managed metadata service in Sharepoint 2010. This looks strange to me since this involved very simple steps. I was able to overcome this within a minute and I am sharing it here so that others who will face this issue should not spend time on this. The drop down was not getting enabled in the left panel under managed metadata service node because the Term Store Administrator for this metadata service was not selected. I added this and then saved it . Now the drop appeared and "New Group" option started to come as shown in the image below:








I hope this will help you out.

Wednesday 22 February 2012

The search request was unable to connect to the search service in Sharepoint

Hi ,

An issue was reported to me where in a new sharepoint environment the users were unable to search anything. Whenever they were trying to search they were getting this message "The search request was unable to connect to the search service in Sharepoint". I looked into the search settings and administration and found that it was fine. The files were also getting indexed and were available in crawl logs. I checked the account used for crawling and found that it was also fine. After some digging I found the solution to this problem. Here are the steps needs to be followed in this case:

1. Open Central Administrator
2. Go To Operations --> Services on server
3. Select the server you are using for query role.
4. Click on "Office Sharepoint Server Search".
5. Check the option "Use this server for serving search queries".
6. Provide credentials and check other settings and click on OK.

Thats it and it will work for you.

I hope this will work you out.

Thanks,
Rahul Rashu