After running SCOM environment for a long time I got this error in Event Log:

Exception 'SqlException': Sql execution failed. Error 8115, Level 16, State 1, Procedure ManagedEntityTypeImageRebuild, Line 56, Message: Arithmetic overflow error converting IDENTITY to data type int.

Problem lies in the SP where a DELETE statement is executed instead of a TRUNCATE TABLE statement.