When setting up the LogShipping Plan, running SLS_LogShipping_AddPlan stored procedure,
The following error displays:
Server: Msg 515, Level 16, State 2, Procedure SLS_LogShipping_AddPlan, Line 214
Cannot insert the value NULL into column 'PlanID', table 'LiteSpeedLocal.dbo.LSTrackingLog'; column does not allow nulls. UPDATE fails.
The statement has been terminated.
The server name used in the LiteSpeed LogShipping set up does not match the SQL Server @@servername.
WORKAROUND:
Verify the server name used in LogShipping for publisher and subscriber match the @@servername on each server.
User can run SELECT @@servername in Query Analyzer on each server to ensure the correct value.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy