Friday, February 24, 2012

cannot insert Null value into columns 'nicknames'

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.
Nol ,
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
|||You need SP3a or Microsoft's hot fix. Went through this pain myself about 2 months ago.
Good luck.
C

Quote:

Originally posted by Paul Ibison
Nol ,
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

No comments:

Post a Comment