Perform the following tasks via SSH command line on the SA Server to manually delete the user from the database (H2DB):
1. Stop the web server and puppet
stop jettysrv service puppet stop
2. Run the following commands to grab the H2DB client::
wget http://edelivery.rsasecurity.com/patches/attach/nw/a66372/h2-1.3.172.jar
3. Copy the H2 client to the following folder:
cp h2-1.3.172.jar /var/lib/netwitness/uax/db/
4. Navigate on the CLI to the DB directory;
cd /var/lib/netwitness/uax/db
5. Access the H2DB;
java -cp h2-1.3.172.jar org.h2.tools.Shell -url jdbc:h2:file:platform
6. Execute the following SQL queries one by one (replace xxxxxxx by the user login):
delete from User_Preferences where user_id = (select id from Users where login = 'xxxxxxx'); delete from Notifications where user_id = (select id from Users where login = 'xxxxxxx'); delete from Users_Role where users_id = (select id from Users where login = 'xxxxxxx'); delete from UserPredicate where user_id = (select id from Users where login = 'xxxxxxx'); delete from UserConnectionAttribute where user_id = (select id from Users where login = 'xxxxxxx'); delete from Dashlet_Options where Dashlet_Id in (select Id from Dashlet where Dashboard_Id in (select Id from Dashboard where User_Id = (select id from Users where login = 'Vivek.Veettil'))); delete from Dashlet where Dashboard_Id in (select Id from Dashboard where User_Id = (select id from Users where login = 'xxxxxxx')); delete from Dashboard where user_id = (select id from Users where login = 'xxxxxxx'); delete from Favorite_Dashboard where user_id = (select id from Users where login = 'xxxxxxx'); delete from Shared_Dashboard where Dashboard_Id in (select Id from Dashboard where User_Id = (select id from Users where login = 'xxxxxxx'); delete from Users where login = 'xxxxxxx';
quit
7. Start the web server and puppet
start jettysrv service puppet start
|