Error with conflicts | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Error with conflicts

I have a SQL 7.0 with SP3 and several transactional and merge replications. There are some tables used in more then one merge replication. Sometimes we got an OS error 53 or OS error 5 with description: The process could not read file ‘\FTPSERVERFTPROOTftpSERVERNAME_DB_MERGEREPLICATION20031109013004Tablename.cft’
due to OS error 53. Is there anyone who can help me with this issue? Should I use a table in just one merge replication or is it no problem to use it in more then one replication. The files are physicly available in the right directory and I can connect to the share from the sql server and see the cft file and run it in the query analyzer. Tom
Mproof
How about privileges for SQL service account on this path? _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
Privileges are all properly set. The SQL service account has all rights on the directory and I can logon with the SQL account on the Windows 2000 Server and then browse to that directory and read the files.
Take hold of this KBAhttp://support.microsoft.com/defaul…port/kb/articles/Q240/6/88.asp&NoWebContent=1 to fix the issue. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
This KB article I didnot find before. I will take a look at it and see if it is the solution for my problem. Keep you informed if it helped.
While I was sneaking thru KBA search found this so thought this would help to fix the issue. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
Unfortunately, checked everything in this article (it is one for network replication, and I am using FTP replication) and I still have the errors. The strange thing is that it is not always that there is an error 53. Sometimes the error is logged in the conflict table but most of the times it is not logged. Any other suggestions? Thanks, Tom
How about to reinstall sp3, better sp3a? Sorry, SP4.
Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
Bertrand Russell
Check whether any network issues during the message is logged and overall it looks as a privilege issue from SQL service account. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
Try to monitor the activity with PROFILER while using this FTP process, as you say its not consistent try to monitor the operation closely. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
I will first upgrade all sites to SP4. Then I will generate the snapshot on the same machine as the SQL server (and copy it manually to the FTP server).
That would help, as a general tendency its recommended to keep all instances on same service pack. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
]]>