Newbie question about Replication error message

[JaybeeinTekTips]

Hi all, we've got a Replication problem, and I'm very new to replication. Here's the message:

MSG TEXT: EventID: 0x4000429C (17052) - Error: 14152, Severity: 10, State: 1

Replication-Replication Distribution Subsystem: agent OURSERVER-

On the advice of another board I've checked for blocking processes, there are none. I've also been advised to "modify the replication agent profile"...but I haven't got a clue what type of agent profile we're using, and then what parameters within it I'd need to change!

I've looked at Technet

http://technet.microsoft.com/en-us/library/ms151223.aspx,

but that's not specific to our current error message - I don't have time to learn Replication from scratch, I just need the fix....

Thanks,

 

[ptheriault]

This maybe a deadlock issue,
Enable the 1204 trace flag in your startup parameters. You will see more information on the error in your log.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[mrdenny]

What service pack are you running on the machines? What other text is there in the errorlog and application logs?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com