Submit a ticketCall us

Bridging the ITSM Divide
Integrated help desk and remote support software for faster resolution

Join us on Wednesday, November 29, 2017 at 11 a.m. CT, as we discuss the benefits of effectively integrating your help desk software with remote support solutions to help increase the efficiency of IT administration, improve communication, and decrease mean time to resolution (MTTR) for IT issues of all sizes. This directly impacts end-user satisfaction and your business’ bottom line. Register Now.

Home > Success Center > Network Performance Monitor (NPM) > Cannot insert the value NULL into column 'FileId', table 'NetPerfMon.dbo.MapStudioFiles

Cannot insert the value NULL into column 'FileId', table 'NetPerfMon.dbo.MapStudioFiles

UPDATED August 9, 2016

Overview

The following error appears when creating a new map in Network Atlas:

2016-07-14 13:09:03,254 [59] ERROR SolarWinds.InformationService.Core.InformationService - (null) Exception caught in method Invoke
System.Data.SqlClient.SqlException (0x80131904): Cannot insert the value NULL into column 'FileId', table 'NetPerfMon.dbo.MapStudioFiles'; column does not allow nulls. INSERT fails.
The statement has been terminated.
at SolarWinds.InformationService.Verb.VerbExecutor.Invoke(Object hostInstance, Object[] parameters)
at SolarWinds.InformationService.Verb.VerbExecutorContext.Invoke()
at SolarWinds.InformationService.Core.InformationService.InvokeInternal[T](String entity, String verb, Action`1 setupParameters, Func`2 extractReturnValue)
at SolarWinds.InformationService.Core.InformationService.Invoke(String entity, String verb, XmlElement[] parameters)
ClientConnectionId:1d696148-183f-4837-858f-a0ed7f65271c

Environment

  • All NPM versions
  • Network Atlas 1.14.0.42 on any system

Cause 

There is a missing constraint on the table.

Resolution

Run the following SQL commands:

ALTER TABLE [dbo].[MapStudioFiles] ADD CONSTRAINT [DF_MapMakerFiles_FileId] DEFAULT (newid()) FOR [FileId]

ALTER TABLE [dbo].[MapStudioFiles] ADD CONSTRAINT [PK_MapMakerFiles] PRIMARY KEY CLUSTERED ([FileId] ASC)

 

Last modified

Tags

Classifications

Public