Operational Reports fail with "Query failed" error

Products

• Network Observability
• CA Performance Management
• Spectrum

Issue/Introduction

When running specific Operational Reports, the report fails to load, displaying a "Query failed. See the logs for details" error message. This behavior is typically observed in larger environments or specific reporting configurations.

Affected reports include:

• Current Ports Summary: All
• Current Ports Summary: Group
• Current Port Assets (Customizable): All

Environment

DX NetOps 25.4.x

Portal, Operational Reports (SRM-RIB), and Spectrum components

Cause

The query generation logic for these specific reports can be inefficient. The query structure may force the database to collect, deduplicate, and sort the entire dataset of port rows before applying filters. Under certain security and grouping configurations, this creates a heavy load on the database, resulting in a timeout before the report can be returned.

Resolution

This issue is resolved in DX NetOps 25.4.10 and later releases through DE209646. The query generation for these reports has been optimized to improve performance and prevent database timeouts.

To resolve this issue, upgrade your DX NetOps environment to version 25.4.10 or later.