Merge replication (sql2000-sql2000 sp3) job error

Last Post 28 Nov 2006 11:36 AM by sanjayattray. 2 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
school1282
New Member
New Member

--
14 Nov 2006 02:07 AM
Hello,
On merge relication between two servers (sql2000 sp3) I get following error
(in job history)

Executed as user: sa. Cannot insert the value NULL into column 'publisher', table 'tempdb.dbo.MSreplication_agent_status'; column does not allow nulls. INSERT fails. [SQLSTATE 23000] (Error 515) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.

after that, it is followed by:
The specified subscription type is invalid. The step failed.

and

The job failed. The Job was invoked by User sa. The last step to run was step 3 (Detect nonlogged agent shutdown.). The job was requested to start at step 1 (Merge Agent startup message.).

Please help me,...a.s.a.p

THANKS
Shabby
sanjayattray
New Member
New Member

--
28 Nov 2006 11:36 AM
Try stopping and starting the agent. If that fails, reboot SQL Server and If it still doesn't work, try this. go to Distribution Agent profiles and select (continue on data consistency error) option and restart services. when agent was succesfully then you can change it to default agent profile property. If all fails then my possible solution would be to drop and recreate replication.
sanjayattray
New Member
New Member

--
28 Nov 2006 11:36 AM
Also, if possible upgrade to SP4. SP4 upgrade needs server restart.


Acceptable Use Policy
---