5000 Row Limit Reached In Operational Reports

Products

• Network Observability
• Spectrum

Issue/Introduction

Users encounter a hard limit of 5000 rows when generating Operational Reports, which is insufficient for complete port summary or port detail reports․​​​

ERROR MESSAGE: "This field requires a numeric value no larger than 5000․ Enter a smaller number․" "Query timed out․"

SYMPTOMS:

• Cannot generate complete port summary or port detail reports

• Adjusting the UniversalList․Limit global attribute does not override this limit

CONTEXT: When attempting to run Operational Reports with large datasets

IMPACT: Administrators cannot view all required data in a single report

Environment

DX NetOps: 24.3.x, 25.4.x

Cause

By default, the query performs a many-to-many join between the table and global collections, leading to a combinatorial explosion and performance issues․ The 5000 limit prevents browser crashes and system degradation․

Resolution

Acknowledge that the 5000-item limit is an intentional performance safeguard within the RIBTableModel to prevent query timeouts and Portal degradation

NOTE: Requests to increase the limit are deferred until feature F60717 is completed and merged, planned for Q2.