RSA AM 7.1 to 8.1Migration - RSA Authentication Manager 7.1 Migration Export Utility fails due to a large OFFLINE_DATAPUMP_SCN value.
2 years ago
Originally Published: 2014-01-24
Article Number
000047784
Applies To
RSA Authentication Manager 7.1 SP4

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
Issue
Performing an Authentication Manager 7.1 to Authentication Manager 8.1 migration.

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


Resolution
Bug AM-27973 open for this issue. CE currently working on a fix. Fix is scheduled for 8.1 Patch1.