Automate Office 365 Health Status Monitoring Using PowerShell

A few days ago, many of the users of our SharePoint Online environment complained about not being able to access the portal and were getting a blank page when accessing on Internet Explorer. Now, since the site was accessible perfectly fine with Chrome browser, there was no way to suspect any issue from SharePoint Online side itself. First Thoughts We had implemented a redirection from an On-premise IIS site to SharePoint Online site using Smart Links. This was because, our business users wanted to use a known URL like https://mycompany.com to access the portal site, instead of https://mycompany.sharepoint.com and still […]

Continue Reading

Unable to open excel files in Office Web Apps – Another way out

OWA-Cert-Error-Featured

We had a SharePoint 2016 medium size farm (2 WFEs, 2 App Servers, 2 DB Servers & 2 OWA Servers) configured and running perfectly fine for a few months. Until one fine day, while opening Excel files in browser started throwing the below error – We’re sorry. We ran into a problem completing your request. Please try that again in a few minutes. Strangely, all other office file types (Word, PowerPoint) continued to work in browser without any issues. Update: As per Microsoft, this is a known issue (“System Center 2016 Operations Manager APM Agent causing heap corruption in SharePoint”) […]

Continue Reading

Query execution is only allowed with IgnoreSafeQueryPropertiesTemplateUrl=true when the user has the UseRemoteAPIs permission

Error Message

I had setup a cloud Hybrid Search environment for one of my customers with SharePoint 2016 and SharePoint Online. It was working fine for past few weeks, until one fine day for almost all the users started getting the error message “Microsoft.SharePoint.Client.ServerException: Query execution is only allowed with IgnoreSafeQueryPropertiesTemplateUrl=true when the user has the UseRemoteAPIs permission” when searched from on-prem environment. Cloud Hybrid and Federated Setup Just to share some background about the environment setup, I had followed the recommended approach for setting up the cloud hybrid environment and all the content was correctly getting indexed in Office 365. The […]

Continue Reading

Creating Publishing Site at SharePoint Online Root

Root Site

This requirement keeps on appearing every now and then that customers want their SharePoint Online root site collection to be based on Publishing Site Template instead of the default team site template that we get with Office 365 tenant. What’s the Problem When a new Office 365 tenant is created, the SharePoint online site gets a root URL like https://<tenant name>.SharePoint.com, which forms the entry point of the SharePoint online sites. By default, this site is based on team site template but most customers would prefer this as a publishing site so that they can create and nicely arrange multiple […]

Continue Reading

HTTP to HTTPS Redirection for Web Application on Azure VMs

Azure

Sometime ago, I wrote an article about how to achieve http to https redirection in Azure hosted VMs. That solution is still applicable if your Azure environment was built using Classic model and is using Cloud Services. Things are a bit different in Azure Resource Manager model and that’s for good, as it has become even easier to achieve the same. Problem Statement Let’s take a relook at what we are trying to solve here. You have web application (let’s say SharePoint, but this solution is valid for any other web application as well) hosted in Azure VMs, build using […]

Continue Reading

Azure QnA Chat Bot with Waterfall Forms Flow

Qna-Waterfall-2

In my previous articles about Azure Chat bot, I talked about how to create a QnA chat bot using MS QnA maker service and use forms flow for a waterfall like conversation within the chat bot. I found many fellow ‘cloudizens’  looking for a simple solution based on QnA template which starts with a greeting to the user and then continues as a default QnA chat bot, like this one. Problem With the default QnA template, you get something like this So, essentially a QnA Chat bot is just an unending sequence of your default dialog, which is expressed as […]

Continue Reading

Integrate Azure Chat Bot with SharePoint

BotWithSP-Featured

In my previous article, I wrote about how can we create an simple Azure chat bot based on one of the default template, Forms Flow, that Azure Bot comes with. That is good to get us started but to make anything useful, we need to extend the bot. In this article I am going to talk about how can we extend the Azure Chat bot with Forms Flow,  we created last time, and Integrate it with SharePoint. This logic can be used to integrate both with SharePoint on-premise (2013 and 2016) and Online. Problem Statement We are going to extend […]

Continue Reading

Azure Chat Bot with Interactive Forms Flow

FormsBot-Featured

A few days ago, I wrote articles about Create your first Azure Chat Bot – Step by Step followed by Configure LUIS application for practical use in Azure bot and Create your first Azure Chat Bot with QnA Service – Step by Step. In this article lets explore how can we create an Azure Chat Bot which can have an interactive forms flow, i.e. a bot which can accept information as if filling a form and take some action based on provided inputs like booking a flight ticket or raising a support request. Half of the steps are similar to what you might […]

Continue Reading

SharePoint Crawl Error- Processing this item failed because of a timeout

SearchError-Featured-1

A few days ago, suddenly in one of the SharePoint farms which my team maintains, after running fine for few months, it started logging the error message “SharePoint Crawl Error- Processing this item failed because of a timeout when parsing its contents” for almost all the content the crawler was trying to index. Background It was a medium size farm, with 2 front end servers, 2 application servers with 2 database servers configured with always on availability groups. The search crawl was schedule to with “Continuous Crawl” with “Incremental Crawl” every 4 hours. Initially we thought it might be a […]

Continue Reading

Azure Application Insights or Google Analytics with SharePoint

GA-vs-AAI

Recently I was encountered with a question about implementing Google Analytics in a SharePoint on-premise environment that triggered a discussion, whether we should choose Google Analytics or look for Azure Application Insights, which is available in Azure stack. Azure was in use already since SharePoint Servers were hosted on Azure VMs and the Application Insight reports look quite impressive. I started to look into more details about what to expect from both of these. Google Analytics Lets take a look at the Google Analytics first. Google analytics is intended for website usage tracking and traffic optimization, has a nice dashboard and is […]

Continue Reading