Hi All,

We have recently received an Issue where site collection is getting stuck on Processing and under ULS Logs the Error message is "A large block of literal text was sent to SQL " we cannot create the site collection from any of the template except from Blank site.

We have tried to run the PSConfig wizard and IIS Reset and Restart of computer. The Patch level of SharePoint is service pack 1.

Does this issue has any relation with ASP.net session state service as in the health analyzer we are getting the "Expired sessions are not being deleted from the ASP.NET Session State database."

Windows : 2008

Sharpeoint 2010 with SP1

Looking forward for some suggestions.

Hi,

As I understand, you failed to create a new site collection from any of the template except from Blank site.

The issue might be caused by a bad web application. Please create a new web application. Then create a new site collection in the newly created web application. Please create both web application and site collection via SharePoint 2010 Management Shell.

And the working demo of PowerShell cmdlets for creating web application is:

$ap = New-SPAuthenticationProvider

New-SPWebApplication -Name "SharePoint_Powershell" -Port 81  -URL "http://sp/" -ApplicationPool "SharePoint-81" -ApplicationPoolAccount (Get-SPManagedAccount "contoso\spsvc") -AuthenticationProvider $ap

The working demo of PowerShell cmdlets for creating site collection is:

Get-SPWebTemplate

$template = Get-SPWebTemplate "STS#0"

New-SPSite -Name "PowerShell" -URL "http://sp:81/" -OwnerAlias "contoso\administrator" -Template $template

Here are articles for your reference:

https://technet.microsoft.com/en-us/library/ff607931.aspx

https://technet.microsoft.com/en-us/library/cc263094.aspx

Thanks,

Dean Wang

Hi Dean,

I tried the same but it has the same behavior.

how are you creating the site collection, 

central admin, poweshell or code

thanks

Hi Melick,

I have tried from Both PS and CA.

Hi Rahul,

A possible reason is that the hardware might not capable of running SharePoint server with other servers. Can you provide more details about the topology of your environment, as well as a summary of the hardwares of the servers in use.

Best Regards,

Dea