Replication fails with error 18752 and 22017

[Thomas Henley]

SQL Server 7.0 SP3 running on Win2K SP3. Network
hiccupped and now logreader in database servicing three
publications will not run. gets error message "another
log reader is rep[licating the database" with error number
18752. ALso has error message "The process could not set
the last distributed transaction" with error number
22017.

Have tried changing query timeout from 300 to 900 and
ReadBatchSize to 100 from 500, with no success.
Knowledgebase has nothing specific on error number 22017.

Would prefer to restart if possible, because data being
replicated approaching 4 GB and cannot use snapshot to
restart because of table locking while DTS does it's
thing, so it will mean 5 - 6 hours overnight to bcp out
the large tables, copy to the subscriber server and then
bcp back into the proper tables.

Thanks for your help.

Tom

[Nick Schueler MS]

Hi Tom
Resolve the first error (18752) first. This may resolve the problem. The
second error may be related to the first.

Error 18752: Another log reader is replicating the database.
Error 22017: The process could not set the last distributed transaction.

To resolve the error Try stopping SQL Server Agent on the Distributor. It
sounds like there may be an orphaned spid for the Logreader agent. You
might try looking for the spid on the publisher and distributor using
sp_who2.

If Stopping and starting SQL Server agent does not work, and you are still
seeing the 18752 error, consider restarting the SQL Server service for the
publisher and distributor.

If error 22017 is still reported after the restart, then turn on verbose
logging for the logreader agent and attach the log to your email.

312292 HOW TO: Enable Replication Agents for Logging to Output Files in SQL
http://support.microsoft.com/?id=312292

Hope this helps.

Nick Schueler