SQL Server Performance

[SQLSTATE 23000] (Error 515) The statement has been terminated. [SQLSTATE 01000] (Error 3621).

Discussion in 'Performance Tuning for SQL Server Replication' started by sqldba_ind, Oct 12, 2007.

  1. sqldba_ind New Member

    Hi all I have a Job
    That got failed and thrown an error
    "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."
    any got this type of error or any body know about this error
    Help me regarding this issue
    Thanks in Advance
    sqldba_ind, Oct 12, 2007
    #2

  2. satya Moderator

    What was the order you setup while replication initiated:
    THe order must be:
    1. Setup replication between Main publisher and republisher (or the subscriber/publisher as you are calling it)
    2. Setup replication between republisher (or the subscriber/publisher as you are calling it) and the leaf subscriber.

    As per the error it is failing because there aren't any records in the parent table with matching values for the foreign key on column.

    satya, Oct 14, 2007
    #3

Share This Page