Submit a ticketCall us

AnnouncementsWeb Help Desk Integrations eCourse

Looking to reduce response times? Sign up for our eCourse to learn how integrating Web Help Desk with Dameware Remote Support, Network Configuration Manager, Network Performance Monitor, and Server & Application Monitor can improve communication efficiencies.

Register here.

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

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

Created by Elvin Perez, last modified by Laura C on Feb 01, 2018

Views: 952 Votes: 0 Revisions: 7

Overview

This article details an issue in which the following error message occurs after installing HotFix 2 and HotFix 3 to EOC:

There is a problem storing SolarWinds Server xxx module results from the SolarWinds Server

 

Environment

EOC 1.6.2 with HotFix 2 and HotFix 3 installed.

 

Details

This article is appropriate for the following and assumes the upgrade to EOC 1.6.3 is not possible at the moment.

Note: 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.

Cause

This issue may be due to the length of the column EOC_Alerts2.AlertMessage as 255. You will need to change its size.

Resolution

Have your database administrator do the following against the EOC database. This will alter the column EOC_Alert2.AlertMessage in the EOC instance installed on your database:

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

 

  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

 

 

 

Last modified

Tags

Classifications

Public