000036809 - Performance Issue observed due to large number of records in RSASESSION, SESSIONACSP and RSATRANSACTION tables in RSA Adaptive Authentication (on Premise) 7.3

Document created by RSA Customer Support Employee on Nov 15, 2018
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000036809
Applies ToRSA Product Set: Adaptive Authentication (OnPrem)
RSA Product/Service Type: Adaptive Authentication (OnPrem)
RSA Version/Condition: 7.0.3.x
IssueCustomer reported they see high response time from Adaptive Authentication and deadlocks seen in RSASESSION tables. On further investigation, it was found that the Scheduler session reaper schedule task was not cleaning these tables as it should have been causing records to keep growing which in turn caused performance issues.
ResolutionStop Adaptive Authentication and Scheduler and truncate the tables using the following queries

truncate table <RSA_CORE>.SESSIONACSP;
alter table <RSA_CORE_AA>.RSATRANSACTION disable constraint FK_TRANS_SESS_ID;
alter table <RSA_CORE_AA>.RSASESSION disable constraint FK_SESS_DEV_ID;
alter table <RSA_CORE_AA>.RSASESSION disable constraint FK_SESS_USERID;
truncate table <RSA_CORE_AA>.RSASESSION;
alter table <RSA_CORE_AA>.RSATRANSACTION enable constraint FK_TRANS_SESS_ID;
alter table <RSA_CORE_AA>.RSASESSION enable constraint FK_SESS_DEV_ID;
alter table <RSA_CORE_AA>.RSASESSION enable constraint FK_SESS_USERID;

After truncate start Adaptive Authentication and Scheduler.