SharePoint 2016: Failed to create the configuration database. An exception of type Microsoft.SharePoint.Upgrade.SPUpgradeException was thrown

In this article, I will solve the below SharePoint 2016 Configuration Wizard issue

Failed to create the configuration database.
An exception of type Microsoft.SharePoint.Upgrade.SPUpgradeException was thrown. Additional exception information: One or more types failed to load. Please refer to the upgrade log for more details.


Scenario

Unfortunately, I didn’t have an internet connection on the SharePoint Servers to can install the SharePoint 2016 Prerequisites over the internet automatically.

So I went to install the SharePoint 2016 Prerequisites offline that has been installed properly and the SharePoint installation has been started without any complaint.

Once the SharePoint 2016 installation is finished, I tried to run the SharePoint 2016 Configuration wizard to configure the SharePoint 2016 farm. Continue reading “SharePoint 2016: Failed to create the configuration database. An exception of type Microsoft.SharePoint.Upgrade.SPUpgradeException was thrown”

Advertisements

Resolve “Missing Site Templates SharePoint 2013 Upgrade Error”

SharePoint is a popular component of Microsoft Office 365. SharePoint offers services like file hosting, collaboration facility, document management, and many more. SharePoint has earned popularity because it can be easily integrated with Outlook Web App, Office 365 Groups, and Yammer.

Resolve “Missing Site Templates SharePoint 2013 Upgrade Error”

However, SharePoint users sometimes face errors that badly hinder its functionality. Some of the common SharePoint errors are missing site template error, missing site definition error, correlation ID error, missing feature error, etc. For this post, “SharePoint missing site templates error” has been chosen for discussion. Readers will learn to fix missing site templates SharePoint 2013 upgrade Error. To begin with, we will know what is SharePoint site template.

What is Site Template in SharePoint?

Continue reading “Resolve “Missing Site Templates SharePoint 2013 Upgrade Error””

Can’t Import SpreadSheet to SharePoint List: The specified file is not a valid spreadsheet or contains no data to import

In this blog, I will show How to solve the below import Excel sheet issue in SharePoint

The specified file is not a valid spreadsheet or contains no data to import


Scenario

I have an Excel file as shown below,

The specified file is not a valid spreadsheet or contains no data to import

I have tried to import this Excel file to SharePoint using Import spreadsheet feature

The specified file is not a valid spreadsheet or contains no data to import

But unfortunately, I got this error

The specified file is not a valid spreadsheet or contains no data to import

The specified file is not a valid spreadsheet or contains no data to import


Cause

Continue reading “Can’t Import SpreadSheet to SharePoint List: The specified file is not a valid spreadsheet or contains no data to import”

Show SharePoint Document Library files with folders and subfolders in SSRS

In this article, I will explain

How to show a SharePoint Document Library files with folders and subfolders in SSRS recursively

 

Show Recursive Document Library files with folders and subfolders in SSRS


Scenario

I have a SharePoint Document Library with multiple folders and subfolders as shown below:

Show Recursive SharePoint Document Library files with folders and subfolders in SSRS.gif

I have tried to retrieve all files, folders, and subfolders from this Document Library in Reporting Service (SSRS) report, but unfortunately, it doesn’t recursively read all the subfolders and files, it only read the root folder and files as shown below:

Document Library

Show Recursive Document Library files with folders and subfolders in Reporting Service

SSRS report

Show Recursive Document Library files with folders and subfolders in SSRS Continue reading “Show SharePoint Document Library files with folders and subfolders in SSRS”

Project Server: Your session became invalid because this project was also opened in another browser

In this article, I will show How to solve the below issue

Your session became invalid because this project was also opened in another browser

Your session became invalid because this project was also opened in another browser


Scenario

In Project Server 2013, when I tried to open a project schedule PDP as the following:

Your session became invalid because this project was also opened in another browser

Continue reading “Project Server: Your session became invalid because this project was also opened in another browser”

Auto-Populate List Form Fields Based On Lookup Selection In SharePoint

In this article, I will show

How to populate the new form fields like (Lookup field, People and Group Field) based on the selected lookup field value?


Scenario

I have two lists, One list has a lookup field called “Issue ID” that holds the ID from the second List as shown below

First List

Auto Populate List form fields based on Lookup Selection In SharePoint

Second List

Autofill List form fields based on Lookup Selection In SharePoint

When adding a new item, I would like to populate the Issue name based on the selected lookup issue ID as shown below.

Auto Populate List form fields based on Lookup Selection In SharePoint


Continue reading “Auto-Populate List Form Fields Based On Lookup Selection In SharePoint”

SharePoint 2016: Show a List From Parent Site In Sub Site

In this article, I will Show

How to display a SharePoint list from Parent site in Sub Site?

Scenario

In SharePoint 2016, I have a list in the parent site, I would like to show this list inside a page in the subsite.

So that when adding a new item to this list from the subsite, it should also be listed in the same original list in the parent site and vice versa.

Note: You can use the same steps to display a SharePoint list from subsite in parent site.

Continue reading “SharePoint 2016: Show a List From Parent Site In Sub Site”