000038376 - Archer Manage Users page is slow to load and/or shows "No records to display" in RSA Archer

Document created by RSA Customer Support Employee on Feb 6, 2020
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000038376
Applies ToRSA Product Set: RSA Archer
RSA Product/Service Type: RSA Archer (On-Premise)
RSA Version/Condition: 6.6.0.4
IssueAccessing Administration -> Users is slow to load and/or results in "No records to display" as shown below.

User-added image
CauseIn this version, the Manage Users page retrieves a listing of users and also a listing of users who are currently logged in. Archer then joins the two lists together to generate the "Manage Users" page.

When the Archer maintenance job called "SessionCleanupJobHandler" is not running correctly as scheduled then the database table tblSession may grow to a very large size (>3000 rows) and cause this page to fail to load within the required time.
Resolution
  1. Verify the size of tblSession is more than 3000 rows using the query below.

    select count(*) from tblSession with(nolock)

  2. Verify the last SessionCleanupJobHandler StartTime is more than 24 hours in the past.
    The below query can be used to determine the last StartTime of this maintenance job:

    select top 1 EnqueueTime, StartTime, endTime, JobType from tblAsyncInstrumentation with(nolock) where jobtype like '%SessionCleanupJobHandler%' and starttime is not null order by EndTime desc

  3. Verify that there exists no "SessionCleanupJobHandler" job in Archer Control Panel -> Job Engine Manager -> Available Jobs -> Refresh
  4. If all the above is true, use the below steps to schedule the SessionCleanupJobHandler maintenance job.
    1. Archer Control Panel -> Plugins -> Job Engine Manager
    2. Menu in the upper left -> System Jobs
    3. Check only "Session Cleanup"
    4. Queue jobs -> Start Job Now -> Submit
    5. Ensure the job gets picked up into "Running Jobs" from the "Available Jobs" (bottom left) -> refresh the page.
  5. After 30 minutes, try accessing the Administration -> Users page again.

Attachments

    Outcomes