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

Forums / Deployment / System.OutOfMemoryException exception when editing flv videos in Admin environment

System.OutOfMemoryException exception when editing flv videos in Admin environment

7 posts, 0 answered
  1. Luc Baeten
    Luc Baeten avatar
    169 posts
    Registered:
    23 Sep 2005
    31 Aug 2010
    Link to this post
    hello Sitefinity team,

    I moved a Sitefinity website (Sitefinity 3.7 SP3) with the correspondent database (SQL Server 2000) from our acceptance server to a production server (Windows Server 2003).
    On our acceptance server I could edit the uploaded video's in a video library without any problem. However on our production server I am not able to edit the video's anymore (press the edit button of a video in a video library in Sitefinity Admin environment). Each time I get the exception 'Exception of type 'System.OutOfMemoryException' was thrown.'  I am also not able to remove the video's from the library anymore.
    What could be the reason for this problem?

    Kind regards
    Luc Baeten
  2. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    09 Dec 2016
    31 Aug 2010
    Link to this post
    Hello Luc Baeten,

    Most probably you are using Nolics provider to store video files in the database. The error is thrown, because there is a limit of the SQL sever memory and during a request for retrieving video data you get "out of memory" exception. You could try to increase the SQL dedicated memory and IIS memory limits ( if there are). When you use Nolics provider the data is not entered in chunks and this is why we implemented Files provider. Another option is using Amazon or Viddler storage providers.

    Kind regards,
    Ivan Dimitrov
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  3. Luc Baeten
    Luc Baeten avatar
    169 posts
    Registered:
    23 Sep 2005
    01 Sep 2010
    Link to this post
    Hello Ivan

    How can I remove them form the Video library, because that is not possible to because of the same exception? Can I remove them directly from the database/ If yes could you explain what I should remove from which tables?

    Thanks in advance

    After I removed them I will implement the Files provider.

    regards
    Luc
  4. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    09 Dec 2016
    01 Sep 2010
    Link to this post
    Hello Luc Baeten,

    Try using the API Deleting Content Items

    Database tables

    [sf_Libraries] - data for the ILibrary
    [sf_ChunkData] - keeps chunk data
    [sf_CmsBinaryContent] - keeps the binary data
    [sf_ChunkInfo] - chunck info - size, id, number of chunks
    [sf_GCMetaData] - collects the metadata
    [sf_VrsBinData] - version table for binary data

    Sincerely yours,
    Ivan Dimitrov
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  5. Luc Baeten
    Luc Baeten avatar
    169 posts
    Registered:
    23 Sep 2005
    24 Nov 2010
    Link to this post
    Hello Ivan

    I created this script to delete the videos in the library

    string ImageLibraryName = "EVV TV 1";
    LibraryManager libMgr = new LibraryManager();
    if (ImageLibraryName != null)
    {
        ILibrary lib = libMgr.GetLibrary(ImageLibraryName);
        if (lib != null)
        {
            IList libItems = lib.GetItems();
            foreach (IContent item in libItems)
            {
        try
        {
                        libMgr.DeleteContent(item);
            Label1.Text +=  (string)item.GetMetaData("Name") + "<br>";
        }
        catch (Exception ex)
        {
        }
            }
        }
    }

    However still the same OutOfMemoryException when I try to delete the videos. What can I do to remove them out of the database?

    Kind regards
    Luc
  6. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    09 Dec 2016
    24 Nov 2010
    Link to this post
    Hi Luc,

    The data from libraries module is stored in

    [sf_Libraries]
    [sf_CmsContentBase]
    [sf_GCMetaData]
    [sf_CmsContentThumbnail]
    [sf_CmsCategory]
    [sf_CmsBinaryContent]
    [sf_CmsContentVersion]
    [sf_CmsTag]
    [sf_CmsTaggedContent]
    [sf_VrsBinData]


    You have to query all these tables and delete the items you want.

    Sincerely yours,
    Ivan Dimitrov
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  7. Luc Baeten
    Luc Baeten avatar
    169 posts
    Registered:
    23 Sep 2005
    26 Nov 2010
    Link to this post
    Thanks Ivan

    I was able to remove the videos from the database with sql queries.

    Regards
    Luc
Register for webinar
7 posts, 0 answered