Posts

Showing posts from February, 2020

Distribute Cache Service Started throwing CacheHostInfo is null exception

Image
Distribute Cache Service Stopped working After Renaming Windows After renaming Windows server name, Distributed Cache server started throwing error “CacheHostInfo is null” while trying to start service.  Background: I've created a Single Server Farm for testing purpose and decided to make it live with Smallest Min Role farm configuration. So I've performed following steps: Renamed the Windows name to New name. Configured SharePoint farm successfully with new name. Run  Remove-SPDistributedCacheServiceInstance command to remove Distributed cache service. Converted Server Role from Single Server to Application with Search Added WFE server with Web Front End with Distributed Cache role. Tried to start Distributed Cache service on new server. here comes the problem it started throwing error CacheHostInfo is null. And in Get-CacheHost return old server name was displayed. Resolution: As it was pointing to old server name so created old server name entry in

Installation and Configuration of Office Online Server with SharePoint 2019

Image
Installation and Configuration of Office Online Server In this blog post I'm going to show you how to install and configure Office Online Server(OOS) farm and then configure OOS Farm with SharePoint to display Word, Excel etc in web browser. Install prerequisite software for Office Online Server https://docs.microsoft.com/en-us/officeonlineserver/deploy-office-online-server Open the Microsoft PowerShell prompt as an administrator and run this command to install the required roles and services Add-WindowsFeature Web-Server,Web-Mgmt-Tools,Web-Mgmt-Console,Web-WebServer,Web-Common-Http,Web-Default-Doc,Web-Static-Content,Web-Performance,Web-Stat-Compression,Web-Dyn-Compression,Web-Security,Web-Filtering,Web-Windows-Auth,Web-App-Dev,Web-Net-Ext45,Web-Asp-Net45,Web-ISAPI-Ext,Web-ISAPI-Filter,Web-Includes,NET-Framework-Features,NET-Framework-45-Features,NET-Framework-Core,NET-Framework-45-Core,NET-HTTP-Activation,NET-Non-HTTP-Activ,NET-WCF-HTTP-Activation45,Windows-Identi

Displaying Charts using data in Excel and Chart.js library

Image
Displaying Charts using data in Excel and Chart.js library This document explains the requirements to create and display Charts on SharePoint Page by fetching data from Excel Sheets and displaying it in beautiful Charts generated using Chart.js library. You might think why we need to do this much coding as we can directly display Excel webparts on page and display charts generated from Excel. But Excel Web parts depends on Excel Service Application to be running in Farm and this Service is not available in Standard version of SharePoint 2013. Also Excel webpart are very heavy webparts as it tries to load Excel functionality in browser. Get started with some background I had a requirement to display multiple charts from Excel on SharePoint page as our Excel was very heavy approx. 5MB size so it was slowing the performance of page. So I come up with angular based project to display chart using Chart.js library. In this project I’ve used following libraries: JQuery.mi