User Profile Sync Application Service Issue

Topics: General Questions, Support
Dec 20, 2013 at 2:46 PM
Hello-

I'm having an issue when running the scripts and getting to the part where the scripts create the User Profile Sync Service Application. Not sure what my issue is exactly but the script seems to keep trying to remote into itself when it is already remoted in.

I have been playing with the settings to see if maybe i have something incorrect. But in reading the comments and all kinds of articles i'm a little stuck for what my issue might be.

Some questions:
  1. If i have a web application setup for the mysites do i need ANY entry in the "Mysite Host Location" and "Mysite Managed Path" locations of the UPS Application XML config? (I'm not trying to create default sync connection since not fully supported and will do after the scripts are fully executed)
  2. I'm using a single AutoSPInstallerInput file and deploying to multiple servers. I'm running the script from 001 (the other servers are 002 and 003). 001 is my WFE and 002/003 are Application Servers for the services. The UPS Application is going to run on 002. In general - Should i be using one file or using separate files for each host? If so, are they invoked from a single server or do i invoke on each server separately?
Thanks,
Greg
Dec 21, 2013 at 12:32 AM
Edited Dec 21, 2013 at 12:33 AM
Actually i moved a little further....

So, when running all of this stuff remote (for example 3 SharePoint servers 001WFE,002APP,003APP). I start the main script by running from 001WFE and then after the remote calls are made from 001WFE to 002APP and 003APP using PSexec the pre-reqs run and the SP installer runs (all still showing on 001WFE). Then it tries to do a remote restart, which fails. It then asks to force and that fails. So i manually have to reboot the 002APP and 003APP servers. Once they show back online I then log in to those machines using the SP Installation account. I see that the scripts then kick off on each of those servers automatically! Very nice! But my next problem.....

On 003APP is where i'm trying to get the User Profile Service to run and it keeps failing....

The file that is in error has the following code - i'm not sure the format on line 3 is correct, should parameters be in "" like the value of -ProfileDBServer, etc? Should it say System.Collections.Hashtable at the end of the line? Doesn't seem right.
New-SPProfileServiceApplication : A positional parameter cannot be found that accepts argument
'System.Collections.Hashtable'.
At C:\Users\SPINSTALL_D\AppData\Local\Temp\2\AutoSPInstaller-ScriptBlock.ps1:3 char:25
+ $newProfileServiceApp = New-SPProfileServiceApplication -Name "User Profile Serv ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidArgument: (:) [New-SPProfileServiceApplication], ParameterBindingException
    + FullyQualifiedErrorId : PositionalParameterNotFound,Microsoft.Office.Server.UserProfiles.PowerShell.SPCmdletNewP
   rofileServiceApplication

C:\Users\SPINSTALL_D\AppData\Local\Temp\2\AutoSPInstaller-ScriptBlock.ps1 :  - Failed to create User Profile Service
Application
At line:1 char:1
+ C:\Users\SPINSTALL_D\AppData\Local\Temp\2\AutoSPInstaller-ScriptBlock.ps1
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [Write-Error], WriteErrorException
    + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,AutoSPInstaller-ScriptBlock.ps1
Write-Host -ForegroundColor White "Creating User Profile Service Application as DOMAIN\SPFARM_D..."
Add-PsSnapin Microsoft.SharePoint.PowerShell
$newProfileServiceApp = New-SPProfileServiceApplication -Name "User Profile Service Application" -ApplicationPool "SharePoint Hosted Services" -ProfileDBServer DBSQL2012DEV -ProfileDBName SP2013_Profile -ProfileSyncDBServer DBSQL2012DEV -ProfileSyncDBName SP2013_Sync -SocialDBServer DBSQL2012DEV -SocialDBName SP2013_Social -MySiteHostLocation http://mysites-dev.domain.com:80 System.Collections.Hashtable
If (-not $?) {Write-Error " - Failed to create User Profile Service Application"; Write-Host "Press any key to exit..."; $null = $host.UI.RawUI.ReadKey("NoEcho,IncludeKeyDown")}
$profileDBId = Get-SPDatabase | ? {$_.Name -eq "SP2013_Profile"}
Add-SPShellAdmin -UserName "DOMAIN\SPINSTALL_D" -database $profileDBId
$socialDBId = Get-SPDatabase | ? {$_.Name -eq "SP2013_Social"}
Add-SPShellAdmin -UserName "DOMAIN\SPINSTALL_D" -database $socialDBId
As of now i'm stuck on creating the User Profile Service. Any help would be really appreciated!

Thanks,
Greg
Jan 8, 2014 at 10:35 PM
Hey Greg,

Have a look at this post https://autospinstaller.codeplex.com/workitem/20447 I had the same issue and it resolved it.

Cheers
Alexander
Feb 3, 2014 at 12:28 PM
Edited Feb 3, 2014 at 12:30 PM
Thank you Alexander, I was able to get past this a few weeks back. I believe that post would have fixed things for me. I think there are some sharp differences in running the installer between "All-in-One" vs. Distributed Infrastructure vs. Distributed Infrastructure with Defined SP roles (WFE/APP). I was able to fix by using the options below and then manually going into CA and starting/setting up the User Profile Synch Service.


UPS .0023 Screen

http://postimg.org/image/7dd893tr7/

I will confirm my setup/configuration when we run similar through our test install and we are split roles and larger environment.

Thanks,
Greg