Submit a ticketCall us

Systems Monitoring for Dummies
Our new eBook will teach you the fundamentals and help you create monitors and alerts that are effective, meaningful, and actionable. Monitoring is more than a checkbox on your to-do list. This free eBook will give you practical advice to help you succeed in all aspects of monitoring – discovery, alerting, remediation, and troubleshooting. Don’t miss out on this indispensable resource for newbies, experienced IT pros, and everyone in between. Register Now.

Home > Success Center > Enterprise Operations Console (EOC) > Error while executing script- String or binary data would be truncated

Error while executing script- String or binary data would be truncated

Created by Elvin Perez, last modified by MindTouch on Jun 23, 2016

Views: 109 Votes: 0 Revisions: 6

Problem

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 [5] 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 [5] ERROR DBConfigProcessor - Failing Sql command:

-- Fill the EOC_Alert2 table
EXEC [dbo].[EOC_spFillEOC_Alert2] -1
2016-02-16 07:14:40,100 [1] ERROR ConfigurationProgressScene - Error while executing script- String or binary data would be truncated.
The statement has been terminated.

Environment

EOC 1.6.2 with HotFix 2 and 3 installed

Cause

This could be due to the length of the column EOC_Alerts2.AlertMessage as 255, need to change its size.

Resolution

Have your DBA do the following against the EOC database.

 

Steps to change alter column EOC_Alert2.AlertMessage in EOC installed DB:

 

  1. Run the following query:
    TRUNCATE TABLE EOC_Alert2
  2. Run the following query:
    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'
  3. Run the following query:
    ALTER TABLE EOC_Alert2 DROP CONSTRAINT 'NAME-RETURNED-IN-ABOVE-QUERY'
  4. Run the following query:
    ALTER TABLE EOC_Alert2 Alter COLUMN AlertMessage nvarchar(max)
  5. Run the following query:
    ALTER TABLE EOC_Alert2 ADD DEFAULT ('') FOR AlertMessage

 

Note: All changes should be done only on the DB for the active EOC instance.

 

 

 

Last modified

Tags

Classifications

Public