Error in AVI Load Balancer "Sorting by Health Score is disabled on sets with more than 200 objects. Please select a different parameter for sorting"

Products

• VMware Avi Load Balancer

Issue/Introduction

• In AVI load balancer when attempting to sort pools containing more than 200 items by the Health Score parameter.
  
  • "Sorting by Health Score is disabled on sets with more than 200 objects. Please select a different parameter for sorting"
  • 
• On the controller leader node under the /var/lib/avi/log/portal_exception.log, you will notice the same error.

  • 2026-02-16 17:13:10,908] ERROR [db_cache.get_parents:167] ^[[31mdb_cache get parents for VsVip without slug or uuid args^[[0m
    [2026-02-16 17:13:10,978] ERROR [error_handler.process_exception:95] ^[[31mData Exception in GET /api/pool-inventory/ : ^[[0m
    Traceback (most recent call last):
      File "/usr/local/lib/python3.8/dist-packages/django/core/handlers/base.py", line 132, in get_response
        response = wrapped_callback(request, *callback_args, **callback_kwargs)
      File "/usr/local/lib/python3.8/dist-packages/django/views/generic/base.py", line 71, in view
        return self.dispatch(request, *args, **kwargs)
      File "/usr/local/lib/python3.8/dist-packages/django/views/decorators/csrf.py", line 58, in wrapped_view
        return view_func(*args, **kwargs)
      File "/usr/local/lib/python3.8/dist-packages/rest_framework/views.py", line 404, in dispatch
        response = self.handle_exception(exc)
      File "/usr/local/lib/python3.8/dist-packages/rest_framework/views.py", line 401, in dispatch
        response = handler(request, *args, **kwargs)
      File "/opt/avi/python/lib/avi/rest/api_perf.py", line 132, in _perf
        rsp = f(*args, **kwargs)
      File "/opt/avi/python/bin/portal/api/views_inventory.py", line 915, in get
        return self.get_with_sorted_health_score(request, sort_field,
      File "/opt/avi/python/bin/portal/api/views_inventory.py", line 799, in get_with_sorted_health_score
        raise DataException("Sorting by Health Score is disabled on sets with more than 200 objects. Please select a different parameter for sorting.")
    avi.rest.error_list.DataException: Sorting by Health Score is disabled on sets with more than 200 objects. Please select a different parameter for sorting.
    [2026-02-16 17:13:10,991] ERROR [db_cache.get_parents:167] ^[[31mdb_cache get parents for VsVip without slug or uuid args^[[0m
    [2026-02-16 17:13:11,092] ERROR [db_cache.get_parents:167] ^[[31mdb_cache get parents for VsVip without slug or uuid args^[[0m 

Environment

• VMware AVI Load Balancer
  • 30.2.2-2p5

Resolution

• There is no workaround available.
  
  
• The issue will be fixed in the next maintenance releases.