Post reply

Replication Issue

  • February 7, 2012 at 5:50 am

    #391490

    Hi,

    In production server I have a table which has a text field. There was an application upgrade recently and we include this table in replication.

    But due to this replication, our application is throwing an error as below

    '

    Msg 7137, Level 16, State 1, Procedure usp_%, Line 7

    UPDATETEXT is not allowed because the column is being processed by a concurrent snapshot and is being replicated to a non-SQL Server Subscriber or Published in a publication allowing Data Transformation Services (DTS).'

    In the properties of the table we have the column as

    1. Not for replication.

    2. Replicated as 'Yes'

    3. Sql Server Subscriber 'Yes'

    We have removed the table from replication but still cannot create a procedure which uses updatetext.

    Please can someone help in this .

    This is on our production server .

    Thanks,

    Harsha

  • February 7, 2012 at 7:02 am

    #1443743

    We have removed the table from replication but still cannot create a procedure which uses updatetext.

    Please can someone help in this .

    As much I am aware, you need to re-initialise the replication at subscriber site after change in subscrber's object list.

    Test it in your test system first, if possible.

    ----------
    Ashish

  • February 7, 2012 at 7:53 am

    #1443791

    Hi,

    I have already done that. Still no change.

    Thanks,

    Harsha

  • February 7, 2012 at 8:35 am

    #1443839

    Have you made sure the table is removed from the publisher? Remove the table from the publisher and then reinitialize.

    If this doesn't work then I've found when you handle replication problems in replication manager, like manually deleting objects, you may see inconsistencies in the system tables. Try removing replicated objects or removing replication by using T-SQL instead.

    http://msdn.microsoft.com/en-us/library/ms147921.aspx

  • February 7, 2012 at 9:27 am

    #1443905

    Tried by that. Still the problem persists. :crying:

  • February 7, 2012 at 9:30 am

    #1443907

    can you paste the error you getting in replication monitor?

    And

    How tough it is to re-configure the replication?

    ----------
    Ashish

  • February 7, 2012 at 10:33 am

    #1443961

    I am not getting this error in replication monitor.

    I am getting this error, when we try to create a procedure for the table using updatetext.

    Below is the error message what we get.

    Msg 7137, Level 16, State 1, Procedure proc_name, Line 7

    UPDATETEXT is not allowed because the column is being processed by a concurrent snapshot and is being replicated to a non-SQL Server Subscriber or Published in a publication allowing Data Transformation Services (DTS).

    Thanks,

    Harsha

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply