Return
-
Title
Error: 'LiteSpeedLocal.dbo.LitespeedActivity'; column does not allow nulls. INSERT fails.
-
Description
Error may read: LiteSpeed Update Native Statistics job is failing error" cannot insert value null into database column"
or
"Procedure LiteSpeed_InsertUpdateDatabaseActivity, Line 57 Cannot insert the value NULL into column 'DatabaseID', table 'LiteSpeedLocal.dbo.LitespeedActivity'; column does not allow nulls. INSERT fails.when the Activity Manager Service runs.
-
Cause
Renaming a SQL Server database on this instance.
-
Resolution
The stored procedure that generates the error is:
LiteSpeed_InsertUpdateDatabaseActivity
LiteSpeed_UpdateDatabases (this is the one while returns null)So the customer can run this querySELECT *
FROM master.dbo.sysdatabases
GOorSELECT *
FROM sys.databases;
GOto list the databases on the server in question.Then run this query on the litespeed local
SELECT [ServerName]
,[DatabaseID]
,[DatabaseName]
,[LastBackupTime]
,[LastBackupActivityID]
,[Deleted]
FROM [LiteSpeedLocal].[dbo].[LitespeedDatabase]
and compare the two (or send the results to us)The customer will be comparing the "database" ID between the two tables. He should also take note of the servername listed in the local.WORKAROUND:
Run exec LiteSpeedLocal.dbo.LiteSpeed_ImportNativeHistory twice.
-
Defect ID
CR82797