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

Forums / Bugs & Issues / Length of LOB data

Length of LOB data

5 posts, 0 answered
  1. WebGeek
    WebGeek avatar
    186 posts
    Registered:
    20 Dec 2006
    13 Jun 2008
    Link to this post

    I am getting the following error all of a sudden when I try to edit a document in the images and document module.  It does not happen on all documents, but I can not delete and reupload new documents.

    Length of LOB data (106021) to be replicated exceeds configured maximum 65536.
    The statement has been terminated.

  2. Nikifor
    Nikifor avatar
    232 posts
    Registered:
    18 May 2013
    16 Jun 2008
    Link to this post
    Hi medicalwebgeek,

    Please, let us know whether you use Oracle database. We had a known issue connected with the size of the file which can be uploaded with the Images & Documents module, and which is fixed in the latest HotFix 1616. If this is so, please upgrade your project and make sure that the following section in the web.config looks as shown below:
    <telerik> 
    <dataAccess defaultConnection="DefaultConnection"
    <connections> 
    <add name="DefaultConnection" driver="Telerik.DataAccess.DefaultOracleProvider, Telerik.DataAccess.OracleProvider" 
    connectionStringName="Sitefinity" /> 
    <add name="GenericContentConnection" driver="Telerik.DataAccess.GCOracleProvider, Telerik.DataAccess.OracleProvider" 
    connectionStringName="Sitefinity" /> 

    If you use SQL server database, please send us the file which is causing the exception for further investigation.

    Greetings,
    Nikifor
    the Telerik team

    Instantly find answers to your questions at the new Telerik Support Center
  3. WebGeek
    WebGeek avatar
    186 posts
    Registered:
    20 Dec 2006
    16 Jun 2008
    Link to this post
    SQL Server
  4. WebGeek
    WebGeek avatar
    186 posts
    Registered:
    20 Dec 2006
    10 Oct 2008
    Link to this post
    Here is what caused this issue:
    We setup replication to our external database and this issue started up.  To resolve it, I ran the following SQL:

    RECONFIGURE;

    EXEC sp_configure;

    USE DBNAME;

    GO

    EXEC sp_configure 'max text repl size (B)', '102007167';

    RECONFIGURE WITH OVERRIDE;

    RECONFIGURE;

    EXEC sp_configure;

  5. Georgi
    Georgi avatar
    3583 posts
    Registered:
    28 Oct 2016
    13 Oct 2008
    Link to this post
    Hello medicalwebgeek,

    We are glad that you know the reason and thank you for the follow up. Please take our apologizes that we werenot able to help you right away.

    Kind regards,
    Georgi
    the Telerik team

    Check out Telerik Trainer, the state of the art learning tool for Telerik products.
Register for webinar
5 posts, 0 answered