DIH connector not migrating (Doc ID 2614253.1)

Last updated on MAY 22, 2023

Applies to:

Symptoms

 Observed the below error in DIH.log & FUSIONSUBSYSTEM.log

15-11-19 09:11:37 AM] ~ ERROR ~ DIHLOGGER ~ [ConnectorDAO][saveObjectToDB]com.ibm.websphere.ce.cm.DuplicateKeyException: ORA-00001: unique constraint (<Schemaname>.PK_FSI_CONT_NODES) violated
java.sql.SQLException: com.ibm.websphere.ce.cm.DuplicateKeyException: ORA-00001: unique constraint (<Schemaname>.PK_FSI_CONT_NODES) violated
at com.ofs.reveleus.global.db.utils.QueryRunner.executeUpdate(QueryRunner.java:295) ~[CommonPlatform.jar:?]
at com.ofss.fsgbu.dihcore.utils.QueryRunnerUtils.excuteUpdatQueryRunnerUtils.java:36) ~[dih-core.jar:8.0.6.0.1_10150163730635]
at com.ofss.fsgbu.dihapp.dao.ConnectorDAO.saveObjectToDB(ConnectorDAO.java:1185) [dih-app.jar:8.0.6.0.1_10150163730635 at com.ofss.fsgbu.dihapp.dao.ConnectorDAO.saveObjectToDB(ConnectorDAO.java:50) [dih-app.jar:8.0.6.0.1_10150163730635]
Ruleset(MigrationServiceProvider.java:994) [migration.jar:?]
at com.ofs.reveleus.migration.service.MigrationRESTService.invokeMigrationService(MigrationRESTService.java:76) [migration.jar:?]
at sun.reflect.GeneratedMethodAccessor943.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56) ~[?:1.7.0]
at java.lang.reflect.Method.invoke(Method.java:620) ~[?:2.6 (10-05-2016)]
at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81) [jersey-server.jar:?]
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144) [jersey-server.jar:?]
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161) [jersey-server.jar:?]
atorg.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:205) [jersey-server.jar:?]
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99) [jersey-server.jar:?]
at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389) [jersey-server.jar:?]
at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347) [jersey-server.jar:?]
at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102) [jersey-server.jar:?]
at org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:326) [jersey-server.jar:?]
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271) [jersey-common.jar:?]
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267) [jersey-common.jar:?]
at org.glassfish.jersey.internal.Errors.process(Errors.java:315) [jersey-common.jar:?]
at org.glassfish.jersey.internal.Errors.process(Errors.java:297) [jersey-common.jar:?]
at org.glassfish.jersey.internal.Errors.process(Errors.java:267) [jersey-common.jar:?]

Cause

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