Last Modified: Sep 13, 2023
Affected Product(s):
BIG-IP APM
Known Affected Versions:
11.6.2 HF1, 11.2.1, 11.3.0, 11.4.0, 11.4.1
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 Article:
K16394
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)
Custom Report cannot be created. The 'Available Fields' show infinitely in Custom Report UI.
If a connection issue or a database problem occurs the first time a user tries to create a custom report
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.
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.