04 November, 2013

The operation that you are attempting to perform cannot be completed successfully

Problem description:
We have received the following error message while creating the site collection underneath one web application.

Error message:
The operation that you are attempting to perform cannot be completed successfully.  No content databases in the web application were available to store your site collection.  The existing content databases may have reached the maximum number of site collections, or be set to read-only, or be offline, or may already contain a copy of this site collection.  Create another content database for the Web application and then try the operation again.


Troubleshooting done:-
If you see the error message then you will experience it is somewhat misleading. How?
See-
1)     Checked the content database is attached or not [By means of Central Administration] - Yes, it’s already there.
2)     Checked the maximum & minimum site collection number and its already max 5000 and min 2000. The actual numbers of site collections are only 50! Strange!
3)     Checked the status of web application – whether its Read Only / content prevented/locked/unlocked [By means of Central Administration]
4)     Checked the status from SQL end and it was fine.

This issue can be resolved in multiple ways-

Resolution:-
1)     Create a new content database and check new site collections are getting created or not.
2)     You can also test this by creating a site collection in a different web application – By this way you are trying to isolate the problem. Whether it’s restricted to single web app/single content database/complete farm.
3)     Check the database status –
                                i.            Central administration
                              ii.            Application management
                            iii.            Manage content databases
                            iv.            Select the appropriate web application from the dropdown
                              v.            Check the status
                            vi.            In my case, it’s showing error

Note: I would like to highlight that the above mentioned ‘error’ status does not make any impact on the existing site collections so nothing to worry about it.

4)     Execute IISRESET and check the results
5)     Check the status from the SQL end and make sure there is no problem with the logs as the database consists of mdf and ldf files, this problem might be occur due log files gets full!

In my case, it’s showing the database status as “Error” so I performed the following steps-
1.      Detach the content database from the web application
2.      IISRESET
3.      Attach the content database back & check the results.

Now site collections can be created without any problems!

Issue resolved! Happy SharePoint…

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.

Reference:


Product applies to:
1)     SharePoint Server 2010
2)     SharePoint Foundation 2010

Sorry, something went wrong – SharePoint 2013

I am an owner of one group on Facebook where people used to ask their queries and community people replied with appropriate answers. One of the question/query reported by one user where he is getting an error message- Sorry, something went wrong while opening office documents with respect to office web apps.

Exact error message:-
Sorry, something went wrong
An error has occurred on the server.
Technical Details
Troubleshoot issues with Microsoft SharePoint Foundation.
Correlation ID: a85Kdd9g- jht 1- 50e6- 6gdd- 164d14296a0t

I have started my research and found this article which reflects the exact resolution-http://support.microsoft.com/kb/2761265

Thanks to Microsoft once again!

Note: if you think that the above mentioned article does not resolves the issue then Please use the correlation id from the error message and check the ULS logs and update your findings here so that we can check and try to find out the resolution.

If you have any queries/questions regarding the above mentioned information then please let me know, Thank you.


Some Important references:







31 October, 2013

This workbook is larger than the maximum workbook size allowed to be opened in the browser

Today we faced one more new issue and it was quite easy to understand and predict what will be the resolution! But today’s article is especially for those who are business managers/IT analyst/vice presidents/governance etc. - who does have access to the servers.

To display a workbook in an Excel Web Access Web Part, you must add the Web Part to a page and then connect the workbook to the Web Part by entering the workbook URL or UNC in the Excel Web Access tool pane. As a final step, you can customize the Web Part by selecting properties in the Excel Web Access tool pane for the Web Part.

User reported an issue that he is trying an excel file in the excel web access webpart (EWA) and getting the following error message-
This workbook is larger than the maximum workbook size allowed to be opened in the browser.
 
Here is the step by step resolution:
1)     Open the central administration
2)     Application management
3)     Manage service applications
4)     Excel service application
5)     Click on Trusted File locations
6)     Select the document library link where your excel files are stored
7)     Go to the section termed as “Workbook Properties”
8)     Maximum workbook size
9)     By default its set to 10MB
10) Set it as per your requirement – like 50MB/100MB
11) Click OK


Go back to your site now where you were facing the problem -> refresh the page and check the results!

It should be resolved now. Thank you.

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.

28 October, 2013

October 2013 Cumulative Update

October 2013 Cumulative Update Packages for SharePoint Foundation 2013 and SharePoint Server 2013 have been released

October 2013 CU for SharePoint Foundation 2013 - KB 2825674 http://support.microsoft.com/kb/2825674

October 2013 CU for SharePoint Server 2013 - KB 2825647 http://support.microsoft.com/kb/2825647

Note: This is build 15.0.4551.1001 of the cumulative update package.