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

No Project web app instances found. Create at least one PWA instance before accessing this page In Project Server 2016

In this article, I will fix the below Project Server 2016 issue

No Project web app instances found. Create at least one PWA instance before accessing this page


Scenario

After creating the PWA 2016 Site Collection, I have tried to browse it, but I got the below error

No Project web app instances found. Create at least one PWA instance before accessing this page

No Project web app instances found. create at least one PWA instance before accessing this page


Cause Continue reading “No Project web app instances found. Create at least one PWA instance before accessing this page In Project Server 2016”

Sorry, we were unable to open your project. Please try again. if this happens again, contact your administrator

In Project Server 2016 / 2013, In case you tried to open a project using Microsoft Project in Google Chrome, you will get the below error.

Sorry, we were unable to open your project. Please try again. if this happens again, contact your administrator

Sorry, we were unable to open your project. Please try again. if this happens again, contact your administrator


Cause Continue reading “Sorry, we were unable to open your project. Please try again. if this happens again, contact your administrator”

Count All Tasks in Project Server

In this article, I will explain How to

Calculate the Tasks count in Project Schedule in Project Server

Count All Tasks in Project Server

As shown above, the count of total tasks below the main Summary task is 6 Continue reading “Count All Tasks in Project Server”

Missing the “ADD TASK – EDIT LIST” Options in the Project Summary Web Part

In this post, I will explain

Why the “ADD TASK and EDIT LIST” options are missing in the Project Summary Web Part in Project Server?


Scenario

In Project Server 2013, I have a Project Site with the default Project Summary web Part,

In some project sites, I can find the option of “ADD TASK & EDIT LIST” as shown below:

Missing Add Task in Project Summary Web Part

But in other Project sites, I can’t find these options!

Missing the ADD TASK - EDIT LIST Options in the Project Summary Web Part


Cause

You should be aware of Continue reading “Missing the “ADD TASK – EDIT LIST” Options in the Project Summary Web Part”

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”