Even after installing HotFix 2 and 3 to EOC 1.6.2, the error below appears:
There is a problem storing SolarWinds Server xxx module results from the SolarWinds Server
This article is appropriate for the following and assumes the upgrade to EOC 1.6.3 is not possible at the moment (EOC 1.6.3 rolls up the fixes and includes HotFix 4, which addresses alert table issues that may be related to this issue).
It also assumes that the configuration wizard for EOC was run and encountered the error below (as shown in the configwizard log):
2016-02-16 07:14:40,100  ERROR DBConfigProcessor - Error while executing script - String or binary data would be truncated.
The statement has been terminated..
2016-02-16 07:14:40,100  ERROR DBConfigProcessor - Failing Sql command:
-- Fill the EOC_Alert2 table
EXEC [dbo].[EOC_spFillEOC_Alert2] -1
2016-02-16 07:14:40,100  ERROR ConfigurationProgressScene - Error while executing script- String or binary data would be truncated.
The statement has been terminated.
EOC 1.6.2 with HotFix 2 and 3 installed
This could be due to the length of the column EOC_Alerts2.AlertMessage as 255, need to change its size.
Have your DBA do the following against the EOC database.
Steps to change alter column EOC_Alert2.AlertMessage in EOC installed DB:
TRUNCATE TABLE EOC_Alert2
SELECT OBJECT_NAME(PARENT_OBJECT_ID) AS TABLE_NAME, COL_NAME (PARENT_OBJECT_ID, PARENT_COLUMN_ID) AS COLUMN_NAME, NAME AS CONSTRAINT_NAME FROM SYS.DEFAULT_CONSTRAINTS WHERE OBJECT_NAME(PARENT_OBJECT_ID) ='EOC_Alert2' AND COL_NAME (PARENT_OBJECT_ID, PARENT_COLUMN_ID)='AlertMessage'
ALTER TABLE EOC_Alert2 DROP CONSTRAINT 'NAME-RETURNED-IN-ABOVE-QUERY'
ALTER TABLE EOC_Alert2 Alter COLUMN AlertMessage nvarchar(max)
ALTER TABLE EOC_Alert2 ADD DEFAULT ('') FOR AlertMessage
Note: All changes should be done only on the DB for the active EOC instance.