Atlas maps not displaying on Orion website

Any word on this issue. We just upgraded from 12.0 to 12.2 and now have the same problem.

2018-02-13 11:22:06,681 [6] WARN  SolarWinds.InformationService.Contract2.InfoServiceProxy - Support! -- LONG RUNNING QUERY: 32929.818 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 = '461316d9-c3b6-4f56-9f89-15b2c6085337' AND MapStudioFiles.IsDeleted = 0 AND MapStudioFiles.InstanceSiteId = 0 RETURN XML AUTO

Hi,

     I did have this issue as well when I did a previous update to 12.0 or 12.1. It has been a while though I did not make a note of the specific cause and solution in our internal JIRA nor did I create a bookmark to the solution unfortunately. I do remember that I had to delete a few files from SolarWinds server and then rerun the Configuration Wizard to fix this.

After a quick search, I did find a page for this issue for NPM,

Unexpected Error: An error occurred while generating map (map name).OrionMap - SolarWinds Worldwide, LLC. Help and Suppo…

Hopefully that will fix the issue for you.

Thank you for the information.  Hopefully that will help someone reading this.  I actually just rebuilt my primary and secondary pollers over this, and the problem still exists.  Developers and support have both been working on the issue for a while.

Now i will say that support believes it is a folders permissions issue.  When i run the permissions checker, it always fails on 3 folders.  Two of them are Windows/temp folders.  Every time I verify, I find that the correct permissions are set.  When I ask PC to repair the folders, it will without any issues. I can immediately run permissions checker again and it passes.

In any case, I still get the error on the website right after.

Very strange. 

Okay, after much digging I found a solution that worked for me. Hopefully it will help others.

The problem for me came down a map handling difference between version 12 and 12.2 and the database maintenance tool does not really clean up all orphaned data sets.

1. In Network Atlas delete any map that was not in active use.
2. In Network Atlas access every active map and remove any unsupported Image files. They may have worked in version 12, but version 12.2 can not process them and will not throw an error when it comes across them. Network Atlas can identify the unsupported image file types when you open the map.
3. In the database run "Delete FROM [YourDBNamehere].[dbo].[MapStudioFiles] Where IsDeleted = ‘1’"
4. Run Database Maintenance locally on the polling engine.

You may be required to rebuild a few maps, but at least things will work again.

Hope this helps!!

Hi,

please see this KB Map issues after installing Orion Platform 2017.3 Hotfix 5 - SolarWinds Worldwide, LLC. Help and Support

especially the last part:

If the steps above did not resolve the issue, update the FileData type in the Orion Schema:

If you have EOC deployed, do not follow these steps. Changing the FileData type would break your EOC deployment.

1. Open the file "c:\Program Files (x86)\SolarWinds\Orion\Information Service\3.0\Schemas\OrionSchema.xml".
2. Find line <property name="FileData" type="System.Byte[]" />.
3. Replace the line with <property name="FileData" type="System.Binary" />.The only change is Byte[] to Binary.
4. Save the file. No need to restart services.
5. Reload the web page with maps.
6. Repeat the steps on every computer that is hosting the website (main, HA main, Additional Web Server).

So for the past 15 days I have been standing up a completely new 2016 environment, including SQL 2016.    After I started creating maps I found out that I was getting the same errors as my old 2012 environment.     The only thing I transferred was the .gif files I had created for my cisco devices and my satellite maps which are also in .gif format.   After I deleted the satellite pictures, the maps were able to be viewed on the website again. 

I would like to figure out why the satellite pics worked for so long but started failing on 12.1, but I just do not have time to figure it out as of yet.

hi, have you tried the KB I posted ealier today? your satellite pics will work in your maps when you make the change in orionschema.xml as advised.

Thanks for the post.   I will try that later today on my old environment to see if it resolves the issues there.   Will post after I have results one way or the other.

Thank you