SQL Server Performance

Error with conflicts

Discussion in 'Performance Tuning for SQL Server Replication' started by mproof, Nov 18, 2003.

  1. mproof New Member

    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
  2. satya Moderator

    How about privileges for SQL service account on this path?

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  3. mproof New Member

    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.
  4. satya Moderator

  5. mproof New Member

    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.
  6. satya Moderator

    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
  7. mproof New Member

    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
  8. Luis Martin Moderator

    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
  9. satya Moderator

    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
  10. satya Moderator

    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
  11. mproof New Member

    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).
  12. satya Moderator

    That would help, as a general tendency its recommended to keep all instances on same service pack.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com

Share This Page