SharePoint + SQL Server AlwaysOn: Outage Troubleshooting

So you have a SharePoint/SQL outage despite having SQL Server AlwaysOn configured, and you naturally want to know why. Event IDs 5586 and 6398 are flooding the SharePoint servers and you don’t know why. On the SharePoint servers in the application log you might see either this: Unknown SQL Exception 10060 occurred. Additional error information…

0

SharePoint 2013 Crawl History Error

Just a quick one; if you’ve ever seen the error “Could not find Stored Procedure Search_GetRepositoryTimePerCrawl” when you click on “crawl history” in the SharePoint Search app then this fix could be for you. The Fix In short, you need to run the “Search Health Monitoring – Trace Events” timer-job which is likely disabled. This’ll…

0

Publishing SharePoint with Windows Server 2012 R2 Web Application Proxy

A new toy I’ve played around with recently is this new web-application proxy (WAP) role in Windows Server 2012 R2. I thought I’d write a quick post about setting up SharePoint 2013 with it because reverse proxying SharePoint applications is a good practise for publicly accessible SharePoint sites, and it’s good to share. Web Application…

4

SharePoint Search Service – Failover & Outage Resiliency

I thought I’d share some tests I’ve done on how much more resilient the new search engine is to server outages now in 2013 just because I’ve done some research on it just recently. It’s especially nice for consuming farms because there’s a nice abstraction from any server apocalypse going on in the service publishing…

0

SharePoint & SQL Server AlwaysOn Failovers – Video Demonstration

To demonstrate how SharePoint and SQL Server AlwaysOn work together, especially with a failover, I did a quick video to show it in action. Here it is, enjoy (https://www.youtube.com/watch?v=se_M1vdriMA if the embedded video doesn’t load): SharePoint 2013 with SQL Server AlwaysOn SQL Server AlwaysOn is a key tool in maintaining a high-availability SharePoint solution. More…

1

Building Multi-Level CAML Queries from GET Parameters in the URL

I had an interesting challenge just recently which was to perform multi-level queries on any given list dynamically using GET parameters to build the query. In other words, from a GET request, we should be able to search a list with multiple groups of ANDs & ORs just by changing the URL. You can of…

0

Setup Hybrid SharePoint Online + On-Premise Search Federation – A Quick Guide

In a hybrid SharePoint world a nice trick you can do is to merge search results from your on-premises SharePoint setup with your SharePoint Online sites – i.e. you search in one place (on-premise SharePoint for example) and see results for both places in the same search results list. It’s a little known fact that…

0

Troubleshooting SharePoint Event ID 6393

This event ID means “a SharePoint timer job had an unexpected failure” in short. Admittedly this isn’t overly informative given how many different timer-jobs there are for any given SharePoint farm. Your first challenge is therefore figuring out which job it’s talking about which shouldn’t be too hard given it gives you the class name…

1

Access Denied Crawling sps3 Content Source in SharePoint 2013

No User Profiles Being Crawled Another quick one. You might notice that no user profiles are being found when you search for them. If you take a look at crawl logs, you’ll probably this error in the crawl logs and think it’s related. You’d be right – no profiles & this error are very much…

2

How SharePoint 2013 Fits With Office Web Apps

Just a quick one. Since 2013, SharePoint integration with Office Web Apps has changed quite dramatically and has been the source of some confusion so I hope to make it 100% clear here. In short, Office Web Apps is now it’s own standalone server product in its’ own right that needs its’ own separate server(s)…

1