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

Forums / Bugs & Issues / BIG file uploads ~1GB

BIG file uploads ~1GB

8 posts, 1 answered
  1. Scott Rozman
    Scott Rozman avatar
    93 posts
    Registered:
    10 Oct 2012
    23 Nov 2010
    Link to this post
    I've been trying to upload a 2 hour long video using the normal SQL provider and am getting an error.

    InvalidOperationException: This SqlTransaction has completed; it is no longer usable.

    Is there anything to do about this?

    Is switching to the file provider for the library a better option?

    thanks in advance!
  2. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    09 Dec 2016
    23 Nov 2010
    Link to this post
    Hi Scott,

    You could try the following options

    Option one: Enable the streaming for Nolics provider and then try to upload a file.

    <libraries defaultGenericProvider="Libraries" streamingProviderName="Nolics" streamingIsEnabled="True"streamingChunkSize="20971520">


    This will set your website to upload files on chunk of maximum 20 MB. If you want you can decrease the value of streamingChunkSize to 10 or 5 MB

    Option two: If the option one does not help ( I hope that option 1 will resolve your issue) you should use the Files provider. You might also find this post useful - Switching from database to filesysystem for files.

    I suggest that you should use Files provider or AmazonS3 or Viddler storage for large files.

    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
    Answered
  3. Scott Rozman
    Scott Rozman avatar
    93 posts
    Registered:
    10 Oct 2012
    23 Nov 2010
    Link to this post
    Thanks for that quick response! suggestion #1 worked.

    I have a few follow-up questions now....

    - On my site, I have 3 different providers
    <libraries defaultGenericProvider="Libraries" streamingProviderName="Nolics" streamingIsEnabled="True" streamingChunkSize="20971520">
                <genericContentProviders>
                    <add providerName="Libraries" publicationDateField="Publication_Date"/>
                    <add providerName="SoE_Libraries" publicationDateField="Publication_Date"/>
                    <add providerName="SoE_Videos" publicationDateField="Publication_Date"/>
                </genericContentProviders>
    because we have some shared content between sub-domains.
    Would there be a need or a way to alter these settings for just the video-oriented provider?

    Also, how do these settings affect playback vs. uploading? Would you recommend these settings on all sub-domains(sitefinity instances) that use this content regardless of whether they have to play only and not upload?

    Thanks again!
  4. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    09 Dec 2016
    23 Nov 2010
    Link to this post
    Hello Scott,

    streamingProviderName="",  streamingIsEnabled=""and treamingChunkSize
    can be set only for <libraries> node and for the default provider.

    Playback generally depends on the server location from where you get the data. If your data server is on the same machine then the content from the database base will be server more quickly than if you have a separate server for your database.

    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
  5. Nadya
    Nadya avatar
    52 posts
    Registered:
    17 Dec 2008
    21 Jan 2011
    Link to this post
    Hi guys,

    I am using Sitefinity 3.7 SP4 and I have created a custom pluggable module the usual way and when I try to edit or create new item (in the backend), or get details for only one item (in the frontend) I am getting the same:

    This SqlTransaction has completed; it is no longer usable.

    I have more custom modules in my app and they are not giving this issue - I really don't know what could cause it - the things is that on another machine it is working. Also the list of items in the backend is loading fine.

    Can you please suggest some idea about it ?

    I am really stuck and I need help.

    Thanks!
    Nadya
  6. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    09 Dec 2016
    21 Jan 2011
    Link to this post
    Hi,

    It is possible that there is some issue with the SQL and the way that it should handle large dat.
    Try using the Files provider which is supposed to handler large files. The Files provider uses the File system and does not make large transactions to the dababase.

    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
  7. Netfinity
    Netfinity avatar
    11 posts
    Registered:
    15 Nov 2006
    07 Nov 2011
    Link to this post
    Hi I am receiving connection reset errors when trying to upload images to our Sitefinity 3.7 site. We are using the files provider and I have updated web.config (shown below) as many posts I have read recommend to increase the maximum request length to 204.8 MB and 5 minutes execution timeout.

    <httpRuntime maxRequestLength="204800" executionTimeout="300" />

    Our web server is running on Windows 2003 x64 and IIS 6. I have checked the AspMaxRequestEntityAllowed setting in the Windows/System32/inetsrv/MetaBase.xml file as recommended here http://www.telerik.com/support/kb/aspnet-ajax/upload/page-not-found-error-when-uploading-large-files-on-win2003.aspx but it is also set to 204800 KB (204.8 MB) and the image I am trying to upload is only around 24 MB. I can not replicate the issue on my local host development environment and I'm not sure what else to try or what is causing the issue. I suspect it could be because the site is receiving a few other requests while the image is uploading.

    Any ideas or suggestions?
  8. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    09 Dec 2016
    07 Nov 2011
    Link to this post
    Hello Netfinity,

    Check if the SQL server hasn't reached some memory limits and its get restarted. You can also see if there are some restrictions set over it related to the queries per minute.

    Kind regards,
    Ivan Dimitrov
    the Telerik team
    Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
Register for webinar
8 posts, 1 answered