000014720 - In RSA Archer Data Feeds, a large number of User Names are listed in the Feed Information section on the General tab

Document created by RSA Customer Support Employee on Jun 16, 2016•Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 3Show Document
  • Comment • 0
  • View in full screen mode

Article Content

Article Number000014720
Applies ToRSA Product Set: Archer
RSA Version/Condition: 5.x
IssueThere are a large number of User Names are listed in the Feed Information section on the General tab, but there is not a way to remove these user accounts from Manage Users.
User-added image
CauseThe User Name list will grow as Data Feeds are added/updated/deleted.
ResolutionFor normal user accounts, DO NOT use the steps below.  Instead, go to Manage Users or use API or use the Bulk User Manager tool: https://community.rsa.com/docs/DOC-32416.
For Data Feed user accounts, try the following:
  1. Logout of Archer.
  2. Clear the browser and Silverlight cache.
  3. Get a list of Data Feed user accounts by running the following SQL query against the Instance database:
    SELECT * FROM tblUser WHERE user_type_id = 4

  4. Take note of the user_id you want to delete.
  5. Perform a SQL Backup of the Instance database.
  6. Delete the Data Feed user account by running the following SQL command against the Instance database after replacing ### with the user_id from step 4:
    DELETE FROM tblUser WHERE user_id = ###

  7. Login to Archer and confirm the User Name has been deleted.
NOTE: Below is a list of the user types and their corresponding code:
1 = General User 
2 = Service Account 
3 = Sysadmin 
4 = Datafeed Service 
5 = Migration User
Legacy Article IDa67599

Attachments

    Outcomes