There are several DatabaseActivites (e.g., Commented on a Blog, Replied to a Blog Comment, Add a Showcase Site, Videos) that have been throwing errors like the following.
Activity: Videos
System.Data.SqlClient.SqlException (0x80131904): The INSERT statement conflicted with the FOREIGN KEY constraint "FK_CommunityMetrics_UserActivity_Users". The conflict occurred in database "[redacted]", table "dbo.Users", column 'UserID'. The statement has been terminated...
This needs to be resolved. Most likely it is due to user activity data for users that no longer exist in DNN.
There are several DatabaseActivites (e.g.,
Commented on a Blog,Replied to a Blog Comment,Add a Showcase Site,Videos) that have been throwing errors like the following.This needs to be resolved. Most likely it is due to user activity data for users that no longer exist in DNN.