Submit a ticketCall us

Training ClassSign up for Network Performance Monitor (NPM) and Scalability instructor-led classes

Attend our instructor-led classes, provided by SolarWinds® Academy, to discuss the more advanced monitoring mechanisms available in NPM as well as how to tune your equipment to optimize its polling capabilities. NPM classes offered:
NPM Custom Monitoring and Polling
Orion Platform Scalability

Reserve your seat.

Home > Success Center > Orion Platform > Orion - Knowledgebase Articles > Orion Maps fails to load and generates an error

Orion Maps fails to load and generates an error

Updated May 31, 2018

Overview

When you open the Orion Web Console, Orion Maps fails to load and displays the following error:

An item with the same key has already been added

When you open the Orionweb.log file, the following errors are recorded in the file:

ERROR MapService -
(null)  Unexpected error. SolarWinds.MapStudio.Web.MapRunnerFaultedException: An error occurred while generating map bde5d915-88bd-4ef8-a770-fa08806af7b4.OrionMap ---> System.ArgumentException: An item with the same key has already been added.
   at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource)
   at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add)
   at SolarWinds.MapEngine.FileSynchronization.GetFileList(MapStudioFileType fileType)
   at SolarWinds.MapEngine.FileSynchronization.SynchronizeFiles(MapStudioFileType fileType, Boolean doUpdate, Action`1 progressReportCallback)
   at SolarWinds.MapEngine.MapSynchronization.SynchronizeImportedAndUserGraphics(Boolean doUpdate, Action`1 progressReportCallback)
   at SolarWinds.MapEngine.MapSynchronization.GetSingleMapAndSubmap(SolarWindsIdentification swId, Boolean synchronizeUserGraphics)
   at SolarWinds.MapEngine.Engine.GetSingleMapAndAddTopEntities(SolarWindsIdentification swId, Boolean synchronizeUserGraphics)
   at SolarWinds.MapEngine.OrionEngine.GetMapWithoutLimitation(SolarWindsIdentification swId, Boolean disableViewLimitation, Boolean synchronizeUserGraphics)
   at MapImport.GetMapNetObject(CreateMapParameters parameters, StopwatchHelper sw, IEngine engine)
   at MapImport.SaveMap(CreateMapParameters parameters)
   at SolarWinds.MapStudio.Web.MapRunner.ImportThreadProc(Object obj)
--- End of inner exception stack trace ---
   at SolarWinds.MapStudio.Web.MapRunner.CreateMapTask.ThrowStateException()
   at SolarWinds.MapStudio.Web.MapRunner.Execute(CreateMapParameters parameters)
   at MapService.CreateMap(CreateMapParameters parameters)
   at MapService.GetMap(String sessionId)

Environment

  • All NPM versions

Cause 

Duplicated icon graphics in the MapStudioFiles table

Resolution

  1. Run the following query against your Orion database to see if your database has this issue:
    select [FileName] from dbo.MapStudioFiles where FileType=128 and IsDeleted = 
    0 group by [FileName] having count(FileId) > 1
  2. If the query does not generate results, you are finished. No intervention is required.

    If the query generates results, go to step 3.

  3. Back up the Orion SQL database.

    SolarWinds Backup can help you streamline this task.

  4. Run the following query to remove the duplicate files:
    DECLARE @file nvarchar(max)
    DECLARE cleanup_duplicated_pictures CURSOR FOR 
    select [FileName] from dbo.MapStudioFiles where FileType=128 and IsDeleted = 0 group
    by [FileName] having count(FileId) > 1
    OPEN cleanup_duplicated_pictures 
    FETCH NEXT FROM cleanup_duplicated_pictures INTO @file
    WHILE @@FETCH_STATUS = 0 
    BEGIN 
    delete from dbo.MapStudioFiles
    where FileId in
    ( select FileId from dbo.MapStudioFiles where [FileName] = @file and IsDeleted = 0 )
    and FileId not in
    ( select top 1 FileId from dbo.MapStudioFiles where [FileName] = @file and IsDeleted = 0 )
    FETCH NEXT FROM cleanup_duplicated_pictures INTO @file 
    END
    CLOSE cleanup_duplicated_pictures 
    DEALLOCATE cleanup_duplicated_pictures
 

 

Last modified

Tags

Classifications

Public