Monitoring, Management & Location Tracking

Failure during 6.1.0 upgrade

After getting to update_db.pl, the migration can fail with an error like this:

Use of uninitialized value $args[0] in join or string at /usr/local/airwave/lib/perl/Mercury/DB/Q.pm line 191, <INFO> line 8.
ERROR: null value in column "poll_period_client_data" violates not-null constraint: update ap_group set poll_period_client_data=? where ap_group.id=? ( 12) at /usr/local/airwave/lib/perl/Mercury/DB/Q.pm line 191

6.1.1 will have a fix. Until that's available you can contact support for help or you can run these 3 commands:

# echo "update ap_group set poll_period_dot11_counters = 0 where poll_period_up_down=1800 and poll_period_dot11_counters=1800 and poll_period_mesh_data=1800 and poll_period_client_data=1800" | db
# root; make
# echo "update ap_group set poll_period_dot11_counters = 1800 where poll_period_dot11_counters=0 and poll_period_up_down=1800 " | db
After getting to update_db.pl, the migration can fail with an error like this:

Use of uninitialized value $args[0] in join or string at /usr/local/airwave/lib/perl/Mercury/DB/Q.pm line 191, <INFO> line 8.
ERROR: null value in column "poll_period_client_data" violates not-null constraint: update ap_group set poll_period_client_data=? where ap_group.id=? ( 12) at /usr/local/airwave/lib/perl/Mercury/DB/Q.pm line 191

6.1.1 will have a fix. Until that's available you can contact support for help or you can run these 3 commands:

# echo "update ap_group set poll_period_dot11_counters = 0 where poll_period_up_down=1800 and poll_period_dot11_counters=1800 and poll_period_mesh_data=1800 and poll_period_client_data=1800" | db
# root; make
# echo "update ap_group set poll_period_dot11_counters = 1800 where poll_period_dot11_counters=0 and poll_period_up_down=1800 " | db
After getting to update_db.pl, the migration can fail with an error like this:

Use of uninitialized value $args[0] in join or string at /usr/local/airwave/lib/perl/Mercury/DB/Q.pm line 191, <INFO> line 8.
ERROR: null value in column "poll_period_client_data" violates not-null constraint: update ap_group set poll_period_client_data=? where ap_group.id=? ( 12) at /usr/local/airwave/lib/perl/Mercury/DB/Q.pm line 191

6.1.1 will have a fix. Until that's available you can contact support for help or you can run these 3 commands:

# echo "update ap_group set poll_period_dot11_counters = 0 where poll_period_up_down=1800 and poll_period_dot11_counters=1800 and poll_period_mesh_data=1800 and poll_period_client_data=1800" | db
# root; make
# echo "update ap_group set poll_period_dot11_counters = 1800 where poll_period_dot11_counters=0 and poll_period_up_down=1800 " | db

Version History
Revision #:
1 of 1
Last update:
‎06-09-2014 09:13 AM
Updated by:
 
Labels (1)
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.