InfoPath error – “Your user name or group membership cannot be verified because the form's security settings do not permit it.”

Working with existing InfoPath forms, while opening the form it is showing error as “Your user name or group membership cannot be verified because the form's security settings do not permit it.” As shown the below.

 We can get this error due to form security error. To fix that we need to add the site to local sites by using the steps below.

Navigate to IE and open Internet Option from IE settings.

In the Security Tab, Select “Local Intranet” option and click on Sites button.

You can see “local Intranet” popup, click on “Advanced” button.

Add the Site to local intranet sites by clicking on Add button. Click on Close button.

Click on Ok button to Save “local Intranet” popup and Ok button to close internet options.

By opening the form we can see the form without any errors. Hope this helps.

Customize SharePoint survey through UI

In SharePoint survey we don’t have option to edit the survey views and details. In my project, we need to add a column with to response to survey which works as a normal list item. This column need to save the response of the survey. I have tried to do this through UI and I am unable to do that as regular list options. I have checked it in google, few answers says that it is nearly impossible to do that through UI and we have to go for custom coding.

By checking few more links I got a clue to do that. It says that a designer workflow will collect the feedback from the user who responds the survey and workflow fills the response details to survey. That’s great. I got the fix for that.

To create new view in survey list,

• ·         Open the new view page in SharePoint site, copy the URL to a notepad. URL shows like “/_layouts/15/ViewNew.aspx?List=%7B0C3E3AB1%2D555D%2D4FE0%2DB9B3%2DB58BE4D36D22%7D”
• ·         Open Survey settings page, Replace the Survey list id with previous URL.

To create a new column in SharePoint survey list, Open Site with concating following URL “/_layouts/fldNew.aspx?ListID=” Add survey list ID.

These are quick hacks for SharePoint survey list. Hope this helps.

SharePoint – Back to basics - Are sure you are SharePoint Farm Administrator?

How can I’ll be SharePoint farm Administrator? By Adding Farm Admin group from SharePoint Central Admin site as shown the below I’ll become Farm Administrator?

But as we have expected by completing all the steps, these will not grant Farm Admin privileges on the server. These steps will add user to farm admin group in SharePoint and WSS_ADMIN_WPG group in SharePoint farm. By updating user to this farm admin, users get access to web site and access to SharePoint resources as logs and web services.

If user not added in SharePoint local Admin group, user is not fully-fledged SharePoint farm administrator. When user runs SharePoint management he will see "The local farm is not accessible. Cmdlets with feature dependency ID is not registered."

To execute PowerShell commands, users need SharePoint_Shell_Access in SQL server SharePoint configuration database and other databases where we need to manage the data.

Therefore, to make a user as SharePoint farm admin, he need to have following permissions,

·      Local Administrator security group for each server in the farm

·      Farm Administration SharePoint Group

·      SQL Server SharePoint_Shell_Access database role for the SharePoint configuration database and all content databases.

SharePoint 2013 search refinement web part

One of the most powerful web parts in SharePoint 2013 to provide search refinement experience is Search refinement web part. Search refinement web part allows users to select to refine their search results to be list a subset of results. We can modify this web part to include the properties to be appear as refiners in the search results page and also we have the option to choose the appearance of the properties like single or multiple. Depending on the data returning on the search results web part, we have the advantages to choose metadata values to be displayed. For example in a Office Management Search center, we have data to be displayed custom metadata such as Employee Job type, Designation, Department and some other default information like author details.

As shown the image below, we can see the configuration details in SharePoint Search refinement web part.

Issue with SharePoint custom workflow delay activity

While working with SharePoint custom workflow delay activity, Iam not able to run the code in delay activity. I have deleted and added new delay activity but it wasn’t worked. In general we can add user input after a particular time, we can go with delay activity in SharePoint custom workflow.

Delay activity is broken in SharePoint 2007 as well as SharePoint 2010. To fix that we have to run stsadm commands below,

stsadm -o getproperty -pn job-workflow -url siteURL

stsadm -o setproperty -pn job-workflow -pv “Every 2 minutes between 0 and 59″ -url siteURL

After running the commands, we have reset IIS and Restart the timer services in Server.

Hope this will helps.

SharePoint migration – designer workflow runs twice every time

Migrating from SharePoint 2007 to 2013, SharePoint designer 2007 workflows migrated correctly and workflows are working as expected.

We can’t use SharePoint 2007 list template directly to create the list templates. To do that we have to save the list as a template and need to use that template to create the list.

In SharePoint 2007 site we had a workflow that sends email and update the list data depending on the details created/updated. I have attached the SharePoint designer workflow to the list. But after attaching the workflow, whenever list item added/updated to the list, it is firing twice.

After checking that some time and trail and errors I got the fix for the problem. To do that we have to pause some duration in the workflow beginning. We can make this as 1 min because the workflow timer job will take 5 min and by updating the ‘pause for duration’ value we can change the value by using job definitions in Central Administration.