Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > Enterprise Operations Console (EOC) > There is a problem storing NCM module results

There is a problem storing NCM module results

Updated May 4, 2017

Overview

The following error message is displayed when polling or storing NCM module results from the SolarWinds server in EOC:

There is a problem storing NCM module results.

EOC: There is a problem storing NCM module results

 

The following error is also seen in the EOC.PollingService.log file:

2017-04-27 03:50:08,268 [10] 2 Orion.Module.NCM ERROR SolarWinds.EOC.PollingService.JobHandlers.OrionPollJobResultHandler - Error committing data for table 'EOC_NCM_GlobalSettings'
System.Data.SqlClient.SqlException (0x80131904): Received an invalid column length from the bcp client for colid 3.
[..]
Error Number:4815,State:1,Class:17

Environment

EOC 1.6.3 and earlier

Cause 

The Error Number:4815,State:1,Class:17 message in the EOC.PollingService.log file suggests a data compatibility issue, mostly the data length on a bulk copy (bcp). The error message also shows which table (EOC_NCM_GlobalSettings) and column (colid 3) it relates to. In this case, the SettingValue column is affected.

Resolution

As a workaround, either make the EOC table's column of the same data length or apply maximum size to the column using the following example query:

DELETE FROM [dbo].[EOC_NCM_GlobalSettings] 

ALTER TABLE [dbo].[EOC_NCM_GlobalSettings]
ALTER COLUMN [SettingValue] [varchar](max) NOT NULL;

Note: To copy content without line numbers, hover over the text and click the view source button (View Source). This opens a new window where you can select and copy text without any formatting or line numbering.

 

 

Last modified

Tags

Classifications

Public