Home Forums SQL Server 2008 SQL Server 2008 - General Replication failing with error "Column name or number of supplied values does not match table definition." RE: Replication failing with error "Column name or number of supplied values does not match table definition."

  • August 29, 2012 at 10:46 am

    #1531517

    ryan_xh (8/29/2012)

    Hi all,

    I have created a pull transactional replication where the replication was running fine until the following error occured for a particular table:

    "Replication-Replication Distribution Subsystem:..Column name or number of supplied values does not match table definition."

    I checked the table definition, the definition of the stored procedure sp_MSins_dboTable (which is trying to insert the data into the table) and also the values that are being inserted and didn't find any error. One of the columns in the destination table is an identity column and it already has "Not for replication" set to Yes. Both publisher and subscriber have sql 2008 r2, one is enterprise and one is standard edition.

    I already deleted and recreated both the publication and subscription once, but the same problem is occuring for this table. Not sure what else I can do now.

    Please provide your thoughts.

    Thanks.

    Not sure if this will have anything to do with it, as it usually generates a different error... but how are you managing the range of the identity for this? Manually?

    Jared
    CE - Microsoft