Recently I was building a new SharePoint 2016 farm and came across the below error with older PowerShell SharePoint 2013 install scripts. Expected error as Microsoft moved the functionality to Office Online Server. Cheers!
The term ‘New-SPExcelServiceApplication’ is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.
Microsoft removed the Excel Service Application from SharePoint Server.
Office Online Server has the functionality going forward.
Recently I came across the error below when upgrading a SharePoint 2016 farm. Expected product behavior and simply a case of training SharePoint Administrators to use PSCONFIG.EXE command line instead. Cheers!
Command line error.Invalid parameter.
stsadm–oupgrade command has been replaced by psconfig.exe-cmdupgrade
Recently I wanted to create a SharePoint 2016 lab environment. With Excel Services moving out of the SharePoint 2016 product, we now need to plan for an instance of OOS. Below are the steps I followed and screenshots of the process.
Install Windows Server 2012 R2 (en_windows_server_2012_r2_with_update_x64_dvd_6052708.iso)
NOTE – Windows Server 2016 seems to be missing Ink and Handwriting Support.
Run PowerShell to install IIS
# from https://docs.microsoft.com/en-us/officeonlineserver/deploy-office-online-server
The latest version (0.42) includes new PowerShell code for parallel execution of “Upgrade-SPContentDatabase.” This was implemented with “Get-Job” and PowerShell job management to remote sessions.
The more user content databases you have, the greater the time savings. Below are summary statistics from patching a 9 server SharePoint 2013 farm with 200 SQL content databases in just 4 hours. Each of the 9 servers will spawn 4 PowerShell remoting runspaces for “Upgrade-SPContentDatabase.” With 36 concurrent worker threads, the queue of 200 content databases now becomes only 6 deep.
Instead of waiting 200 units of time to process content databases serially, we now only wait 6 units of time for the upgrade database phase.
Larger farms with more user content (and databases) will see significant overall time savings considering how a majority of the traditional patching timeline is processing all content databases. The binary EXE phase runs with all content databases removed (Dismount-SPContentDatabase ) so PSCONFIG can complete sooner. After that is done, content is introduced again (Mount-SPContentDatabase) and upgraded (Upgrade-SPContentDatabase).