Procedure to archive audit logs manually from ARRFSYSAUDITLOG_MOBILE

Products

• CA Risk Authentication
• CA Advanced Authentication
• CA Advanced Authentication - Risk Authentication (RiskMinder / RiskFort)

Issue/Introduction

DB archiving is stopped only for ARRFSYSAUDITLOG_MOBILE table and it contains data from previous year, whereas it works fine for other tables. How to archive the records from ARRFSYSAUDITLOG_MOBILE manually?

Environment

Symantec Risk Authentication 9.1.x

Resolution

Our recommendation is to execute the attached script db_archival_script.sql to manually archive the old audit records from the table ARRFSYSAUDITLOG_MOBILE.

Note:
Please provide the date in the script in such a way that the data is moved in smaller chunks to avoid load on the DB.