Cannot display the webpage while creating a Web Application in SharePoint

I was creating my fifth Web Application in our SharePoint 2013 test environment when I received the following error during creation:

“Internet Explorer cannot display the webpage”

image

Microsoft has published an article related to this issue in SharePoint 2010 http://support.microsoft.com/kb/2543306.

Cause (from Microsoft)

As more and more web applications are created, the time in which it takes to create a web application increases. As part of the creation process, IIS is reset and by default, the application pool allows 90 seconds for the connections to close off before forcibly shutting down. When the number of web applications grows above 10, 90 seconds is not enough time for the provisioning to finish.

Resolution (from Microsoft)

The solution to this is to allow the process a longer amount of time before it is forcibly shutdown.

  • On the server(s) hosting Central Admin, open IIS manager.
  • In the tree view, expand the server name and click on Application Pools.
  • Locate the SharePoint Central Administration v4 application pool. Right click on it and choose Advanced Settings.
  • In the Process Model section, set the Shutdown Time Limit to a greater value. As an example, 300.
  • Restart IIS.

SharePoint 2010 Web Analytics customize report date shows 1/0/1900

Issue

The dates in the Excel Sheet are 1/0/1900 when creating a customize report for example the report of the Number of Daily Unique Visitors.

image

Solution

The solution is quite simple because you only need to verify a few things and maybe start a few services.

– Verify that the following service applications have been started/installed

  • Excel Services Application
  • State Service
  • Usage and health data collection
  • Web Analytics Service Application

– Verify that the trusted file location in Excel Services Application has ‘Allow user-Defined functions’ enabled.

– Verify that the following services in SharePoint have been started

  • Claims to Windows Token Service
  • Excel Calculation Services
  • Web Analytics Web Service
  • Web Analytics Data Processing Service

You should be able to see the correct data after checking the above settings

image