Submit a ticketCall us

Welcome to the NEW Success Center. Search all resources (documentation, videos, training, knowledge base articles) or browse resources by product. If you are unable to find what you are looking for, please contact us at customersuccess@solarwinds.com

 

 

 

 

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: 693 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
19:25, 22 Jun 2016

Tags

Classifications

Public