Return
-
Title
Error: "Cannot insert the value NULL into column 'PlanID', table 'LiteSpeedLocal.dbo.LSTrackingLo -
Description
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. -
Cause
The server name used in the LiteSpeed LogShipping set up does not match the SQL Server @@servername.
-
Resolution
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.