Post reply

Cannot insert the value NULL into column 'rowguid'

  • May 19, 2008 at 4:41 am

    #380585

    I'm using SQL Server 2005 and have merge replication with 1 publisher and 9 subscribers.

    When I try to add a record to a publisher table I get the following error from time to time (sometimes it works fine, sometimes it doesn't):

    Cannot insert the value NULL into column 'rowguid'

    The rowguid column has the following properties:

    Data type: uniqueidentifier

    Default Value or Binding: (newsequentialid())

    Allow Nulls: no

    Replication is running fine for the rest.

    Here I have some logging and as you can see the rowguid column is not in the insert statement: http://www.tronk.be/server.log

    Any help or comments are very much appreciated. Thanks in advance.

  • May 23, 2008 at 9:41 am

    #819786

    Rowguid is the SQL Server generated unique identifier field to create synchronization in merge replication. It should NEVER be null. Something, somewhere else is wrong, that is causing the Rowguid to be null.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply