Bug ID 460165: General Database Error when accessing Clusters or Templates page

Last Modified: Oct 16, 2023

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

Known Affected Versions:
11.3.0, 11.4.0, 11.4.1, 11.5.0, 11.5.1, 11.5.2, 11.5.3

Fixed In:
11.6.0, 11.5.4

Opened: May 01, 2014

Severity: 2-Critical

Related Article: K15775

Symptoms

On multi-blade chassis systems, the Templates and Clusters pages conflict. If you navigate to the Clusters page and then navigate to Templates, the Templates page will be blank and post a General Database Error, and vice versa.

Impact

Ability to configure via the UI is degraded. System posts an error in catalina.out: ERROR [TP-Processor3] application_005ftemplate.list_jsp:_jspService - Column not found: SLOT_ID in statement [SELECT LIMIT 0 10 OPTIMIZED * FROM app_template ORDER BY slot_id ASC].

Conditions

This occurs only in a multi-blade chassis system (i.e., where there is a Clusters page).

Workaround

Restart tomcat each time you want to use these pages.

Fix Information

Accessing Template and Cluster pages now load correctly.

Behavior Change

Guides & references

K10134038: F5 Bug Tracker Filter Names and Tips