Failed to update site content type - Column Order due to aborted thread

-
I encountered error when updating Column Ordering of a site content type on a root web with 6000 sub-webs via web browser:

http://SharePoint2010.intranet.abc.com/_layouts/ChangeFieldOrder.aspx?ctype=0x01007654335D3BA08148A3410EAA36350F99

I then checked the ULS log on the Web Front End server and found the following error:

System.Threading.ThreadAbortException: Thread was being aborted. 
 at SNIReadSync(SNI_Conn* , SNI_Packet** , Int32 ) 
 at SNINativeMethodWrapper.SNIReadSync(SafeHandle pConn, IntPtr& packet, Int32 timeout) 
 at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj) 
 at System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket() 
 at System.Data.SqlClient.TdsParserStateObject.ReadBuffer() 
 at System.Data.SqlClient.TdsParserStateObject.ReadByte() 
 at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) 
 at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() 
 at System.Data.SqlClient.SqlDataReader.get_MetaData() 
 at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) 
 at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) 
 at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) 
 at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) 
 at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) 
 at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) 
 at Microsoft.SharePoint.Utilities.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior, SqlQueryData monitoringData, Boolean retryForDeadLock) 
 at Microsoft.SharePoint.SPSqlClient.ExecuteQueryInternal(Boolean retryfordeadlock) 
 at Microsoft.SharePoint.SPSqlClient.ExecuteQuery(Boolean retryfordeadlock

Apparently the thread was aborted due to HTTP execution timeout.

To fix this error, I edited C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\LAYOUTS\web.config file as follows and it took effect immediately without restart:

executionTimeout was increased from 360 to 1080 to fix the error

I hope this article will help any SharePoint developer or administrator out there who encounters similar error when working with a large site collection.

Comments

Post a Comment

Popular posts from this blog

How to rename your tenancy hostname of SharePoint Online (sharepoint.com)

-
Problem I need to correct the hostname of SharePoint Online to match my hostname Solution 1. Navigate to https://aka.ms/SPORenameAddDomain 2. Add new domain name, for example YourNewHostName .onmicrosoft.com 3. Run SharePoint Online Management Shell and use the following commands: Connect-SPOService https:// YourCurrentHostName -admin.sharepoint.com Start-SPOTenantRename -DomainName YourNewHostName -ScheduledDateTime "2022-12-16T11:30:00" Note: the scheduled time must be at least 24 hours in the future. The time is your current computer time.
Read more

How to migrate SharePoint Online SPWeb with custom SPList form (PowerApps) and Flows

-
Image
Problem I need to migrate a SPWeb with custom SPList form (PowerApps) within the same SPSite collection. Solution Run the following PnP PowerShell command from Windows PowerShell ISE $TemplateFilePath = "C:\temp\ PnPSiteTemplate_ YourSourceFormSubsiteName .xml " $SourceSiteConnection = Connect-PnPOnline https:// YourTenancy .sharepoint.com/sites/ SharePointForms/PROD/YourSourceFormSubsiteName -Interactive Get-PnPSiteTemplate -Connection $SourceSiteConnection -PersistBrandingFiles -IncludeAllPages -Verbose -Out $TemplateFilePath $TargetSiteConnection = Connect-PnPOnline https:// YourTenancy .sharepoint.com/sites/ SharePointForms/PROD/YourTargetFormSubsiteName -Interactive Invoke-PnPSiteTemplate -Connection $TargetSiteConnection -Path $TemplateFilePath -ClearNavigation Disconnect-PnPOnline Ensure the target copied list is unmodified. Do not rename it or change it until the PowerApps are imported and republished to prevent Data Source confusion after import. Navigate to List s...
Read more