Bug ID 1298501: The GUI order for TCP goodput is being ordered as a string but not a number.

Last Modified: May 29, 2024

Affected Product(s):
BIG-IP TMOS(all modules)

Known Affected Versions:
14.1.0, 14.1.0.1, 14.1.0.2, 14.1.0.3, 14.1.0.5, 14.1.0.6, 14.1.2, 14.1.2.1, 14.1.2.2, 14.1.2.3, 14.1.2.4, 14.1.2.5, 14.1.2.6, 14.1.2.7, 14.1.2.8, 14.1.3, 14.1.3.1, 14.1.4, 14.1.4.1, 14.1.4.2, 14.1.4.3, 14.1.4.4, 14.1.4.5, 14.1.4.6, 14.1.5, 14.1.5.1, 14.1.5.2, 14.1.5.3, 14.1.5.4, 14.1.5.6

Opened: May 17, 2023

Severity: 3-Major

Symptoms

Sorting on TCP goodput in GUI is not working properly.

Impact

Unable to order/sort by the number on TCP goodput in GUI.

Conditions

When performing the sorting on the AVR goodput header in GUI. Statistics ›› Analytics: TCP: Goodput >> Change View By to "Remote Host IP Address" from Dropdown>> Average Connection Good through Put

Workaround

Login to BIG-IP and edit /etc/avr/monpd/monp_tcp_measures file and replace string("N/A") with NULL in the 'formula and merge_formula' properties of 'cs_avg_conn_goodput_rcv_m and cs_avg_conn_goodput_snt_m' fields, save and restart monpd service. Procedure: Step#1: Log in to BIG-IP CLI. Step#2: Edit the /etc/avr/monpd/monp_tcp_measures.cfg file. vi /etc/avr/monpd/monp_tcp_measures.cfg Exiting Code: ... [cs_avg_conn_goodput_rcv_m] formula=IF(SUM(avg_conn_goodput_rcv)=0,"N/A",ROUND(SUM(avg_conn_goodput_rcv)/SUM(cs_numendings),2)) merge_formula=IF(SUM(cs_avg_conn_goodput_rcv_m)=0,"N/A",ROUND(SUM(cs_numendings_m*cs_avg_conn_goodput_rcv_m)/SUM(cs_numendings_m),2)) ... [cs_avg_conn_goodput_snt_m] formula=IF(SUM(avg_conn_goodput_snt)=0,"N/A",ROUND(SUM(avg_conn_goodput_snt)/SUM(cs_numendings),2)) merge_formula=IF(SUM(cs_avg_conn_goodput_snt_m)=0,"N/A",ROUND(SUM(cs_numendings_m*cs_avg_conn_goodput_snt_m)/SUM(cs_numendings_m),2)) ... Replace "N/A" with NULL in Exiting Code: ... [cs_avg_conn_goodput_rcv_m] formula=IF(SUM(avg_conn_goodput_rcv)=0,NULL,ROUND(SUM(avg_conn_goodput_rcv)/SUM(cs_numendings),2)) merge_formula=IF(SUM(cs_avg_conn_goodput_rcv_m)=0,NULL,ROUND(SUM(cs_numendings_m*cs_avg_conn_goodput_rcv_m)/SUM(cs_numendings_m),2)) ... [cs_avg_conn_goodput_snt_m] formula=IF(SUM(avg_conn_goodput_snt)=0,NULL,ROUND(SUM(avg_conn_goodput_snt)/SUM(cs_numendings),2)) merge_formula=IF(SUM(cs_avg_conn_goodput_snt_m)=0,NULL,ROUND(SUM(cs_numendings_m*cs_avg_conn_goodput_snt_m)/SUM(cs_numendings_m),2)) ... Step#3: Save the file and restart the monpd service. tmsh restart /sys service monpd

Fix Information

None

Behavior Change

Guides & references

K10134038: F5 Bug Tracker Filter Names and Tips