Cannot propogate to subscriber

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Spike - 25 Jan 2007 15:11 GMT

I'm getting this error when I try to replicate

The schema script
'\\CVTDEESQL005\ETMSData\unc\CVTDEESQL005_ZenithSQL_L_060104_ZenithSQL_L_060104\20070120231902\tblCall_1.sch'
could not be propagated to the subscriber. The step failed.

I can find this row in sysMergeSchemaChange but I'm not sure why it's
causing a problem. Can someone give me some guidance?

kr

Spike

Reply to this Message

Paul Ibison - 25 Jan 2007 16:41 GMT

I'd do some logging and see if this records more info
(http://support.microsoft.com/?id=312292).
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

Reply to this Message

Spike - 25 Jan 2007 18:11 GMT

> I'd do some logging and see if this records more info
> (http://support.microsoft.com/?id=312292).
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
> Message: The process could not read file '\\CVTDEESQL005\ETMSData\unc\CVTDEESQL005_ZenithSQL_L_060104_ZenithSQL_L_060104\20070120231902\tblCall_1.sch' due to OS error 53.

53 is a network error, so I quess either the file is not there or I've lost
access to the directory. If I were to remove this line from
sysMergeSchemeChange would that sort it? Or be a very bad idea?

The row in question is the second one after exec.sp_MsChange_Retention etc.

Reply to this Message

Paul Ibison - 25 Jan 2007 19:50 GMT

I'd run the snapshot once again. Perhaps there are also other files that
went missing, and if there's an underlying problem it'd be best to sort it
out systematically.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

Reply to this Message

Spike - 26 Jan 2007 09:56 GMT

> I'd run the snapshot once again. Perhaps there are also other files that
> went missing, and if there's an underlying problem it'd be best to sort it
[quoted text clipped - 4 lines]
>
> Okay I'll try that but one thing I don't understand is why I'm the only person affected. All my other users can replicate ok but even if I create a new database and set up a new pull subscription I still get that error.

Reply to this Message

Paul Ibison - 26 Jan 2007 11:33 GMT

OK - if it is reproducible, then let's look a little deeper. After the
snapshot agent runs, does the file exist? Does the account that sql server
agent runs under (are you using push or pull?) have access to the repldata
share? Is there enough space on the subscriber?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

Reply to this Message

Spike - 26 Jan 2007 13:01 GMT

> OK - if it is reproducible, then let's look a little deeper. After the
> snapshot agent runs, does the file exist? Does the account that sql server
[quoted text clipped - 5 lines]
>
> Hi Paul

I've tried to run the snapshot agent but it fails with "The Agent is
suspect. No response after 30 minutes. I'm using pull subscription. I need
to get access to the server via PCAnywhere to verify that the file/path is
acessible by the SQLAgent account but that may take some time. So I'll get
back to you.
all the best
spike

Reply to this Message

confused - 29 Jan 2007 10:07 GMT

Hi,
Have you downloaded the SP4 hotfix (if your on SP4 that is!)

I downloaded and installed this;

http://support.microsoft.com/kb/916287

TIM

> > OK - if it is reproducible, then let's look a little deeper. After the
> > snapshot agent runs, does the file exist? Does the account that sql server
[quoted text clipped - 12 lines]
> all the best
> spike

Reply to this Message

Spike - 29 Jan 2007 10:10 GMT

> OK - if it is reproducible, then let's look a little deeper. After the
> snapshot agent runs, does the file exist? Does the account that sql server
[quoted text clipped - 5 lines]
>
> We've rebooted the server and that seems to have cleared everything up!

Thanks for your help, cheers spike

Reply to this Message