Bug ID 685727: GEO dimension query failure

Last Modified: Apr 28, 2025

Affected Product(s):
BIG-IP ASM, AVR(all modules)

Known Affected Versions:
13.0.0, 13.0.0 HF1, 13.0.0 HF2, 13.0.0 HF3, 13.0.1

Fixed In:
14.0.0

Opened: Sep 27, 2017

Severity: 3-Major

Symptoms

In ASM reports, when adding a filter to 'Client Countries' the filter creation fails. The system writes the following error in monpd log: SELECT SQL_CALC_FOUND_ROWS ..., FACT.country_code `id` ... Because : Unknown column 'vip_crc' in 'where clause'.

Impact

The filter creation fails.

Conditions

Adding 'Client Countries' filter to ASM reports.

Workaround

To work around this issue, perform the following procedure: 1. Edit /etc/avr/monpd/monp_asm_entities.cfg. 2. Remove the following line from section [asm_repev_geo]: dim_authz_filter=vip_crc. 3. Restart monpd.

Fix Information

This release removes dim_authz_filter=vip_crc from [asm_repev_geo] in monp_asm_entities.cfg.

Behavior Change

Guides & references

K10134038: F5 Bug Tracker Filter Names and Tips