Groups created are not displayed in the Orion Web Console

This article describes an issue where newly created groups are not displayed in the SolarWinds Orion Web Console. In some scenarios, the newly created groups are visible only from main Poller but not in Additional web console.

Also, multiple users may experience this issue even with full admin rights to Orion web console.

The Information Service v3 log  in C:\ProgramData\SolarWinds\InformationService\v3.0\ shows a warning message related to a missing limitation ID:

2017-06-21 16:11:59,434 [77] WARN  SolarWinds.Orion.Web.DAL.LimitationDALImplementation - w3wp| /LM/W3SVC/1/ROOT-1-131425203115569392| SolarWinds.Orion.Core.Reporting.DataTableQueryEntities.Query()| /orion/rendercontrol.aspx?ResourceID=13578&NetObject=N%3A7221&NamingContainer=ctl00%24ctl00%24ctl00%24BodyContent%24ContentPlaceHolder1%24MainContentPlaceHolder%24nodeResHost%24resContainer%24rptContainers%24ctl00%24rptColumn3&isNOCView=&currentUrl=aHR0cHM6Ly9tY2wtc3d3ZWIxLm1mbGRjbGluLm9yZy9Pcmlvbi9OZXRQZXJmTW9uL05vZGVEZXRhaWxzLmFzcHg_TmV0T2JqZWN0PU46NzIyMQ%3D%3D (null) Could not find limitation with id xxx.

InformationServiceV3\Orion.InformationService.log
2022-04-26 18:45:14,056 [143] WARN  SolarWinds.Orion.Web.DAL.LimitationDALImplementation - w3wp| /LM/W3SVC/2/ROOT-1-132954345021194925| SolarWinds.Orion.Web.DAL.ContainersTreeDAL.GetContainerNodesByStatus()| /Orion/Services/ContainersTree.asmx/GetContainerNodes (null)     Could not find limitation with id 39.

Similar issues with groups could generate that All Groups be presented as Root Level Groups and without Subgroups on the Widgets / resource "All Groups."

Normal behavior when selected view as root level is display the tree of groups like this image:

and wrong view was displaying all groups flat. 


 

• SWIS pub/sub
• DB connection problems
• Limitations

1. Go to the Views table and filter it based on the limitation ID mentioned in the warning message.

2. Take note of the View ID that has the limitation ID number shown in the warning message. This will serve as back up, or you may backup your Orion database.

3. From the Orion server, go to Start > All Programs > SolarWinds Orion > Advanced Features > Orion Database Manager.

4. Click Add Default Server to connect to the SQL server that hosts the Orion database.

5. Expand the SQL Server, and then right-click on your Orion database.
   

6. Select New Query.

7. Paste the following query:
   Note: xxx is the ID found in the warning message.

   -- 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.
   
   update views Set LimitationID = '0' where limitationID = 'xxx'

8. Click Execute Query.

9. Run the following query to clear the cache using Orion Database Manager:

   -- 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. 
   
   Delete from dbo.LimitationSnapshots
   Delete from dbo.ContainerMemberSnapshots
   Delete from dbo.PendingNotifications
   Delete from dbo.SubscriptionTags
   Delete from dbo.Subscriptions

10. Restart All SolarWinds Services on all Orion Servers

OPTION 2:
How to Clear Information Service Subscriptions in Orion Products