Bug ID 1085973: Merge query failure when generating DNS Profiles report on multi-bladed platform

Last Modified: Apr 12, 2022

Bug Tracker

Affected Product:  See more info
BIG-IP AFM, AVR(all modules)

Opened: Mar 10, 2022
Severity: 3-Major

Symptoms

When generating a 'DNS Profiles' report from a multi-bladed platform, monpd generates the following error. SELECT SQL_CALC_FOUND_ROWS name `name`, FACT.id `id`,sum(noerrors) `avg_noerrors`,sum(queries) `avg_queries`,sum(rejects) `avg_rejects` FROM AVR_TMP_MERGE_STEP2 FACT WHERE FACT.id <> -2 AND FACT.id <> -1 GROUP BY 2 HAVING ( NOT ISNULL (avg_noerrors) OR NOT ISNULL (avg_queries) OR NOT ISNULL (avg_rejects) ) ORDER BY avg_noerrors DESC LIMIT 10 Because : Unknown column 'noerrors' in 'field list' REPORTER|ERROR|Mar 01 18:54:59.932|5623|../src/reporter/handlers/ReportRunnerHandler.cpp:runReport:0409| Results for query came back as NULL REPORTER|ERROR|Mar 01 18:54:59.932|5623|../src/reporter/ReporterUtils.cpp:throwInternalException:0105| throwing exception to client error code is 1 error msg is Internal error

Impact

Errors under monpd.log file. Report for DNS-profile fails.

Conditions

1. Generating AVR report for a DNS profile on a chassis 2. BIG-IP v14.X installed

Workaround

None

Fix Information

None

Behavior Change