Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

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
02:36, 8 May 2017

Tags

Classifications

Public