Sunday, December 14, 2014

SharePoint deployment – Back to basics – WSP stuck on “Deploying” state

While deploying a WSP in one of my SharePoint 2010 project, wsp stuck on “Deploying” state. I am Deploying the solution with farm admin credentials using Central Administration globally. But the status was “Deploying” for long time.

I have spent almost 2 hours on that but still the state is on “Deploying”. By verifying the few blog posts on the same error by running all the administration service jobs using stsadm.exe – o execadmsvcjobs issue may fixed.

I ran the command but still the Deployment status showing “Deploying”. I have restarted OWS Timer Service on all the servers in the farm. Finally all the Deployments ran successfully. 

SharePoint 2013 error – The server was unable to save the form at this error

While working with SharePoint 2013 list, saving the data I got an error saying that “The server was unable to save at this time. Please try again.” As shown the image below.

By checking the logs I have found following error “Memory gates checking failed because the free memory is less than 5% of total memory. As a result, the service will not be available for incoming requests. To resolve this, either reduce the load on the machine or adjust the value of minFreeMemoryPercentageToActivateService on the serviceHostingEnvironment config element.

After verifying the details in event logs, Services and Task Manager Details, I have found that error causing low memory. To fix this error we have to restart “SharePoint Search Host Control” and “SharePoint Administration service”. By refreshing this error we can have a lot of memory will be freed. We have same error when custom application deployed without disposing object. In that case we need to reset the IIS. By resetting the IIS We can save the list data without error.
Hope this helps.

Wednesday, November 5, 2014

SharePoint OWA Power Point error - Sorry, PowerPoint Web App Ran into a problem opening this presentation.

In SharePoint 2013 environment I got an error PowerPoint while previewing the document. Error message states that “sorry PowerPoint web app ran into a problem opening this presentation to view this presentation please open it in Microsoft PowerPoint” as shown the image below.

I am seeing this only one Power Point documents only. Word apps and all the other office are working as expected. By double clicking on the document it is opening as expected.
I have verified ULS logs and IIS logs on trouble shooting this error. I didn’t any information on this error. Tried using fiddler to get any of the information. But no luck. Verified few posts and did following,
  •  Tried to rebuild the Office Web App servers
  •   By passed the host files targeting OWA server
  •  Changed service accounts

All of the options are not worked. Finally one of the post suggested to clear the cache in “d” folder on “C:\ProgramData\Microsoft\OfficeWebApps\Working\d” location in Office Web App server as shown the image below (drive is dependent. In my case it is C:\ If you didn’t find ProgramData, you have set folder option to show the hidden files.)

Go the folder location and remove all the files in the folder (back up all the files instead of deleting). Wow…. It worked like a charm. Almost 3 days I worked on this issue but resolution is this much simple.

Hope this helps..!!!

Sunday, November 2, 2014

SharePoint back basics – move site collection to another content Database using PowerShell commands

Yes, we can move SharePoint site collection form one content DB to another Content database. But before moving the database we need to check following things,
  • New content database should be exists on the same server and it needs to be under the same web application.
  • The account used to move the site collection should be WSS_ADMIN_WPG group and account need to have db_owner permissions.

Before moving the content Db we have verify the size of the DB by using following command,

$spaceUsedinDB = (Get-SPSiteAdministration -Identity (SiteCollection URL).DiskUsed

To move the site collection to the new content DB create a new content DB in SharePoint central Admin by navigating to Application management -> Manage Content Database -> Create new Content Database

Run following command in SharePoint management shell,

Move-SPSite SiteCollection URL -DestinationDatabase Target_Content_DB_Name

This operation will take time depending on the site collection size. 

SharePoint 2007 error while unblocking a file - An update conflict has occurred, and you must re-try this action. The object SPWebApplication Name=XXXX Parent=SPWebService is being updated by XXXXX, in the OWSTIMER process, on machine XXXXX. View the tracing log for more information about the conflict while unblocking a fie type

While working with SharePoint 2007, unblocking a file extension, I got an error saying that “An update conflict has occurred, and you must re-try this action. The object SPWebApplication Name=XXXX Parent=SPWebService is being updated by XXXXX, in the OWSTIMER process, on machine XXXXX. View the tracing log for more information about the conflict while unblocking a fie type” as shown the image below.

To fix this error we have to clear the configuration cache in SharePoint server. To clear the cache we have to follow the steps below,
  • Go to the server where we are seeing the error and stop windows SharePoint service in services.
  • Navigate to C:\Documents and Settings\All Users\Application Data\Microsoft\SharePoint\Config\GUID (here GUID is guid of the folder, we can see the Guid number, Drive is not specifically “C” that might be any drive that SharePoint installed)
  • If we are using Windows server 2008 folder path would be C:\ProgramData\Microsoft\SharePoint\Config\GUID. If we didn’t see ProgramData file, we have to change the folder view settings.
  • Back up the GUID folder another location, and delete all the XML files except Cache.ini file in the folder.
  • Open the cache.ini file in any editor like notepad, select all the data, and delete it. Enter 1 and save the file.
  • Start the Windows timer service in services.
  • Clear the cache in all the WFE servers in the farm.
  • Now we can block/unblock file without any error. 

Hope this helps.

Wednesday, October 29, 2014

Infopath Error: The Query cannot run, Infopath cannot run the specified query. Access denied.

 Creating a InfoPath form for a document library in one of my project, publish the infopath form I got an error saying that “InfoPath cannot run the specified query. Access is denied”.
I have verified few blog posts and verified following options,
  • Permissions to document library and site – Yes iam having Full Control over site and Document library
  • Domain – Yes iam in VPN with the same network

But User cannot submit a form to SharePoint if the security level is ‘Restricted’ . We need to have Domain Trust should be Full Control or more.
To grant Full control we have to follow the steps below,
In the InfoPath File Click on “Form Options” as shown the image below,

In Form Option popup, Security and Trust, Select “Full Trust” on security level as shown the image below.

Click on Ok to save the settings. Now we can publish the InfoPath form with out errors. 

Sunday, October 12, 2014

SharePoint Quick tip - Get SharePoint list item display form details through code

We can get display form URL by appending “DispForm.aspx?ID=” with the URL by adding ID values at the end. We can get the form details byusing list item properties as shown the code below

using (SPSite currentSite = new SPSite(SiteURL))
    using (SPWeb currentWeb = currentSite.OpenWeb())
        SPList currentList = currentWeb.Lists[
List Name];
        SPListItem currentListItem = currentList.Items[
        string displayForm= String.Concat(currentListItem.Web.Url, "/", currentListItem.ParentList.Forms[PAGETYPE.PAGE_DISPLAYFORM].Url, "?id=", currentListItem.ID.ToString());

Hope this helps.

Saturday, October 4, 2014

SharePoint 2010 workflow error – “Due to heavy load, the latest workflow operation has been queued”

While working with custom workflows in SharePoint 2010, I got error in workflow as “Due to heavy load, the latest workflow operation has been queued”. After refreshing the page, most of the times error may fixed and workflow completed as usual. Sometimes I used to stuck on the workflow and I can see only the non-reactive screen with the error. I didn’t event fix the error after resetting the workflow and IIS Manager. After digging for the solution finally I got a fix for the error by updating the Workflow Postpone threshold in farm config manager by using following PowerShell commands,

Set-SpFarmConfig -WorkflowPostponeThreshold 30

By running the command, workflow threshold will be increased from 15 to 30

get-sptimerjob | ?{$ -like "job-workflow"} | set-sptimerjob -schedule "every 1 minutes between 0 and 59"

By running this command frequency of execution for SP timer job, job-workflow will be increased to every minute. After running the commands, if workflow don’t have any issues will be completed as expected.

Tuesday, September 30, 2014

SharePoint Restore-SPSite error - Response message does not match the content type of the binding

While working with SharePoint site  restoring with PowerShell commands I got an error saying that, 

Restore-SPSite : The content type text/html; charset=utf-8 of the response message does not match the content type of the binding (application/soap+msbin1). If using a custom encoder, be sure that the IsContentTypeSupported method is implemented properly

After googling some time I got the cause and fix for the solution. In my case in my current secured store service web application web.config file we have some duplicate nodes for forms based configuration.

To fix that we need to follow the steps below,
  • Open SharePoint server form and open IIS manager.
  • Open SharePoint Security Token Service Application and Explore the web application details for web.config file.
  • In the web.config file verify the duplicate nodes and check all the nodes are allocated properly in the web.config file. In my current scenario we got extra node in forms based authentication configuaration. I have removed the duplicate node and restored the site.

Now I am able to restore the site. Hope this will helps.

Saturday, September 27, 2014

SharePoint – Back to basics – Designer quick tips – All Items in navigation, Updating List URL

I got a simple requirement for one of my project to update the list URL. Basically this is a simple requirement by using Object model/PowerShell commands. But we don’t have option to use PowerShell commands or coding. Even without them we can update that easily from SharePoint designer. This is simple option I haven’t seen/worked on earlier.

We can update the list URL by navigating to designer All Items -> Lists folder. But unfortunately I can’t find All item option in designer. By default we can’t see that option. To enable that option we have to enable the option in Central Administration as the steps below.

Navigate to SharePoint central administration General Application settings. Click on “Configure SharePoint Designer Settings”

To enable SharePoint designer to a site we have to check “Enable SharePoint Designer ” to see All items option we have to check “Enable Managing of the Web Site URL Structure ” option as shown below.

To change the List URL click on “All Items” in designer. We can see the list of all the contents. Click on Lists folder.

Select the list to change the URL, right click and select Rename option.

Rename the list as per the requirement. By updating the list name URL of the list will be changed. Here before changing the list URL looks like http://SiteURL/Lists/TestCustom/AllItems.aspx . I have updated the name as Testlist. By updating the name URL updated as http://SiteURL /Lists/Testlist/AllItems.aspx .

Sunday, September 21, 2014

SharePoint InfoPath form Allow anonymous users to enter data

SharePoint InfoPath forms is one of the way to enter data into SharePoint. To allow anonymous users to enter the data in the forms we have to follow the steps below,
  • Configure Anonymous access to SharePoint site
  • Create a list that to submit data anonymously, Change anonymous permissions to the list and update list form to InfoPath form

To configure Anonymous access to Site, navigate to SharePoint central Administration, Navigate to Application management -> Manage Web Applications.

Select the web application, click on “Authentication Providers” in the ribbon. Check “Enable anonymous access” checkbox to Enable Anonymous Access to web application.

To Enable Anonymous access to SharePoint site, Navigate to SharePoint site where we need to allow users enable anonymous access. Open Site Settings, Select Site Permissions. In Ribbon, Permissions Tools section, click on Anonymous access button.

Select Entire Web site option in Anonymous access popup.

Create a List in the site. In List permissions, Break permissions from Parent and Enable Anonymous access to Add items to list.

Customize the InfoPath form by  using Customize List option in the ribbon. 

SharePoint 2007 error while opening the site in designer - this website has been configured to disallow editing with SharePoint designer

One my client having SharePoint 2007 environment. We got some requirement to check the existing functionality in one of the site. To verify the existing web parts I have tried to open the page in SharePoint designer. 

While opening the site in SharePoint designer 2007, I got the error saying as “This website has been configured to disallow editing with SharePoint designer.”I am having Site Collection Admin privileges over the site and having Farm Admin credentials on the server.

In my current site designer settings are disabled. In SharePoint 2013/2010 environments we can enable designer settings through SharePoint central Administration. But in SharePoint 2007 we have to enable through onet.xml file located in file system 12 hive.

To enable designer settings, Navigate to 12 hive templates folder located in C:\Program Files\Common Files\Microsoft Shared\Web Server Extentsions\12\Template\SiteTemplates \XML , (Here Site Templates is generic folder, Depending on site template we have to choose the folder)
Select  Onet.xml, Open it with any text editor. Check for “<Project Title” tag and Remove “DisableWebDesignFeatures=wdfopensite” text. Save Onet.xml file and Reset IIS by running IISRESET command.

By removing the text from Onet.xml file we can enable editing through designer. But to update this change in Onet.xml file we need to have farm admin permissions on the farm.

Hope this helps.

Tuesday, September 16, 2014

SharePoint content type error “The content type is in use”

One of my project from recent times I was worked on content hub to manage the content types in SharePoint. While changing the content type name, I got an error saying that “The content type is in use” as shown the image below.

I have checked all the content types in current site, I haven’t seen any content type with the current name. By checking few blogs like mavention and sympmarc I got the reasons for this error.

There many reasons for this issue as listed below,

Content type still exists in Site: Even we can’t see the content type in SharePoint content type gallery, it may exists in Recycle Bin (Site Recycle Bin or Site collection Recycle Bin). We have to remove the content type from Recycle Bin too. To remove the content type from Site Collection Recycle Bin, we need to have Site Collection privileges on Site Collection.

Other users might have associated anywhere? There is another chance that other users might have associated with the content type that we can’t see. We can see this behavior in SharePoint document libraries. We can check this by navigating to SharePoint Library settings and click on Manage Check out files. We can see the list of items belongs to other users. If it ok, take the owner ship of the items and check-in them.

Minor Versions:  We have one more possibility that there are some items may checked-in with minor versions in the List/Library. We have to check the appropriate items and need to publish the items with major versions.
This may helps.

Wednesday, September 10, 2014

Check SharePoint service status using SharePoint object model

By using SharePoint object model we can retrieve the User Profile Service information like User Profiles and user group details from UserProfileManager class. Some times we can see “UserProfileApplicationNotAvailable” error. We can check service availability details using following code block.

public bool IsCurrentServiceisInStart(string serviceName)
    bool currentServiceisInStart = false;

    SPService currentService = SPFarm.Local.Services.FirstOrDefault(s => s.TypeName.Equals(serviceName));

    if (currentService!= null )
        SPServiceInstance serviceInstance  = service.Instances.FirstOrDefault(i => i.Status == SPObjectStatus.Online);
        If(serviceInstance !=null)

    return currentServiceisInStart;


We can check the current service from SharePoint local services by mentioning the service application details as “SPFarm.Local.Services.FirstOrDefault” command in Linq.

We can use this code block while calling SharePoint service application. Hope this will help.

Sunday, September 7, 2014

SharePoint – Back to basics – Impersonate user programmatically

In SharePoint custom development activities, we have to impersonate the user to view SharePoint contents. To impersonate user in SharePoint we need to have the account that having privileges (generally in Run with elevated privileges “System Account” will be used) or user tokens.
To handle with System Account, we can use following code block,

SPSite parentSite = new SPSite(siteURL);

SPUserToken systemToken = parentSite.SystemAccount.UserToken;

using (SPSite site = new SPSite(siteURL, systemToken))
    using (SPWeb web = site.OpenWeb())
        // Code to be run

We can impersonate the by using following code by getting the user token of the user to switch as shown the code below,

SPUserToken userToken = web.AllUsers[user].UserToken;

// Create an SPSite object in the context of the user
SPSite site = new SPSite(siteURL, userToken)
SPWeb web = site.OpenWeb();

//Add code here.

To run this code, we need to run the code System account

SharePoint custom workflow send email task error: The e-mail message cannot be sent. Make sure the email has a valid recipient

While working with SharePoint custom workflow with Send email task, i am seeing “The e-mail message cannot be sent. Make sure the email has a valid recipient” error in workflow history list every time workflow fired. I was in a confusion that why I am seeing that every time.

Very first time designing workflow I have left all properties for “Send Mail” task empty as I am sending emails through code without interacting any property in Send mail task. I have updated all the properties by creating new Field Properties in the code. But still seeing the same error in workflow history list.

By checking few posts, the error may cause because of two reasons,
  • ·         There is no e-mail in Active directory for system Account.
  • ·         Getting null values for existing properties as not assigning the values.

Here in my case iam getting null values from field properties. So I have updated a dummy email in To field as I am not using the the property anywhere in the code.

Hope this will helps.

Thursday, September 4, 2014

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.

Wednesday, September 3, 2014

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.

Sunday, August 31, 2014

SharePoint 2013 – office 365 site save site as template error

In Office 365 site, to save customized site as template we can’t have save site as template option as we don’t even activate publishing feature. For example, I have created a site in office 365 environment and added some third party customized features like twitter and tried to save the site as template by navigating to Site settings. Bu I am unable to find “Save site as template” option in site settings page.

While troubleshooting the issue I have checked few posts in msdn and tech net forum. By checking all the posts I have found that SharePoint doesn't allow to save the third party apps. By removing the third party apps, i am able to save the site as template. But I need the third party app should be include in my sub site.

By checking few more posts I got a trick for this. To enable save site as a template in site settings page, we have to set “SaveSiteAsATemplateEnabled” parameter in office 365 site. To do that, open the site in SharePoint designer in homepage, click on “Site Options” link.

We can get a pop up box with four tabs. In Parameters tab, find for “SaveSiteAsATemplateEnabled” and update the value from false to true.

Saturday, August 30, 2014

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.

Monday, August 11, 2014

SharePoint 2013 workflow compiling error: Workflow XAML failed validation

While working with SharePoint workflow, I got compilation error in Start a task process activity. By clicking the error (clicking on the top “check errors button”) I don’t see any issues. When publishing the workflow I got the error saying that “Microsoft.Workflow.Client.ActivityValidationException: Workflow XAML failed validation: Cannot set unknown member CompositeTask.RelatedContentLinkListItemIntegerId’. HTTP headers received from the server”

Iam unable to publish the WF in SharePoint designer with my credentials and My friends credentials. To fix the issue, I have checked in to issue and found the fix in following blog and MSDN

To fix the issue, we have to register workflow service using following command

Register-SPWorkflowService -SPSite 'MySiteURL’ –WorkflowHostUri ‘Site URL' -AllowOAuthHttp –Force

Hope this helps.

Sunday, August 10, 2014

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.

Saturday, July 26, 2014

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.

Thursday, July 24, 2014

SharePoint Managed Accounts error: Managed Account could not be deleted because other objects depend on it.

After deleting all the service applications and managed account from SharePoint server by using following PowerShell commands,

Get-SPManagedAccount | Where-Object {$_.UserName -eq "Domain\Username"} | Remove-SPManagedAccount

By running the command I got an error saying that,

Remove-SPManagedAccount : An object in the SharePoint administrative framework, “SPManagedAccount Name=managed-account-S-1-5-21-2912393494-653453454-43454533245-4324″, could not be deleted because other objects depend on it. 

We can see this error because the service error we are going to delete is having dependencies. In my case iam using same account for User Profile Service.

By using following commands, we can release the dependencies on the service account.

Get-SPServiceApplicationPool | Where-Object {$_.Name -eq "User Profile Service"} | Remove-SPServiceApplicationPool

After running the command we have to delete the account by running the following command,

Get-SPManagedAccount | Where-Object {$_.UserName -eq "Domain\Username"} | Remove-SPManagedAccount

Hope this helps.

SharePoint – Delete Orphaned sites using PowerShell commands

We can delete the orphaned site in SharePoint environment that we are trying to provision the project server application. To remove orphaned site we have to un-provisioned and then delete the site.

We can delete the site by using following PowerShell commands,

Get SharePoint service application by using Get-SPServerviceApplication command
We can see the list of GUID’s. Get the service application specific to the orphaned site by using get-spserviceapplication command

$serviceApp = Get-SpServiceapplication | ? {$_.Id -eq "GUID of the Service App"}

Get the Site collection by using the service app

 $siteCollection = $serviceApp.SiteCollection

Get the site from Site Collection and delete the site by using the following commands,

$site = $siteCollection.Sitecollection | where {$_.SiteID -eq "< Guid>"}

Wednesday, July 16, 2014

SSRS report – SharePoint list error: an error occurred when accessing the specified SharePoint list. The connection string might not be valid

While creating the report by using SharePoint list, I got an error saying that “an error occurred when accessing the specified SharePoint list. The connection string might not be valid” as shown the image below.

I have checked all the possibilities for the error by changing the credentials in the report. It didn’t worked for me. Changed the connection string URL. Restarted BI development studio and Restarted Reporting services and finally restarted the machine too... No luck. L
By checking more than half day I have found the cause. The reason is, I have changed my VPN password recently and disabled UAC in my machine. So by connection the site, it is using my old password stored in windows vault.

We have to change the stored credentials in windows vault by using the steps below,
Navigate to Windows vault and in Windows credentials section select the site and update the credentials.

Now Iam able to access the list from SharePoint list  

Saturday, July 5, 2014

PowerShell Commands: Download files/documents from SharePoint document libraries

In SharePoint 2013 we have an option to sync all the data from SharePoint document libraries to local folders by using Shared drive concept. We can download the document s from SharePoint document library using Power Shell commands also. We can do that in overall site collections and all the site collection may contain loads of documents and downloading one by one is a huge task by using windows explorer.

To download the document we can use following script,

$listUrls="Doc lib 1 URL″,” Doc lib 2 URL ″,” Doc lib 3 URL ″," Doc lib 4 URL ″ (All the document libraries URL’s)
#Enter the web site URL

$web = Get-SPWeb -Identity $webUrl

#Load all the list URLs in the web, Open the list URL.

foreach($listUrl in $listUrls)

#get the list URL

$list = $web.GetList($webUrl+”/”+$listUrl)

function DownloadDocuments{
    $folder = $web.GetFolder($folderUrl)
    foreach ($file in $folder.Files) {

#Ensure destination directory

        $destinationfolder = $destination + “/” + $folder.Url
        if (!(Test-Path -path $destinationfolder))
            $dest = New-Item $destinationfolder -type directory

#Download file

        $binary = $file.OpenBinary()
        $stream = New-Object System.IO.FileStream($destinationfolder + “/” + $file.Name)
        $writer = New-Object System.IO.BinaryWriter($stream)

#Download root folder documents

DownloadDocuments ($list.RootFolder.Url)
foreach ($folder in $list.Folders) {

#download all the documents in each sub folders


Tuesday, June 24, 2014

SharePoint search error: Application server administration job failed for service instance Microsoft.Office.Server.Search.Administation.Search

While working with SharePoint Search, I got an error saying that “Application Server Administration job failed for service instance Microsoft.Office.Server.Search.Administration.SearchServiceInstance”.

I have changed the service application user instances and reset the index to be crawled. 
Tried to create a new search application with same search crawls and indexes. But neither was worked in my case. Digging into deep I have found this blog explain the cause and solution for problem.

We can get this error when configuration DB having older data than file system data in front end server. We can fix this issue by using the steps below,

  • Navigate to windows service and stop SharePoint Timer Services, Open SharePoint cache folder located in “C:\Documents and Settings\All Users\Application Data\Microsoft\SharePoint\Config”. Check for Config.ini file, Backup the file.
  • Delete all XML configuration files in GUID folder other than Config.ini file and double click on Cache.ini file. Select all the data and click n delete. Enter “1” (number 1), save and close the file. 
  • Start Windows SharePoint service.  Now file system will be re stored with all the configuration files in GUID folder.
It worked for me. Hope this helps.