000035314 - Unable to delete a user from the UI in RSA Security Analytics 10.6

Document created by RSA Customer Support Employee on Jul 14, 2017Last modified by RSA Customer Support on Jun 28, 2018
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000035314
Applies ToRSA Product Set: Security Analytics
RSA Product/Service Type: SA Security Analytics UI
RSA Version/Condition: 10.6.X
 
IssueWhen you delete a user from the UI - Administration > Security > Users tab, the user is not removed from the Users list.
 
CauseYou can see "Referential integrity constraint violation" errors similar to the following one in the /var/lib/netwitness/uax/logs/sa.log file:
 

Error: org.h2.jdbc.JdbcSQLException: Referential integrity constraint violation:
"FKD5CE1B1A48FD7373: PUBLIC.SHARED_DASHBOARD FOREIGN KEY(DASHBOARD_ID)
REFERENCES PUBLIC.DASHBOARD(ID) (490)"; SQL statement: delete from Dashboard where user_id =
(select id from Users where id = 192) [23503-172]
ResolutionPerform 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

Attachments

    Outcomes