RSA Authentication Manager 8.1
RSA Authentication Manager 7.1 Migration Export Utility
Fail to create migration user on primary
Problem occurred while creating migration user on primary.
java.sql.SQLException: Numeric Overflow
Numeric Overflow
Customer has AM 7.1 SP4 machine in which the value of Oracle SCN is greater than 2,147,483,647.
The scn value can be obtained by running an sql select command on the AM 7.1 Primary:
SELECT OFFLINE_DATAPUMP_SCN FROM RSA_REP.IMS_REPLICATION_SITES where IS_PRIMARY = 1;
Customer copied migration exporter utility from AM 8.1 Kit and tried to create a migration package.
Migration package creation process fails after checking permissions. Below is the CLU output. (Attached migrationExporter.log file)
Initiating export process
Starting preparation tasks
Performing prerequisite checks
Collecting system properties
Checking permissions
**********************************************************************
The export was unsuccessful.
For details, see the log files at: /home/qeuser/utility/logs/
Caused by: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute query; uncategorized SQLException for SQL [select replicatio0_.ID as ID28_, replicatio0_.SITE_ID as SITE2_28_, replicatio0_.TIME_STAMP as TIME3_28_, replicatio0_.DATABASE_NAME as DATABASE4_28_, replicatio0_.DATABASE_DOMAIN_NAME as DATABASE5_28_, replicatio0_.HOST_NAME as HOST6_28_, replicatio0_.PORT_NUMBER as PORT7_28_, replicatio0_.IS_SSL_ENABLED as IS8_28_, replicatio0_.IS_PRIMARY as IS9_28_, replicatio0_.IS_PLANNED_PROMOTION as IS10_28_, replicatio0_.SSL_CERT_DN as SSL11_28_, replicatio0_.ATTACHMENT_MODE as ATTACHMENT12_28_, replicatio0_.ADD_STATUS as ADD13_28_, replicatio0_.ONLINE_DATAPUMP_SCN as ONLINE14_28_, replicatio0_.OFFLINE_DATAPUMP_SCN as OFFLINE15_28_, replicatio0_.TABLESPACE_DIR as TABLESPACE16_28_, replicatio0_.INSTANCE_ID as INSTANCE17_28_, replicatio0_.SITE_NAME as SITE18_28_, replicatio0_.RSA_PRODUCTS as RSA19_28_ from RSA_REP.IMS_REPLICATION_SITES replicatio0_ where replicatio0_.HOST_NAME=? and replicatio0_.DATABASE_NAME=?]; SQL state [null]; error code [17026]; Numeric Overflow; nested exception is java.sql.SQLException: Numeric Overflow
Related Articles
Replication 1Number of Views How to recreate a replica package set for push in RSA ACE/Server 36Number of Views Token data has not been replicated to the replica instance error when listing tokens on Authentication Manager 7.1 4Number of Views Error: 'Unable to nominate <server name> as the new replica server' in RSA ACE/Server</body> 2Number of Views Generate a Replica Package 103Number of Views
Trending Articles
Passwordless Authentication in Windows MFA Agent for Active Directory – Quick Setup Guide RSA Authentication Manager 8.9 Release Notes (January 2026) RSA Authentication Manager Upgrade Process RSA Authentication Manager 8.7 SP2 Setup and Configuration Guide An example of SSO using SAML and ADFS with RSA Identity Management and Governance 6.9.x