all groups > sql server replication > april 2004 >
You're in the

sql server replication

group:

cannot insert Null value into columns 'nicknames'


cannot insert Null value into columns 'nicknames' Noël Thoelen
4/7/2004 10:09:46 AM
sql server replication:
We have a merge replication on a database containing dynamic filters. At a
given moment one of the clients gets the following error during replication.

'The process could not make a generation at the Subscriber'
The error message is
'Cannot insert the value NULL into column 'nicknames', table
'vdavenne.dbo.MSMerge_genhistory'; column does not allow nulls.

Re: cannot insert Null value into columns 'nicknames' Paul Ibison
4/7/2004 10:35:26 AM
Noël ,
does the problem resolve itself when you restart the merge agent? If not,
please can you post up the script of your article and publication and I'll
have a play around with it.
Thanks,
Paul Ibison

Re: cannot insert Null value into columns 'nicknames' carlosf
4/28/2004 4:02:16 PM

You need SP3a or Microsoft's hot fix. Went through this pain mysel
about 2 months ago.

Good luck.

C

[quoted text, click to view]


-
carlos
-----------------------------------------------------------------------
Posted via http://www.mcse.m
-----------------------------------------------------------------------
View this thread: http://www.mcse.ms/message541971.htm
AddThis Social Bookmark Button