Error 14151: schema script could not be propagated to the subscrib
in [Replication]
|
Prev: replicaiton failed with:A system assertion check has failed
Next: Effects of reboot on SQL2005 Merge Replication?
From: Steve on 21 Aug 2008 08:49 I am setting up replication between two sql2005 servers. One being the distributor/publisher and the other being the sole subscriber. I have created 2 publications, tables only, one with about 15 articles the other with only 2 articles. I have created push subscriptions to the subscriber for each. Both of these servers live withing the same domain and the snapshot agent is configured to run under the SQL Server Agent account which in turn runs under the domain\administrator account. All this works fine. I have created a script of the replication setup which sucessfully runs. When I look at the replication monitor I see both snapshots have been created succesfully and all the files exist in the repldata directory. The subscriptions can be viewed on the subscriber database also. However when I run the synchronisation tasks one fails (the one with the larger publication). It reports the following error :- The schema script XXXX.sql could not be propagated to the subscriber Error No: MSSQL_REPL-2147201001 When I look in the SQL logs I find 2 errors firstly :- Error: 14151, Severity: 18, State: 1 and then the one reported in the sync history. Looking at the subscriber db I see subscription status of the failed subscription is set to 'Never started'. The file it reports failing to proagate is a pre snapshot drop constraints script. It does appear that the error is interrmittent. Any help would be appreciated. |