Network Management

Cannot create HA Pool on the Orion Server - ValidatePoolNameAndMembers is case sensitive for ServerType = 'MainPollerStandby'

Cannot create High Availability (HA) Pool - Server Orion: We are having difficulty connecting to the Orion Server, due to bad character as uppercase in servertype.

First published date

10/22/2018 1:54 PM

Last published date

12/24/2019 11:23 AM

Overview

Cannot create HA Pool on the Orion Server - Difficulty connecting due to case sensitive server type.

  • SolarWinds.Orion.HighAvailability.Swis.Verbs.Pools.ValidatePoolNameAndMembers(Nullable`1 poolId, String displayName, IEnumerable`1 poolMembers)
  • 2018-03-21 12:22:56,959 [7] ERROR SolarWinds.InformationService.Core.InformationService - (null) (null)  Exception caught in method SolarWinds.InformationService.Core.InformationService.Invoke
  • System.NullReferenceException: Object reference not set to an instance of an object.
  • SolarWinds.Orion.HighAvailability.Common.DataAccess.Extensions.GetPoolType(PoolMember member
  • SolarWinds.Orion.HighAvailability.Swis.Verbs.Pools.CheckPoolMembersTypes(IEnumerable`1 poolMembers)
  • at System.Linq.Enumerable.WhereSelectListIterator`2.MoveNext()
  • at System.Linq.Enumerable.WhereEnumerableIterator`1.MoveNext()
  • at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source, Func`2 predicate)

Product section

Network Performance Monitor

Cause

Case sensitive issues with pool members and server type.

SolarWinds.Orion.HighAvailability.Swis.Verbs.Pools.ValidatePoolNameAndMembers(Nullable`1 poolId, String displayName, IEnumerable`1 poolMembers)

 

HA server type is case sensitive: 'MainPollerStandBy' to 'MainPollerStandby'. Someone appears to have edited the name to 'MainPollerStandBy' in DB manager. The correct solution is to delete the records and HA will recreate them correctly.

 

Example:

PoolMemberId   PoolMemberType             PoolId

1                            MainPoller                         NULL

4                            MainPollerStandBy          NULL

5                            AdditionalPoller               NULL

Resolution

Update HA_poolMembers.

Set poolmemberType = 'MainPollerStandby'

Where poolmemberID = 4

 

Fix the upper case B in Standby:

PoolMemberId   PoolMemberType             PoolId

1                            MainPoller                         NULL

4                            MainPollerStandby          NULL

5                            AdditionalPoller               NULL

 
You can now create HA pools without error.