January 8, 2014 at 2:33 am
Attempting to start a replication relation, however, when initializing, it gives me the following error:
2014-01-08 09:23:02.225 The schema script 'FillMercaTempTab_56.sch' could not be propagated to the subscriber.
2014-01-08 09:23:02.234 Category:NULL
Source: Merge Replication Provider
Number: -2147201001
Message: The schema script 'FillMercaTempTab_56.sch' could not be propagated to the subscriber.
2014-01-08 09:23:02.236 Category:NULL
Source: Microsoft SQL Server Native Client 10.0
Number: 213
Message: Column name or number of supplied values does not match table definition.
How do I figure out which statement is the culprit?
January 8, 2014 at 7:13 am
bleumer (1/8/2014)
Attempting to start a replication relation, however, when initializing, it gives me the following error:2014-01-08 09:23:02.225 The schema script 'FillMercaTempTab_56.sch' could not be propagated to the subscriber.
2014-01-08 09:23:02.234 Category:NULL
Source: Merge Replication Provider
Number: -2147201001
Message: The schema script 'FillMercaTempTab_56.sch' could not be propagated to the subscriber.
2014-01-08 09:23:02.236 Category:NULL
Source: Microsoft SQL Server Native Client 10.0
Number: 213
Message: Column name or number of supplied values does not match table definition.
How do I figure out which statement is the culprit?
The error almost gives you enough information to find the problem. Its told you there is a problem with the script 'FillMercaTempTab_56.sch'. You just need to know where it is to see why exactly and diagnose why the snapshot is wrong.
You can find the default snapshot folder by looking at the publication properties or going to the UNC path of the snapshot distributor server (usually).
Column name or number of supplied values does not match table definition. This could be any number of things but parsing the script should give you a pointer.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply