System.Data.SqlClient.SqlException: There are no primary or candidate keys in the referenced table 'dbo.Users' that match the referencing column list in the foreign key 'FK_TabPermission_Users'.
Could not create constraint. See previous errors.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
IF (SELECT COLUMNPROPERTY( OBJECT_ID('dbo.[TabPermission]'),'UserID','AllowsNull')) IS Null
BEGIN
ALTER TABLE dbo.[TabPermission] ADD
UserID int NULL
ALTER TABLE dbo.TabPermission WITH NOCHECK ADD CONSTRAINT
FK_TabPermission_Users FOREIGN KEY
(
UserID
) REFERENCES dbo.Users
(
UserID
) NOT FOR REPLICATION
END
System.Data.SqlClient.SqlException: There are no primary or candidate keys in the referenced table 'dbo.Users' that match the referencing column list in the foreign key 'FK_ModulePermissionUsers'.
Could not create constraint. See previous errors.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
IF (SELECT COLUMNPROPERTY( OBJECT_ID('dbo.[ModulePermission]'),'UserID','AllowsNull')) IS Null
BEGIN
ALTER TABLE dbo.[ModulePermission] ADD
UserID int NULL
ALTER TABLE dbo.ModulePermission WITH NOCHECK ADD CONSTRAINT
FK_ModulePermissionUsers FOREIGN KEY
(
UserID
) REFERENCES dbo.Users
(
UserID
) NOT FOR REPLICATION
END
System.Data.SqlClient.SqlException: There are no primary or candidate keys in the referenced table 'dbo.Users' that match the referencing column list in the foreign key 'FK_FolderPermissionUsers'.
Could not create constraint. See previous errors.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
IF (SELECT COLUMNPROPERTY( OBJECT_ID('dbo.[FolderPermission]'),'UserID','AllowsNull')) IS Null
BEGIN
ALTER TABLE dbo.[FolderPermission] ADD
UserID int NULL
ALTER TABLE dbo.FolderPermission WITH NOCHECK ADD CONSTRAINT
FK_FolderPermissionUsers FOREIGN KEY
(
UserID
) REFERENCES dbo.Users
(
UserID
) NOT FOR REPLICATION
END
any thoughts on steps i can take to fix this or if it's something to be concerned about? i have a scheduler exception being thrown periodically that i wonder if this is related to?