The content databases in this cluster are full. You cannot add more web sites until you change the content database web site capacity settings or add more content databases

SharePoint capacity planning plays a very vital role with respect to any farm, whether it’s a small farm, medium farm or large farm. Today I am going to share some details and troubleshooting steps regarding one issue that I faced recently.

Problem Description: we have received the following error message while creating the site collection.

Error Message: The content databases in this cluster are full. You cannot add more web sites until you change the content database web site capacity settings or add more content databases.

Troubleshoot issues with Microsoft SharePoint Foundation.

Troubleshooting done: From the above error message, 2 points comes into the picture i.e. database size and number of site collections exist in a single database.

-Based on analysis, we found out that total site collections exist are 100 and size of the database was 67GB.

-checked the managed databases section in central administration with respect to that web application under which we are trying to create a site collection. We found out that somebody has changed the maximum site collection limit to 100 and that’s why we were facing that error message.

Resolution:

Please refer the following steps to get rid of this error message:

-Central administration

-Application management

-manage databases

-select the appropriate web application from the top

-change the maximum site collection limit to 15000 and warning set to 9000.

That’s it. After this we are able to create site collections without any issues.

If you have any queries/issues regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you. 

Performance and capacity management- SP2010

Sharing some useful links with respect to the capacity planning: 

https://www.simple-talk.com/dotnet/.net-tools/database-management-for-sharepoint-2010/

http://blogs.msdn.com/b/kaevans/archive/2012/03/27/what-every-sharepoint-admin-needs-to-

know-about-host-named-site-collections.aspx

http://www.sharepointsharon.com/2011/08/sharepoint-2010-performance-and-capacity-limits/

http://www.sharepointfix.com/2010/07/adding-new-content-database-in.html

http://technet.microsoft.com/en-us/library/cc262971(v=office.14).aspx

http://www.microsoft.com/en-in/download/details.aspx?id=21307

http://technet.microsoft.com/en-us/library/cc261700.aspx

http://technet.microsoft.com/en-us/library/ff758645.aspx

http://technet.microsoft.com/en-us/library/gg604780(v=office.14).aspx

http://technet.microsoft.com/en-us/library/cc298801(v=office.14).aspx

http://blogs.msdn.com/b/infopath/archive/2010/04/19/capacity-planning-for-sharepoint-2010.aspx

You do not have permissions to connect to the server + Access Denied in SharePoint 2010

Problem Description:

Getting the following while launching SharePoint 2010 performance point dashboard designer and connecting to datasource.

Error Message:

Access Denied.  You do not have permissions to connect to the server.  Please contact your system administrator.

Entities used:

-SharePoint server 2010

-Performance point

-SQL Server 2008 R2

-BI template for the site collection

-IE7 + windows 7 OS

Troubleshooting done:

-Performance point service application is started or not

-performance point service is started or not

-secure store service application is started or not

-secure store service is started or not

-performance point service application is properly associated with the respective web application

-the account that we have used for configuring the performance point service application has proper rights in SQL or not

-what kind of rights user has on the specific site collection that is being used inside the dashboard designer

Resolution:

After checking all the steps and thorough analysis, we check the logs and found some traces with respect to the authentication.

We have checked the authentication part with respect to that web application and it was using claim based authentication.

As per the Microsoft theory regarding performance point services, it does not support any other authentication except windows authentication.

So conclusion is windows authentication is mandatory to make the performance point functional.

If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

Unexpected error while creating a Business Intelligence Center site - SharePoint 2010

Hello Guys,

Today I am going to share one more interesting issue and troubleshooting steps so that it would be helpful to all of you.

Present environment entities:

-SharePoint server 2010

-SQL Server 2008 R2

-Windows 7 Operating system

-Internet Explorer 7

Problem description: We are trying to use the performance point in SharePoint so one of the basic need is to create a site with BI template i.e. business intelligence

-We opened our site collection

-site actions

-site settings

-site administration

-sites and workspaces

-provided site name, entered the appropriate URL, selected the required template i.e. business intelligence template and clicked OK

-as soon as we clicked OK then we got the following error message

Error Message:

An Unexpected error has occurred

Correlation ID

Date and time

Troubleshooting Done:

-Tried creating different site using different template under the same site collection- it works

-so one thing is sure that problem is with creating a BI template site.

-checked numerous site collection features

-activated performance point services at the site collection level
-checked the SharePoint logs and found the following:

Publishing Feature activation failed. Exception: System.InvalidOperationException: The SharePoint Server Publishing Infrastructure feature must be activated at the site collection level before the Publishing feature can be activated.    

From the above, it’s very clear that what needs to be done to make it working.

Resolution:

Activated Publishing infrastructure at the site collection level

-site actions

-site settings

-site collection administration

-site collection features

-activated Publishing infrastructure feature

Please let me know in case of any queries/questions so that we can discuss and proceed towards the resolution, Thank you.

There was an error retrieving data from a datasource + An entry has been added to the Windows event log of the server + Event ID-7893

Problem Description:

I have a browser enabled InfoPath form loading in a Form web Part in a webpart page with another connecting web part. When users try to open the form they get:

"An error occurred querying a data source"

Sympton-1: Occasional error when opening an InfoPath form

Sympton-2: InfoPath timeout random error first time form is loaded

Sympton-3: An error occurred querying a data source

Sympton-4: There was an error retrieving data from a datasource.

Click OK if you want to resume filling in the form.  Possibly you might want to check the form for errors.

Sympton-5: There was an error retrieving data from a datasource. An entry has been added to the Windows event log of the server.

Log ID: 7893

Troubleshooting:

Best suggestion / recommended one is check the SharePoint ULS logs and find out the exact root cause behind this error message. I also did the same and found out that it is happening because of data connection time outs.

Resolution:

The Maximum data connection timeout value you modified is used to override all data connection time out values that specified within form template code. If you are not specified the time out value within form template code, please increase the default data connection timeout in Central Administration.

-Central Administration

-General Application Settings

-Configure InfoPath Forms Services

-Increase the time out value and try again.

If you have any queries/questions based on the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, thank you.

Product Applies To:

-SharePoint Server 2010

-SharePoint foundation 2010

References:

http://technet.microsoft.com/en-us/library/cc262263(v=office.14).aspx