Post reply

Column name or number of supplied values does not match table definition - replication

  • July 18, 2011 at 3:20 am

    #244460

    Hi all,

    I'm getting the following error in replication monitor:

    Column name or number of supplied values does not match table definition.

    The error details are:

    Command attempted:

    if @@trancount > 0 rollback tran

    (Transaction sequence number: 0x000035E600231E05000100000000, Command ID: 1)

    Is there any way to find out which table is the culprit?

  • July 18, 2011 at 3:52 am

    #1354132

    You can run the following on the distributor DB to see if it returns any errors:

    sp_browsereplcmds @xact_seqno_start = '0x000035E600231E05000100000000',

    @xact_seqno_end = '0x000035E600231E05000100000000'

    and if that doesn't return anything trim out the trailing zeros

    sp_browsereplcmds @xact_seqno_start = '0x000035E600231E050001',

    @xact_seqno_end = '0x000035E600231E050001'

    If either of the above returns data - go to the row that has command_id 1 in the resultset and look at the "command" column. This column will have the call to the replication SP that is failing - and looking at this SP would help identify why it is failing

    Alternatively - you can do a check of the columns in the publisher v/s subscriber for all published articles to see if there is any mismatch (which is what the error seems to be pointing to).

  • July 18, 2011 at 5:41 am

    #1354166

    Many thanks for the reply Winash!

    I was able to identify the issue and replication is now running.

Viewing 3 posts - 1 through 2 (of 2 total)

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