Cannot propogate to subscriber

I'm getting this error when I try to replicate
The schema script
'\\CVTDEESQL005\ETMSData\unc\CVTDEESQL005_ZenithSQ L_L_060104_ZenithSQL_L_060104\20070120231902\tblCa ll_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
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 .
|||"Paul Ibison" wrote:

> 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_ZenithSQ L_L_060104_ZenithSQL_L_060104\20070120231902\tblCa ll_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.
|||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 .
|||"Paul Ibison" wrote:

> 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 .
>
> 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.
|||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 .
|||"Paul Ibison" wrote:

> 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 .
>
> 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
|||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
"Spike" wrote:

>
> "Paul Ibison" wrote:
> 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
|||"Paul Ibison" wrote:

> 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 .
>
> We've rebooted the server and that seems to have cleared everything up!
Thanks for your help, cheers spike