Negative availability values in NetOps Operational Reports - DX NetOps Spectrum

Products

• Network Observability
• Spectrum

Issue/Introduction

NetOps Operational Reports for Availability show negative percentages (e.g., -200%) instead of the expected 0-100% range. This occurs specifically when viewing reports in the NetOps Portal that pull data from the Spectrum Report Manager (SRM).

Availability reports generated in the Portal contain negative values. This often follows a scenario where connectivity issues were recently resolved, but data remains incorrect.

Environment

• DX NetOps 24.3.x
• DX NetOps Spectrum 24.3.x
• Spectrum Reporting Database (MySQL)

Cause

This is caused by a product defect (DE194816). When Spectrum Security is disabled and multiple users exist in the database, the SRM RIB Service query planner incorrectly multiplies outages by the number of users. This results in a total downtime sum that exceeds the actual reporting period, driving the availability calculation into negative values.

Resolution

This issue is confirmed as a product defect.

• Targeted to be fixed in release: 25.4.9 (Feature F63557).
• Workaround: There is currently no manual configuration workaround. Ensure that the SRM-RIB service is updated once the fix release is available.

Users are encouraged to subscribe to this article to be updated on the fix status: How to subscribe to a Knowledge Base Article.

Additional Information

To verify if this specific defect is impacting your environment, run the following query in the Spectrum MySQL reporting database: SELECT COUNT(distinct vssal.user_name) as Usernames, COUNT(distinct vssal.security_string) as S_Strings FROM v_security_string_accessibility_by_landscape vssal; If Usernames is significantly higher than S_Strings, the environment is susceptible to this defect.