ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Advanced Authentication table migration questions

book

Article ID: 238061

calendar_today

Updated On:

Products

CA Strong Authentication CA Advanced Authentication CA Risk Authentication

Issue/Introduction

I need to migrate AA prod data from oracle 12c DB to 19c DB. I noticed one table ARUDSUSERAUDITLOG has a very large size of data(27G). Can I omit this table during the data migration? what is the impact?

Environment

Release : 9.1

Component : Strong Authentication

Resolution

ARUDSUSERAUDITLOG is used by the UDS ( User Data Service ) and Stores user operation-specific detailed audit logging information. This table grows very fast because for every transaction, User is fetched first and that is Audit logged in this table. This table is used to run the report User Activity Report but not used in Transaction related reports like the Analyze Transaction report for Risk Authentication or Authentication Activity report for Strong Authentication. If the User activity report is not required then the data from this table can be skipped for Migration.