Bug ID 451777: When creating a custom report, the 'Available Fields' show infinitely in Custom Report UI.

Last Modified: Oct 06, 2020

Bug Tracker

Affected Product:  See more info
BIG-IP APM(all modules)

Known Affected Versions:
11.2.1, 11.3.0, 11.4.0, 11.4.1, 11.5.0, 11.5.1, 11.5.1 HF1, 11.5.1 HF10, 11.5.1 HF11, 11.5.1 HF2, 11.5.1 HF3

Fixed In:
11.6.0, 11.5.1 HF5, 11.5.1 HF4, 11.4.1 HF6, 11.4.1 HF10, 11.4.0 HF8

Opened: Mar 10, 2014
Severity: 2-Critical
Related AskF5 Article:
K16394

Symptoms

When creating a custom report, the 'Available Fields' show infinitely in Custom Report UI. You might see messages similar to the following in /var/log/webui.log: model.LogParamBO:error - java.sql.SQLException: Unknown system variable 'CONTEXT' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127) at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362) at com.f5.model.db.DBConnection.executeNoRS(DBConnection.java:518) at com.f5.model.db.GeneralHelper.setContext(GeneralHelper.java:133) at com.f5.util.UsernameHolder.updateConnection(UsernameHolder.java:226) at com.f5.util.UsernameHolder.updateConnection(UsernameHolder.java:207) at com.f5.util.query.QueryBuilder.execute(QueryBuilder.java:44) at com.f5.tmui.accessctrl.handler.reports.sessionreport.dao.LogParamMetaDataDAO.getUIParams(LogParamMetaDataDAO.java:52) at com.f5.tmui.accessctrl.handler.reports.sessionreport.model.LogParamBO.loadLogParams(LogParamBO.java:68) at com.f5.tmui.accessctrl.handler.reports.sessionreport.model.LogParamBO.loadMetadata(LogParamBO.java:35)

Impact

Custom Report cannot be created. The 'Available Fields' show infinitely in Custom Report UI.

Conditions

If a connection issue or a database problem occurs the first time a user tries to create a custom report

Workaround

If the issue is with the database connection, restart tomcat. If it is installation issue, restart tomcat does not help. Must reinstall the BIG-IP software.

Fix Information

If a connection issue or a database problem occurs the first time that a user tries to create a custom report, an error message displays now.

Behavior Change