Monitoring, Management & Location Tracking

Error loading page: lan_hostname does not exist

An error occurs when trying to load a page that contains client data (ex: APs/Devices > Monitor ; Users > Connected). The error looks something like this:

[Mon Mar 29 18:48:59 2010] [error] [client 192.168.223.21] get_objects() - DBD::Pg::st execute failed: ERROR: column t1.lan_hostname does not exist

WHAT'S GOING ON:
Prior to upgrade
- On the Client table in the UI the user has selected the "LAN Hostname" column to sort on
- This is entered into the list_pref table in the db
The AMP is upgraded to 7.0 
- bug in building page is introduced
- customer tries to load page
- page crashes

HOW TO FIX IT:

Verify that this is the correct issue:

# dbc "select * from list_pref where sort_field = 'lan_hostname';"

Does the query return entries where sort_field = 'lan_hostname'? 

If so, delete those entries:

# dbc "delete from list_pref where sort_field = 'lan_hostname';"

Reload page to check that all is well. 

Customer should upgrade to 7.0.2 when available.

Version history
Revision #:
1 of 1
Last update:
‎06-17-2014 09:28 AM
Updated by:
 
Contributors
Search Airheads
Showing results for 
Search instead for 
Did you mean: 
Is this a frequent problem?

Request an official Aruba knowledge base article to be written by our experts.