Unexpected Website Error when viewing Orion on Mobile Devices

9/22/2020 1:19 PM

9/22/2020 1:19 PM

When  viewing Orion Web Console on Mobile devices it returns an error,



The article discusses how to address the error encountered when viewing the Orion Web Console on mobile devices

Orion Platform

On the dbo.Resources, the column for ViewColumn contain a value '0' that could not be parsed by the system:
 

-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.

SELECT TOP 1000 * FROM [dbo].[Resources]
WHERE ViewColumn = ‘0’

*Prior to performing any task below, make sure you have a back-up of your database

• Identify the View that has an issue being viewed on the Mobile Device
  • e.g

-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.

SELECT TOP 1000 * FROM [dbo].[Resources]
WHERE ViewID = 'ViewID with issues'

• Enable Table Editing
• Remove the Row with '0' on the "View Column"
• Afterward, restart the All Orion Services