Search Host Controller Service ‘Starting’ does not start

I’ve tried everything from Registry Permissions to unprovisioning search and recreating search. Finally i found the solution. Do not use port 808 for any Web App. Apparently Windows Communication Foundation Service uses port 808 and Search SP 2013 Host Controller uses WCF.

 ULS logs had “Could not connect to net.tcp://server/ceres/hostcontroller/nettcp” …. and “connected host has failed to respond XX.XXX.XXX.XX:808”

I had to extend that site to another port then delete the IIS Web app that was using port 808.

Change BCS throttle limit of 2000 rows

One of my developers was getting a connection timeout on using an External Content Type. The real problem was that BCS has a limit of 2000 rows returned in a query. Here’s a PowerShell script to edit that limit:

$wthbcs = Get-SPServiceApplicationProxy | where{$_.GetType().FullName -eq (‘Microsoft.SharePoint.BusinessData.SharedService.’ + ‘BdcServiceApplicationProxy’)}

 $BCSThrottle = Get-SPBusinessDataCatalogThrottleConfig -Scope database -ThrottleType items -ServiceApplicationProxy $wthbcs


 Set-SPBusinessDataCatalogThrottleConfig -Identity $BCSThrottle -Maximum 1000000 -Default 20000