SQL Server Performance

Transactional replication, dist.agent error

Discussion in 'Performance Tuning for SQL Server Replication' started by ginoitalo, Oct 5, 2004.

  1. ginoitalo New Member

    sql2k, sp3a

    Transactional replication snapshot file created without error, but when the distribution agent runs for about 2 minutes the error is:

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

    Why is this happenning ?

    would it be happenning if a user sp_ has an insert with a column listing ?
    (why would it even check this anyways...)

  2. Twan New Member

    HI ya,

    it sounds like someone has changed a table either on the source database and you have subscriptions which don't take table changes accross, or directly on the target. Either way it sounds like the schema has got out of synch between the publisher and subscriber. You could use Profiler to work out which table it is up to, to see if you can repair the problem manually or whether you have to re-snapshot the publication and reinitialise the subscriber

    Cheers
    Twan
  3. satya Moderator

    .. and also check if the used SP has specified correct number of matching columns.
    In general this problem can be avoided by writing an INSERT statement with a column list .

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page