000029064 - RSA AM 7.1 to 8.1Migration - RSA Authentication Manager 7.1 Migration Export Utility fails

Document created by RSA Customer Support Employee on Jun 15, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000029064
Applies ToRSA Product Set: SecurID
RSA Product/Service Type: Authentication Manager
RSA Version/Condition: 7.1
 
Issue

The Customer copied the migration exporter utility from the AM 8.1 Kit and tried to create a migration package. It failed with the following output.


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/


The log gives the following error. 



@@@2014-11-07 12:42:52,951, [Thread-2], (MigrationServiceImpl.java:378), trace.com.rsa.ims.migration.service.impl.MigrationServiceImpl, ERROR, imcltrsar1.duke-energy.com,,,,Fail to create migration user on primary 

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 

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83) 

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) 

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) 

at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424) 

at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:410) 

at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411) 

at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374) 

at org.springframework.orm.hibernate3.HibernateTemplate.findByNamedQuery(HibernateTemplate.java:979) 

at com.rsa.ims.common.dal.impl.GenericHibernateDao.findByNamedQuery(GenericHibernateDao.java:69) 

at com.rsa.ims.common.service.impl.GenericManagerImpl.findByNamedQuery(GenericManagerImpl.java:50) 

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 

at java.lang.reflect.Method.invoke(Method.java:597) 

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309) 

at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) 

Cause

The customer has an 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 the following sql select command on the AM 7.1 Primary:
SELECT OFFLINE_DATAPUMP_SCN FROM RSA_REP.IMS_REPLICATION_SITES where IS_PRIMARY = 1;

ResolutionThis issue was fixed in the migration utility included with AM 8.1 P1 and all newer patches. Use the newest migration utility to get the fix for this issue and any other migration errors that might have been discovered along the way. All patches at least through P5 have included a copy of the migration utility in the patch zip file.
See Patches on SecurCareOnline here
https://knowledge.rsasecurity.com/scolcms/sets.aspx?product=auth_manager&_v=download
 

Attachments

    Outcomes