January 21, 2004 at 8:32 am
Hello all,
Having an Issue setting up Merge replication on an NT 4.0 build 1381 SP 6 using Sql 7.00.961. The server has dual 400Mhz processors and 1G of RAM. The SQL Server had replication running before, but I needed to add fields to some of the tables and so had to remove replication to get them in. Now I am tring to get replication going again. The problem I am running into is that I can not create a publication. The error I get when looking at the Snapshot Agent is that "Another snapshot agent for the publication is running." When I look at the Event Viewer I have two "Information" events that occur one after the other until the Job fails. The first message from the MSSQLSERVER states
Error: 14152, Severity: 10, State: 1
Replication-Snapshot: agent SERVNAME-DBNAME-PUBLICATIONNAME-10 scheduled for retry. Timeout expired
This event is followed by one from the SQLSERVERAGENT and states
SubSystem Message - Job 'SERVNAME-DBNAME-PUBLICATIONNAME-10' (0x0898946C5DD43F47AC74928E81D7572F), step 2 - Timeout expired
Those two messages bounce back and forth until I get this message from the MSSQLSERVER
Error: 14151, Severity: 18, State: 1
Replication-Snapshot: agent SERVNAME-DBNAME-PUBLICATIONNAME-10 failed. Another snapshot agent for the publication is running.
Which is followed by a message from the SQLSERVERAGENT
SubSystem Message - Job 'SERVNAME-DBNAME-PUBLICATIONNAME-10' (0x0898946C5DD43F47AC74928E81D7572F), step 2 - Another snapshot agent for the publication is running.
At first we thought the tables were too large to replicate together so I tried to create a publication with only two tables. One table has somewhere between 1 and 10 million records. The other had between 50,000 and 100,000 records. The results were the same when trying to create a publication with both those tables as it was when trying to publish all the tables in the database together. "Another snapshot agent for the publication is running"
Has anyone out there seen anything like this before.
Thank you in advance,
Matt
January 21, 2004 at 12:08 pm
Check in sysjobs for snapshot jobs of the old publications. I think that when reinstalling replication or droping publications, some objects where still created and that's why you cannot re create them.
If nothing works, try reinstalling replication, I mean disabling the distributor and re creating it and re creating once again all your publications.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply