+1-888-365-2779
Try Now
More in this section

Forums / Bugs & Issues / Videos Large Files

Videos Large Files

4 posts, 0 answered
  1. Sean
    Sean avatar
    271 posts
    Registered:
    31 May 2006
    03 Jul 2009
    Link to this post
    Hi,

    I think there may be a bug in the Images and Documents Module where when you have a large video file (26 MB) stored it causes the form to time out and take ages to load the library containing that video.  Does anyone else have this problem?

    This is the error coming from the sitefinity.log.

    Cheers
    Sean

    ------------------------------------------------------------------------------------------------------------

    Exception Type: System.Data.SqlClient.SqlException

    Message: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

    Source: .Net SqlClient Data Provider

    Stack Trace:
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlDataReader.HasMoreRows()
       at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout)
       at System.Data.SqlClient.SqlDataReader.Read()
       at Nolics.ORMapper.DataProviders.SQLDataProvider.ParseResult(Int32 fromRow, Int32 maxRows, DataSet dsResult, IDataReader rd)
       at Nolics.ORMapper.DataProviders.SQLDataProvider.ExecuteKeyQuery(DataSet queries, Boolean fPrimaryKey)
       at Nolics.ORMapper.DataProviders.SQLDataProvider.QueryByForeignKey(DataSet keys)
       at Nolics.ORMapper.Base.ForeignKeyQuery.LoadFKQuery()
       at Nolics.ORMapper.Base.Relation`1.Load()
       at Nolics.ORMapper.Base.Relation`1.Refresh()
       at Nolics.ORMapper.Base.Relation`1.DoAutoRefresh(ObKey foreignKey)
       at Telerik.Versioning.Data.VersionItem.get_BinaryData()
       at Telerik.Versioning.Data.VersionItem.get_Data()
       at Telerik.Cms.Engine.StagedContent..ctor(IVersionItem item, ContentProviderBase provider, Boolean lazyLoadContent)
       at Telerik.Cms.Engine.ContentManager.GetCurrentState(Guid id, Boolean forCurrentCulture, Boolean lazyLoadContent)
       at Telerik.Cms.Engine.ContentManager.GetCurrentState(Guid id)
       at Telerik.Libraries.WebControls.Admin.LibraryItemList.RenderThumbList(IContent currentItem, RepeaterItemEventArgs e)
       at Telerik.Libraries.WebControls.Admin.LibraryItemList.ImagesList_ItemDataBound(Object sender, RepeaterItemEventArgs e)
       at System.Web.UI.WebControls.Repeater.OnItemDataBound(RepeaterItemEventArgs e)
       at System.Web.UI.WebControls.Repeater.CreateItem(Int32 itemIndex, ListItemType itemType, Boolean dataBind, Object dataItem)
       at System.Web.UI.WebControls.Repeater.CreateControlHierarchy(Boolean useDataSource)
       at System.Web.UI.WebControls.Repeater.OnDataBinding(EventArgs e)
       at System.Web.UI.WebControls.Repeater.DataBind()
       at System.Web.UI.WebControls.Repeater.EnsureDataBound()
       at System.Web.UI.WebControls.Repeater.OnPreRender(EventArgs e)
       at System.Web.UI.Control.PreRenderRecursiveInternal()
       at System.Web.UI.Control.PreRenderRecursiveInternal()
       at System.Web.UI.Control.PreRenderRecursiveInternal()
       at System.Web.UI.Control.PreRenderRecursiveInternal()
       at System.Web.UI.Control.PreRenderRecursiveInternal()
       at System.Web.UI.Control.PreRenderRecursiveInternal()
       at System.Web.UI.Control.PreRenderRecursiveInternal()
       at System.Web.UI.Control.PreRenderRecursiveInternal()
       at System.Web.UI.Control.PreRenderRecursiveInternal()
       at System.Web.UI.Control.PreRenderRecursiveInternal()
       at System.Web.UI.Control.PreRenderRecursiveInternal()
       at System.Web.UI.Control.PreRenderRecursiveInternal()
       at System.Web.UI.Control.PreRenderRecursiveInternal()
       at System.Web.UI.Control.PreRenderRecursiveInternal()
       at System.Web.UI.Control.PreRenderRecursiveInternal()
       at System.Web.UI.Control.PreRenderRecursiveInternal()
       at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
    ------------------------------------------------------------------------------------
  2. Stoyanka Assenova
    Stoyanka Assenova avatar
    113 posts
    Registered:
    01 Dec 2016
    03 Jul 2009
    Link to this post
    Hi Sean,

    We know for this problem.  It will be fixed in Sitefinity 4.0.
    We are sorry for the inconvenience cause.

    Regards,
    Stoyanka Assenova
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Check out the tips for optimizing your support resource searches.
  3. Sean
    Sean avatar
    271 posts
    Registered:
    31 May 2006
    03 Jul 2009
    Link to this post
    Hi Stoyank,

    Thanks for that, so what can we do about this until version 4 comes out, which is going to be a while off?

    Thanks
    Sean
  4. Georgi
    Georgi avatar
    3583 posts
    Registered:
    28 Oct 2016
    08 Jul 2009
    Link to this post
    Hi Sean,

    The problem is not so trivial and there is no easy workaround, if there is at all.
    From one side we have IIS and Asp.Net time outs, and on another - SQL Server time outs. The problem lies in the way the data is stored in the database. Right now, everything should happen at once, while in the future, we will do it in chunks. The fix should be in the ORM layer.

    We notice that the server capabilities also play a key role - how fast the data will be processed. On testing machines we were able to reproduce the same problem with files which are over 200mb in size. Having that said, an option might be to move the project on another server and try the same procedure.

    You can also use the file system to store the data, or implement a custom provider (just like the Amazon S3) which is storing the files on external storage (file system) but keeps a reference in the module itself. You can also consider Amazon S3 usage.

    I apologize for the inconvenience.

    Best wishes,
    Georgi
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Check out the tips for optimizing your support resource searches.
Register for webinar
4 posts, 0 answered