Submit a ticketCall us

Announcing NPM 12.2
With NPM 12.2 you can monitor your Cisco ASA firewalls, to monitor VPN tunnels for basic visibility and troubleshooting tunnels. NPM 12.2 also uses the SolarWinds Orion Installer so you can easily install and upgrade one or more Orion Platform products simultaneously.
See new features and improvements.

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: 69 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