000029541 - Data Import fails with large files in RSA Archer

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

Article Content

Article Number000029541
Applies ToRSA Product Set: Archer
RSA Version/Condition: 5.x and 6.x
IssueDuring a large Data Import, some records were successfully imported, but others failed.  A second import of only the records that failed initially was successful. 
CauseThe Archer Services Account times out before the Data Import is completed.  
Although the Security Parameter setting for Session Timeout for the Archer Services Parameter can be modified via the Web UI, the Save and Apply buttons are disabled.
User-added image
ResolutionThe only way to change the Session Timeout option is via SQL.
  1. Perform a SQL Backup of the Instance database in case a restore is required.
  2. Increase the Archer Services Parameter Session Timeout from 30 minutes (default) to 6 hours by running the following SQL command against the Instance database.

UPDATE tblSecurityParameters
SET sec_prm_timeout=6, timeout_time_interval_id=1
WHERE sec_prm_name='Archer Services Parameter'

Possible timeout_time_interval values:

1 = Hours
2 = Minutes
3 = Days