Thought this might be helpful to some.
Note: The folder you wish to delete MUST NOT have any devices or subfolders.
It's also worth noting that an ignored device counts as being something in the folder, so you can always check that by doing:
# dbc 'select * from ap where ap_folder_id=(id that appears in folder view URL)
# dbc 'select * from ap where ap_folder_id=1'
Can further be simplified to:
# dbc 'select id, name, state from ap where ap_folder_id=1'
This filters out the extra rows that don't matter if you're planning to delete the folder
Database AP States:
0 = pending
1 = approved
3 = ignored
I can't delete a subfolder, even if it is empty (also check with dbc command):
[root@airwave mercury]# dbc 'select id, name, state from ap where ap_folder_id=17'id | name | state----+------+-------(0 rows)
The GUI seems to accept the command "Delete this folder" but then the folder is still there.
Is there a way to force the deletion?
Here what the error log says:
delete_objects() - DBD::Pg::st execute failed: ERROR: update or delete on table "ap_folder" violates foreign key constraint "vpn_user_a"DETAIL: Key (id)=(17) is still referenced from table "vpn_user". [for Statement "DELETE FROM ap_folder WHEREid = ?" with ParamValues: 1='17'] at /usr/local/airwave/lib/perl/Mercury/DB/Q/st.pm line 20.at /usr/local/airwave/lib/perl/Mercury/DB/Q/st.pm line 20Mercury::DB::Q::st::execute('Mercury::DB::Q::st=HASH(0x7f2f29689148)', 17) [...]
Do I have to proceed with a support case?
At Aruba, we believe that the most dynamic customer experiences happen at the Edge. Our mission is to deliver innovative solutions that harness data at the Edge to drive powerful business outcomes.
© Copyright 2021 Hewlett Packard Enterprise Development LPAll Rights Reserved.