cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 9

NPM is not showing any MAP ( Error: An unexpected error occurred.)

Hi

iam currently facing issue that NPM is not showing any MAP on NPM web with error "An unexpected error occurred

Already opened case but since last 5 days but Solarwinds engineers still not able to resolve this issue.

Here is OrionWeb.log errors

2018-03-13 13:09:19,924 [129] (1077) ERROR ASP.global_asax - (null)  Application_Error(29dbb515aa364f83ac2059fdb22db6e9)

System.Web.HttpException (0x80004005): Request timed out.

2018-03-13 13:09:34,921 [22] (1078) WARN  MapRunner - (null)  CreateMapTask{ID=711d0431-4953-44b2-a0a8-114bd08fa6d8.OrionMap,State=Aborted,Exception=ThreadAbortException:"Thread was being aborted."} failed at Queued

2018-03-13 13:09:34,924 [22] (1078) ERROR MapService - (null)  Error. Request aborted. System.Web.HttpApplication+CancelModuleException

System.Threading.ThreadAbortException: Thread was being aborted.

   at System.Threading.Monitor.ObjWait(Boolean exitContext, Int32 millisecondsTimeout, Object obj)

   at System.Threading.Monitor.Wait(Object obj, Int32 millisecondsTimeout, Boolean exitContext)

   at SolarWinds.MapStudio.Web.MapRunner.Execute(CreateMapParameters parameters)

   at MapService.CreateMap(CreateMapParameters parameters)

   at MapService.GetMap(String sessionId)

2018-03-13 13:09:34,928 [22] (1078) ERROR MapService - (null)  Unexpected error: System.Threading.ThreadAbortException: Thread was being aborted.

   at MapService.GetMap(String sessionId)

2018-03-13 13:09:34,930 [22] (1078) ERROR ASP.global_asax - (null)  Application_Error(e68f61fdb49b4f188ffd91b6ca0cccbd)

System.Web.HttpException (0x80004005): Request timed out.

2018-03-13 13:09:47,860 [127] (0) WARN  SolarWinds.InformationService.Contract2.InfoServiceProxy - (null)  Support! -- LONG RUNNING QUERY: 54529.4299 ms: SELECT MapStudioFiles.FileId, MapStudioFiles.FileName, MapStudioFiles.FileData, MapStudioFiles.Timestamp, MapStudioFiles.Owner, MapStudioFiles.UpdateUser, MapStudioFiles.IsDeleted, MapStudioFiles.LockUser, MapStudioFiles.FileType, MapStudioFiles.LockDate, MapStudioFiles.ComputerName

FROM Orion.MapStudioFiles

WHERE MapStudioFiles.FileId = '24612b9b-98a7-4462-9d95-dafd3ffd70cb' AND MapStudioFiles.IsDeleted = 0 AND MapStudioFiles.InstanceSiteId = 0 RETURN XML AUTO

2018-03-13 13:09:47,861 [Import 7071f116-a0dd-45d2-bb2d-4c5e1ed87e1b.OrionMap] (1073) WARN  MapRunner - (null)  CreateMapTask{ID=7071f116-a0dd-45d2-bb2d-4c5e1ed87e1b.OrionMap,State=Aborted,Exception=ThreadAbortException:"Thread was being aborted."} failed at Aborted

2018-03-13 13:09:47,862 [Import 7071f116-a0dd-45d2-bb2d-4c5e1ed87e1b.OrionMap] (1073) ERROR MapRunner - (null)  CreateMapTask{ID=7071f116-a0dd-45d2-bb2d-4c5e1ed87e1b.OrionMap,State=Aborted,Exception=ThreadAbortException:"Thread was being aborted."}

2018-03-13 13:09:57,267 [135] (1079) WARN  SolarWinds.VIM.Web.DAL.NetObjectDAL - (null)  PollingSource for viewType=NotVIMObject and id=300 was not found.

2018-03-13 13:09:57,274 [135] (1079) WARN  SolarWinds.VIM.Web.DAL.NetObjectDAL - (null)  PollingSource for viewType=NotVIMObject and id=300 was not found.

2018-03-13 13:10:04,832 [31] (1080) WARN  SolarWinds.VIM.Web.DAL.NetObjectDAL - (null)  PollingSource for viewType=NotVIMObject and id=207 was not found.

2018-03-13 13:10:04,838 [31] (1080) WARN  SolarWinds.VIM.Web.DAL.NetObjectDAL - (null)  PollingSource for viewType=NotVIMObject and id=207 was not found.

Can any one help me out

0 Kudos
7 Replies
Highlighted
Level 15

Re: NPM is not showing any MAP ( Error: An unexpected error occurred.)

Do you have SWQL studio installed? if so can you run this query and tell me if there any errors

SELECT MapStudioFiles.FileId, MapStudioFiles.FileName, MapStudioFiles.FileData, MapStudioFiles.Timestamp, MapStudioFiles.Owner, MapStudioFiles.UpdateUser, MapStudioFiles.IsDeleted, MapStudioFiles.LockUser, MapStudioFiles.FileType, MapStudioFiles.LockDate, MapStudioFiles.ComputerName

FROM Orion.MapStudioFiles

WHERE MapStudioFiles.FileId = '24612b9b-98a7-4462-9d95-dafd3ffd70cb' AND MapStudioFiles.IsDeleted = 0 AND MapStudioFiles.InstanceSiteId = 0

0 Kudos
Highlighted
Level 9

Re: NPM is not showing any MAP ( Error: An unexpected error occurred.)

Msg 208, Level 16, State 1, Line 1

Invalid object name 'Orion.MapStudioFiles'.

0 Kudos
Highlighted
Level 9

Re: NPM is not showing any MAP ( Error: An unexpected error occurred.)

Msg 207, Level 16, State 1, Line 2

Invalid column name 'InstanceSiteId'.

0 Kudos
Highlighted
Level 15

Re: NPM is not showing any MAP ( Error: An unexpected error occurred.)

And you ran this in SWQL studio?

0 Kudos
Highlighted
Level 9

Re: NPM is not showing any MAP ( Error: An unexpected error occurred.)

yes

0 Kudos
Highlighted
Level 12

Re: NPM is not showing any MAP ( Error: An unexpected error occurred.)

I had the same issue and after many weeks working with support and Devs they finally got a work around look below. DISCLAIMER (I don't know if they have a KB and I do not warrant or assume any risk as this is not an official release  or my own, but only that it seemed to work for me.  I do not take responsibility for any issues that may arise as I cannot predict issues.  As always make sure you back up your database and make sure you make snapshots or create backup copies of any original files you modify before you modify them.)  If you have any issues solar winds has a crack squad of engineers, devs, and support staff.

1. Backup the file below and save it outside the default directory

2. Edit the file (open in Notepad)

(YOUR INSTALL DIRECTORY):\Program Files (x86)\SolarWinds\Orion\Information Service\3.0\Schemas\SettingsSchema.xml

3. Insert the highlighted line: <allow operations="r" />

<?xml version="1.0" encoding="utf-8"?>
<schema xmlns="http://schemas.solarwinds.com/2008/12/InformationServiceSchema">
<informationModel>
<entity name="Orion.Setting" base="System.Entity" federate="true">
<accessControl>
<allow operations="r" />
<allow operations="ru" right="admin" />
</accessControl>

4. Save the file. The change will be picked up immediately, no services restarts are necessary.

After this maps work as expect.  Please reply on this forum if it works for you as that mayh prompt a faster KB release.  The devs did mention the map issue should be fixed in the next release however you never know if it really is that same issue so this should work till an official release documents that fix in the release notes.

Regards,

Highlighted
Level 10

Re: NPM is not showing any MAP ( Error: An unexpected error occurred.)

In a multi-poller environment with an extra webserver - I assume this change would have to occur on all pollers?  Or just the website servers?

0 Kudos