Pages

Friday, December 27, 2013

Enable Sharepoint 2013 workflow in Office 365 Sharepoint


I was unable to find and create the SharePoint 2013 workflow using SharePoint designer for office 365 SharePoint site and I got the following message that “The option for the SharePoint 2013 workflow platform is not available because the workflow service is not configured on the server. Please contact your server administrator”


 

Finally found that reference link and it says that have to enable “Preview features” in SharePoint online Admin center setting page and it worked for me J

Wednesday, December 25, 2013

Email Address not mapped in SharePoint 2013 user profile Service


I was configured the user profile service with user profile synchronization service in SharePoint 2013. I was unable to find users Email address after done the user profile Synchronization with Active Directory. So whenever tried to set an email alert in the SharePoint site got “you don’t have email address”.

Cause:
Finally found the cause for the issue that Work Email address user property not mapped with AD mail property.

Resolution:
So I have mapped the user profile property of Work Email with Mail AD attribute in the User profile property. Below is the steps to configure

Go to central admin-> Manager Service application-> User profile Service Application-> Click Manage User properties-> Find and Edit “Work Email” property under contact information-> Remove the existing mapped AD attribute and Map the AD Attribute of “Mail” for this Work Email property and Save and close.
Finally do the AD synchronization and now you could see the Users Email address J

Monday, December 2, 2013

Sharepoint 2013 cumulative updates takes long time to install


When I was installing cumulative update of March month was taken more than 3 hours but it was not completed and I was stopped the installation of cumulative update and finally found the below script from the following link http://blogs.msdn.com/b/russmax/archive/2013/04/01/why-sharepoint-2013-umulative-update-takes-5-hours-to-install.aspx which saved my time and I want to thanks Russ Maxwell.

Below is the script and save and run it on the server.

###########################

 ##Ensure Patch is Present##

 ###########################

 $patchfile = Get-ChildItem | where{$_.Extension -eq ".exe"}

 if($patchfile -eq $null)

 {

  Write-Host "Unable to retrieve the file.  Exiting Script" -ForegroundColor Red

  Return

 }

########################

 ##Stop Search Services##

 ########################

 ##Checking Search services##

 $srchctr = 1

 $srch4srvctr = 1

 $srch5srvctr = 1

$srv4 = get-service "OSearch15"

 $srv5 = get-service "SPSearchHostController"

If(($srv4.status -eq "Running") -or ($srv5.status-eq "Running"))

  {

    Write-Host "Choose 1 to Pause Search Service Application" -ForegroundColor Cyan

    Write-Host "Choose 2 to leave Search Service Application running" -ForegroundColor Cyan

    $searchappresult = Read-Host "Press 1 or 2 and hit enter" 

    Write-Host
 
   if($searchappresult -eq 1)

    {

        $srchctr = 2

        Write-Host "Pausing the Search Service Application" -foregroundcolor yellow

        Write-Host "This could take a few minutes" -ForegroundColor Yellow

        $ssa = get-spenterprisesearchserviceapplication

        $ssa.pause()

    }
 
    elseif($searchappresult -eq 2)

    {

        Write-Host "Continuing without pausing the Search Service Application"

    }

    else

    {

        Write-Host "Run the script again and choose option 1 or 2" -ForegroundColor Red

        Write-Host "Exiting Script" -ForegroundColor Red

        Return

    }

  }

 Write-Host "Stopping Search Services if they are running" -foregroundcolor yellow

 if($srv4.status -eq "Running")

  {

    $srch4srvctr = 2

    set-service -Name "OSearch15" -startuptype Disabled

    $srv4.stop()

  }


if($srv5.status -eq "Running")

  {

    $srch5srvctr = 2

    Set-service "SPSearchHostController" -startuptype Disabled

    $srv5.stop()

  }


do

  {

    $srv6 = get-service "SPSearchHostController"

    if($srv6.status -eq "Stopped")

    {

        $yes = 1

    }

    Start-Sleep -seconds 10

  }

  until ($yes -eq 1)

 

Write-Host "Search Services are stopped" -foregroundcolor Green

 Write-Host
 

#######################

 ##Stop Other Services##

 #######################

 Set-Service -Name "IISADMIN" -startuptype Disabled

 Set-Service -Name "SPTimerV4" -startuptype Disabled

 Write-Host "Gracefully stopping IIS W3WP Processes" -foregroundcolor yellow

 Write-Host

iisreset -stop -noforce

 Write-Host "Stopping Services" -foregroundcolor yellow

 Write-Host
 

$srv2 = get-service "SPTimerV4"

  if($srv2.status -eq "Running")

  {$srv2.stop()}


Write-Host "Services are Stopped" -ForegroundColor Green

 Write-Host

 Write-Host
 

##################

 ##Start patching##

 ##################

 Write-Host "Patching now keep this PowerShell window open" -ForegroundColor Magenta

 Write-Host

 $starttime = Get-Date
 

$filename = $patchfile.basename

 $arg = "/passive"
 

Start-Process $filename $arg
Start-Sleep -seconds 20
 $proc = get-process $filename

 $proc.WaitForExit()

 

$finishtime = get-date

 Write-Host

 Write-Host "Patch installation complete" -foregroundcolor green

 Write-Host
 

##################

 ##Start Services##

 ##################

 Write-Host "Starting Services Backup" -foregroundcolor yellow

 Set-Service -Name "SPTimerV4" -startuptype Automatic

 Set-Service -Name "IISADMIN" -startuptype Automatic

##Grabbing local server and starting services##

 $servername = hostname

 $server = get-spserver $servername

$srv2 = get-service "SPTimerV4"

 $srv2.start()

 $srv3 = get-service "IISADMIN"

 $srv3.start()

 $srv4 = get-service "OSearch15"

 $srv5 = get-service "SPSearchHostController"

###Ensuring Search Services were stopped by script before Starting"

 if($srch4srvctr -eq 2)

 {

    set-service -Name "OSearch15" -startuptype Automatic

    $srv4.start()

 }

 if($srch5srvctr -eq 2)

 {

    Set-service "SPSearchHostController" -startuptype Automatic

    $srv5.start()

 }

###Resuming Search Service Application if paused###

 if($srchctr -eq 2)

 {

    Write-Host "Resuming the Search Service Application" -foregroundcolor yellow

    $ssa = get-spenterprisesearchserviceapplication

    $ssa.resume()
 }
Write-Host "Services are Started" -foregroundcolor green

 Write-Host

 Write-Host

 Write-Host "Script Duration" -foregroundcolor yellow

 Write-Host "Started: " $starttime -foregroundcolor yellow

 Write-Host "Finished: " $finishtime -foregroundcolor yellow

 Write-Host "Script Complete" 

Wednesday, November 27, 2013

Unable to unlock by using stsadm/powershell and central admin


The site was locked and I was tried to unlock the site using stsadm and powershell commands in sharepoint 2013 but didn’t worked.

Finally I found below PowerShell from the MS forum to unlock the site and it got worked.

$Admin =  new-object Microsoft.SharePoint.Administration.SPSiteAdministration('http://root.toto.com')

$Admin.ClearMaintenanceMode()

$site.MaintenanceMode

 

NOTE: The above commands will work only if your SharePoint 2013 April cumulative update installed

Monday, November 11, 2013

Extract SharePoint farm solutions of SharePoint 2010 and MOSS


Extract or exporting SharePoint 2010 farm solution using PowerShell

Run the below PowerShell to Extract all solutions from the SharePoint farm.

(Get-SPFarm).Solutions | ForEach-Object{$var = (Get-Location).Path + "\" + $_.Name; $_.SolutionFile.SaveAs($var)}

Extract or Exporting SharePoint 2007 farm solutions:
                                                                                                 I was used SharePoint farm solution extractor to extract SharePoint 2007 farm solutions using the below command and link

SharePointFarmSolutionExtractor.exe -extractAll c:\SharePointSolutions

SharePoint web application not created on SharePoint web front servers


While I was creating a new web application in SharePoint 2013 farm environment, I got a “page cannot be displayed” message in the site creation page and the web application was created only on the central admin Server and not all other SharePoint farm machine.

I was restarted the machine to fix the issue and ran the timer job execution stsadm command but it didn’t worked and finally I got a solution from one of the blog that to increase value of “Shutdown Time limit” for SharePoint Central admin site application pool from default value of 90 Seconds to 300 Seconds and done the IISRESET and then created a new web application and got worked

Monday, September 23, 2013

Creating SQL Server Alias without installing SQL client Tool


Normally we have to install SQL client tool to create SQL Server alias on the SharePoint Servers and Now you can create a SQL server alias without installing SQL server client connectivity tool using SQL server client network utility tool.
Steps:
a.       Start-> Run-> cliconfg.exe and it will open SQL server Client network utility tool


Click Alias and Click add for creating SQL server alias and Give the SQL alias name, Select TCP/IP and port no and click ok. Now we have successfully created the SQL server alias.