Compser time out saving global block

Nicklas Ekered

Vote:

Getting timeout error when saving globalblocks after an upgrade from cms 6 + composer 4 to cms 6R2 + Composer 4R2. it did work as it should before the upgrade. And how is the language handled within the global blocks? In other words how can i set language to a specific global block.

We also noticed a programming error when pressing the save as button in order to get into global block options in order to save it the Categories panel is missing text due to missing wrongfully named element in code. The code states Kategorier when it should be Categories. Easy enough to fix but it shouldnt be there in the first place...

Error log regarding first problem:

2012-01-04 16:08:47,417 [59] ERROR Dropit.Extension.UI.Edit.SaveAsGlobalFunction [(null)] - Dropit.Extension.UI.Edit.SaveAsGlobalFunction: Thread was being aborted.
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.ExecuteDbDataReader(CommandBehavior behavior)
   at EPiServer.DataAccess.AbstractCommand.ExecuteReader(CommandBehavior behavior, Int32 resultSetCount)
   at EPiServer.DataAccess.AbstractCommand.ExecuteScalar()
   at Dropit.Extension.Enterprise.ImportDB.<CompleteImport>b__0()
   at EPiServer.DataAccess.DataAccessBase.<>c__DisplayClass1`1.<Execute>b__0()
   at EPiServer.DataAccess.DatabaseFactory.Execute[TResult](Action`1 method)
   at EPiServer.DataAccess.DataAccessBase.Execute[TResult](Action`1 action)
   at Dropit.Extension.Enterprise.Import.Rebuild()
   at Dropit.Extension.Enterprise.Import.CompleteImport()
   at Dropit.Extension.Handlers.InitializationModule.DataImporter_Imported(Object sender, EventArgs e)
   at System.EventHandler.Invoke(Object sender, EventArgs e)
   at EPiServer.Enterprise.DataImporter.Import()
   at EPiServer.Enterprise.Transfer.PageCopyHandler.ExecuteCopying(CopyContext context)
   at EPiServer.Enterprise.Transfer.PageCopyHandler.Copy(PageReference pageLink, PageReference destinationLink, AccessLevel requiredSourceAccess, Boolean publishOnDestination)
   at EPiServer.LocalPageProvider.Copy(PageReference pageLink, PageReference destinationLink, Boolean publishOnDestination, Boolean allowThreading, AccessLevel requiredSourceAccess)
   at EPiServer.DataFactory.Copy(PageReference pageLink, PageReference destinationLink, AccessLevel requiredSourceAccess, AccessLevel requiredDestinationAccess, Boolean publishOnDestination, Boolean allowThreading)
   at Dropit.Extension.Controllers.PageDataManager.CopyContentFunction(ContentFunctionData sourceContentFunctionData, PageReference targetPageLink, PageReference targetShadowPageRef)
   at Dropit.Extension.Controllers.GlobalFunctionManager.CreateGlobalFunction(ContentFunctionData contentFunction, String name, String description, Boolean isEnabled, String lang, String categories)
   at Dropit.Extension.UI.Edit.SaveAsGlobalFunction.Save()
   at Dropit.Extension.UI.Edit.SaveAsGlobalFunction.SaveAndRePublish()
   at Dropit.Extension.UI.Edit.SaveAsGlobalFunction.AnalyseParam()
2012-01-04 16:08:47,449 [59] ERROR EPiServer.Global                              [(null)] - 1.2.5 Unhandled exception in ASP.NET
System.Web.HttpException: Request timed out.

#56093

Jan 04, 2012 16:17

Nicklas Ekered

Vote:

So we searched the episerver database and ended up with some questions.

1. None of the composer blocks got any data saved in the tblPageLanguageSetting table, is this needed?

2, What are the differences concearning composer blocks, global blocks regarding changes in the database.

3. Which attributes are needed in the db in order for the blocks to be saved?

#56145

Edited, Jan 09, 2012 11:37

Mads Storm Hansen

Vote:

We are seeing the same timeouts, when copying a layout function containing many content functions from the clipboard. Its around 20 seconds per content function, which seems very slow.

Before upgrade to R2, copying was smooth.

SQL Profiler shows a stored procedure "composerCompleteImport" spending many seconds JOIN'ing all properties, pages and pagetypes while doing a lot of string-comparison. This time will increase with the amount of content in your EPiServer database.

#56368

Edited, Jan 19, 2012 13:15

Kristoffer Jansson

Vote:

I had the same problem with timeouts when creating globals blocks after upgrading to R2. The procedure "composerCompleteImport" took so long that I got sql timout exceptions.
I got a script from the episerversupport that solved it. Ask the support for this script: composerfix_bug78100_20120417.sql

#70223

Apr 15, 2013 14:02