adding Replication caused Length of LOB data error

3 posts, 0 answers
  1. Ted
    Ted avatar
    47 posts
    Member since:
    Jan 2008

    Posted 27 Oct 2011 Link to this post

    we are getting an error when we are trying to copy an entire tree structure in our database after adding replication.  Anyone have any thoughts on how to fix this.  worked fine until replication was added to the tables.

    Insert of '437937710-' failed: Telerik.OpenAccess.RT.sql.SQLException: Length of LOB data (197434) to be replicated exceeds configured maximum 65536.\r\nThe statement has been terminated.\r\n   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.execute()\r\n   at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.execute()\r\n   at OpenAccessRuntime.Relational.RelationalStorageManager.generateInserts(NewObjectOID oid, Int32 index, ClassMetaData cmd, PersistGraph graph, Int32[] fieldNos, CharBuf s, Object[] oidData, IntArray toUpdateIndexes)\n
  2. Ady
    Admin
    Ady avatar
    589 posts

    Posted 28 Oct 2011 Link to this post

    Hi Ted,

    This error occurs when the default maximum text replication size (65536) for a column is exceeded. You can modify this value using the following procedure -
    EXEC sp_configure ‘max text repl size’, -1

    You can also modify this setting via 'Sql Server Management Studio' by selecting the server in the 'Object Explorer', right click and select 'Properties' ,'Advanced' node and modify the property in the 'Miscellaneous' section.

    Do get back in case you need further assistance.

    Best wishes,
    Ady
    the Telerik team

    NEW and UPDATED OpenAccess ORM Resources. Check them out!

  3. DevCraft banner
  4. Ted
    Ted avatar
    47 posts
    Member since:
    Jan 2008

    Posted 28 Oct 2011 Link to this post

    That worked.  Thank you.
Back to Top