Migration Of Input Variable Failing - New ID Not Generating In Target Environment (Doc ID 3038907.1)

Last updated on AUGUST 06, 2024

Applies to:

Symptoms

While migrating Input Variable from source to Target in UI, its failing with below error

Filename : offline_migration.log 

See the following error: 

[WEB] [REVELEUS] Import-->TableinsertQuery::

insert into FSI_CSM_INPUT_VARIABLES_CD(APPLICATION_TYPE,CSM_BUS_TYPE_CD,CSM_CALC_FREQ_CD,CSM_CALC_MOVEMENT_CD,

CSM_CASHFLOW_BOUND_CD,CSM_CASHFLOW_CD,CSM_DEMOGRAPHY_CD,CSM_DISC_RATE_CD,CSM_EXPERIENCE_CD,

CSM_FIN_ELEM_CD,CSM_RISK_TYPE_CD,CSM_TRANS_TYPE_CD,EDITABLE_FLG,ENABLED_FLG,EP_FLAG,

EVENT_DATE_TYPE,INPUT_VARIABLE_CODE,REINS_FLG,VARIBALE_ORIGIN,VAR_IDENTIFIER_NAME)

values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

[WEB] [REVELEUS] Import-->Records Processed so far:::0

[WEB] [REVELEUS] Import--> Error::ORA-00001: unique constraint (ATOMIC.IDX_CSM_INPUT_VARIABLES_CD_1) violated

java.sql.BatchUpdateException: ORA-00001: unique constraint (ATOMIC.IDX_CSM_INPUT_VARIABLES_CD_1) violated

at com.ofs.fsapps.commonapps.migration.FSIMetaDataMigration.parseTableDataFromXML(FSIMetaDataMigration.java:959) ~[commonapps_migration.jar:?]

at com.ofs.fsapps.commonapps.migration.FSIMetaDataMigration.importObject(FSIMetaDataMigration.java:644) ~[commonapps_migration.jar:?]

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_401]

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_401]

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_401]

at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_401]

at com.ofs.reveleus.migration.core.ImportMigratorThread.invokeMigrationAPI(ImportMigratorThread.java:311) ~[migration.jar:?]

at com.ofs.reveleus.migration.core.ImportMigratorThread.migrateObject(ImportMigratorThread.java:162) ~[migration.jar:?]

at com.ofs.reveleus.migration.core.ImportMigratorThread.run(ImportMigratorThread.java:69) ~[migration.jar:?]

at com.ofs.reveleus.migration.service.OfflineMigrationService.startImportProcess(OfflineMigrationService.java:205) ~[migration.jar:?]

at com.ofs.reveleus.migration.service.MigrationServiceProvider.importRuleset(MigrationServiceProvider.java:1039) ~[migration.jar:?]

at com.ofs.reveleus.migration.service.MigrationRESTService.invokeMigrationService(MigrationRESTService.java:119) ~[migration.jar:?]

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_401]

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_401]

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_401]

at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_401]

at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory.lambda$static$0(ResourceMethodInvocationHandlerFactory.java:52) ~[jersey-server-2.30.jar:?]

at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:124) [jersey-server-2.30.jar:?]

at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:167) [jersey-server-2.30.jar:?]

at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:219) [jersey-server-2.30.jar:?]

at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:79) [jersey-server-2.30.jar:?]

at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:469) [jersey-server-2.30.jar:?]

at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:391) [jersey-server-2.30.jar:?]

at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:80) [jersey-server-2.30.jar:?]

at org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:253) [jersey-server-2.30.jar:?]

at org.glassfish.jersey.internal.Errors$1.call(Errors.java:248) [jersey-common-2.30.jar:?]

at org.glassfish.jersey.internal.Errors$1.call(Errors.java:244) [jersey-common-2.30.jar:?]

at org.glassfish.jersey.internal.Errors.process(Errors.java:292) [jersey-common-2.30.jar:?]

at org.glassfish.jersey.internal.Errors.process(Errors.java:274) [jersey-common-2.30.jar:?]

at org.glassfish.jersey.internal.Errors.process(Errors.java:244) [jersey-common-2.30.jar:?]

at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:265) [jersey-common-2.30.jar:?]

at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:232) [jersey-server-2.30.jar:?]

at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:680) [jersey-server-2.30.jar:?]

at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:394) [jersey-container-servlet-core-2.30.jar:?]

at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:346) [jersey-container-servlet-core-2.30.jar:?]

at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:366) [jersey-container-servlet-core-2.30.jar:?]

at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:319) [jersey-container-servlet-core-2.30.jar:?]

at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:205) [jersey-container-servlet-core-2.30.jar:?]

at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:295) [com.oracle.weblogic.servlet.jar:14.1.1.0]

at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:260) [com.oracle.weblogic.servlet.jar:14.1.1.0]

at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:137) [com.oracle.weblogic.servlet.jar:14.1.1.0]

at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:353) [com.oracle.weblogic.servlet.jar:14.1.1.0]

at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25) [com.oracle.weblogic.servlet.jar:14.1.1.0]

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:82) [com.oracle.weblogic.servlet.jar:14.1.1.0]

at com.ofs.aai.auth.service.AuthenticationFilter.doFilter(AuthenticationFilter.java:99) [aai-restsmsservice.jar:?]

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:82) [com.oracle.weblogic.servlet.jar:14.1.1.0]

at com.iflex.fic.filters.FilterServlet.doFilter(FilterServlet.java:1476) [FICFilters.jar:?]

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:82) [com.oracle.weblogic.servlet.jar:14.1.1.0]

at com.iflex.fic.filters.EncodingFilter.doFilter(EncodingFilter.java:105) [FICFilters.jar:?]

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:82) [com.oracle.weblogic.servlet.jar:14.1.1.0]

at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3869) [com.oracle.weblogic.servlet.jar:14.1.1.0]

at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3832) [com.oracle.weblogic.servlet.jar:14.1.1.0]

at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:344) [com.oracle.weblogic.security.subject.jar:14.1.1.0]

at weblogic.security.service.SecurityManager.runAsForUserCode(SecurityManager.java:197) [com.oracle.weblogic.security.subject.jar:14.1.1.0]

at weblogic.servlet.provider.WlsSecurityProvider.runAsForUserCode(WlsSecurityProvider.java:203) [com.oracle.weblogic.servlet.jar:14.1.1.0]

at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:71) [com.oracle.weblogic.servlet.jar:14.1.1.0]

at weblogic.servlet.internal.WebAppServletContext.processSecuredExecute(WebAppServletContext.java:2505) [com.oracle.weblogic.servlet.jar:14.1.1.0]

at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2354) [com.oracle.weblogic.servlet.jar:14.1.1.0]

at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2329) [com.oracle.weblogic.servlet.jar:14.1.1.0]

at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2307) [com.oracle.weblogic.servlet.jar:14.1.1.0]

at weblogic.servlet.internal.ServletRequestImpl.runInternal(ServletRequestImpl.java:1798) [com.oracle.weblogic.servlet.jar:14.1.1.0]

at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1752) [com.oracle.weblogic.servlet.jar:14.1.1.0]

at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:272) [com.oracle.weblogic.servlet.jar:14.1.1.0]

at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:352) [com.bea.core.utils.full.jar:14.1.1.0]

at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:337) [com.bea.core.utils.full.jar:14.1.1.0]

at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:57) [com.oracle.weblogic.work.jar:14.1.1.0]

at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41) [com.bea.core.weblogic.workmanager.jar:14.1.1.0]

at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:651) [com.bea.core.weblogic.workmanager.jar:14.1.1.0]

at weblogic.work.ExecuteThread.execute(ExecuteThread.java:420) [com.bea.core.weblogic.workmanager.jar:14.1.1.0]

at weblogic.work.ExecuteThread.run(ExecuteThread.java:360) [com.bea.core.weblogic.workmanager.jar:14.1.1.0]

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.