OPSS :12.2.1 .2 - Moving DEV To TEST Environment seeing OPSS data import failed OPSS data import failed , Unable to seed the schema , Check clone logs for more details, OPSS paste configuration failed, Error in configuring OPSS. (Doc ID 2660659.1)

Last updated on DECEMBER 22, 2023

Applies to:

Oracle Platform Security for Java - Version 12.2.1.2.0 and later
Information in this document applies to any platform.

Symptoms

While running the T2P process, Initially run the copyconfig.sh it failed with some SOA issue

Failed with the following CLONE<Date>_<number>.error

oracle.as.t2p.sdk.model.exception.FMWT2PPasteConfigException: PasteConfig in offline mode failed.
at oracle.as.t2p.framework.cloner.config.j2ee.J2EEComponentApplyCloner.doClone(J2EEComponentApplyCloner.java:320)
at oracle.as.t2p.framework.cloner.Cloner.doFinalClone(Cloner.java:65)
at oracle.as.t2p.framework.request.ApplyCloneRequest.applyArchive(ApplyCloneRequest.java:155)
at oracle.as.t2p.framework.request.ApplyCloneRequest._clone(ApplyCloneRequest.java:66)
at oracle.as.t2p.framework.process.CloningExecutionProcess.execute(CloningExecutionProcess.java:145)
at oracle.as.t2p.framework.process.CloningExecutionProcess.execute(CloningExecutionProcess.java:117)
at oracle.as.t2p.framework.client.CloningClient.executeT2PCommand(CloningClient.java:274)
at oracle.as.t2p.framework.client.CloningClient.main(CloningClient.java:120)

CLONE<Date>_<number>.log

Configuring the Datasource - EAMDataSource
Error: cd() failed. Do dumpStack() to see details.
Error: runCmd() failed. Do dumpStack() to see details.
com.oracle.cie.domain.script.jython.WLSTException: No such element JDBCSystemResource named EAMDataSource <<<<<<<<<<<<<<<<
at com.oracle.cie.domain.script.jython.CommandExceptionHandler.handleException(CommandExceptionHandler.java:69)
at com.oracle.cie.domain.script.jython.WLScriptContext.handleException(WLScriptContext.java:2768)
at com.oracle.cie.domain.script.jython.WLScriptContext.runCmd(WLScriptContext.java:701)
at sun.reflect.GeneratedMethodAccessor871.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.python.core.PyReflectedFunction.__call__(Unknown Source)
at org.python.core.PyMethod.__call__(Unknown Source)

Re run again in the new log CLONE<Date>_<number>.log and login failed with the following error

FINE : [PLUGIN][OPSS] Going to seed schema, create DIT (LdapServiceEnabler)...
FINE : [PLUGIN][OPSS] OPSS T2P log file :/var/tmp/CLONINGCLIENT-3<NUMBER>/opsst2p.log <<<<<<<<<<<<<<<<<<<<<
INFO : [PLUGIN][OPSS] Run LdapServiceEnabler failed with invalid exit code:1
INFO : [PLUGIN][OPSS] Run LdapServiceEnabler failed.
[CloneLogger:unSetSystemOutErrToCloneLogger] Invoking unsetSystemOutErrToCloneLogger 1
[DBUtil:closeJDBCConnections] Clearing jdbc connections list...
- CLONE-21207
---------------------------------------------------
T2P Summary Begin
---------------------------------------------------
Error Message :1
[PLUGIN][OPSS] - ERROR - Apr 13, 2020 1:15:25 PM - CLONE-36005 OPSS data import failed.
[PLUGIN][OPSS] - CAUSE - Apr 13, 2020 1:15:25 PM - CLONE-36005 Unable to seed the schema.
[PLUGIN][OPSS] - ACTION - Apr 13, 2020 1:15:25 PM - CLONE-36005 Check clone logs for more details.
Error Message :2
[PLUGIN][OPSS] - ERROR - Apr 13, 2020 1:15:25 PM - CLONE-36013 OPSS paste configuration failed.
[PLUGIN][OPSS] - CAUSE - Apr 13, 2020 1:15:25 PM - CLONE-36013 Error in configuring OPSS.
[PLUGIN][OPSS] - ACTION - Apr 13, 2020 1:15:25 PM - CLONE-36013 Check the T2P logs for details.
Error Message :3
Apr 13, 2020 1:15:25 PM - SEVERE - CLONE-20936 "pasteConfig" operation failed for oracle.security.jps.t2p.plugin.opss.impl.OPSSPasteConfigImpl plugin. Check the clone log and error files for more details.
Error Message :4
Apr 13, 2020 1:15:25 PM - SEVERE - CLONE-20937 "pasteConfig" operation of J2EE domain failed. Check the clone log and error files for more details.
Error Message :5
ERROR - CLONE-20218 Cloning is not successful.
CAUSE - CLONE-20218 An internal operation failed.
ACTION - CLONE-20218 Check the clone log and error file for detailed information.

---------------------------------------------------
T2P Summary End
---------------------------------------------------

From the /var/tmp/CLONINGCLIENT-3<NUMBER>/opsst2p.log

oracle.security.jps.internal.api.common.JpsPolicyStoreLdapNodeCreationException: oracle.security.jps.service.policystore.PolicyObjectAlreadyExistsException: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (<PREFIX>__OPSS.IDX_JPS_RDN_PDN) violated

at oracle.security.jps.internal.common.rdbms.util.JpsDbBootstrapImpl.createJpsPolicyStoreInLdap(JpsDbBootstrapImpl.java:460)
at oracle.security.jps.internal.config.ldap.LdapPolicyStoreServiceConfigurator.addServiceStoreBase(LdapPolicyStoreServiceConfigurator.java:251)
at oracle.security.jps.internal.config.ldap.LdapPolicyStoreServiceConfigurator.migrateData(LdapPolicyStoreServiceConfigurator.java:213)
at oracle.security.jps.internal.config.ldap.LdapPolicyStoreServiceConfigurator.migrateData(LdapPolicyStoreServiceConfigurator.java:201)
at oracle.security.jps.internal.config.ldap.LdapPolicyStoreServiceConfigurator.migrateData(LdapPolicyStoreServiceConfigurator.java:197)
at oracle.security.jps.internal.tools.configuration.ldap.LdapServiceEnabler.runConfiguration(LdapServiceEnabler.java:603)
at oracle.security.jps.internal.tools.configuration.ldap.LdapServiceEnabler.configurePolicyStoreService(LdapServiceEnabler.java:313)
at oracle.security.jps.internal.tools.configuration.ldap.LdapServiceEnabler.configureSecurityServices(LdapServiceEnabler.java:245)
at oracle.security.jps.internal.tools.configuration.ldap.LdapServiceEnabler.runLSE(LdapServiceEnabler.java:233)
at oracle.security.jps.internal.tools.configuration.ldap.LdapServiceEnabler.main(LdapServiceEnabler.java:161)
Caused by: oracle.security.jps.service.policystore.PolicyObjectAlreadyExistsException: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (<PREFIX>__OPSS.IDX_JPS_RDN_PDN) violated

at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.processJPAException(JpsDBDataManager.java:2654)
at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.createEntry(JpsDBDataManager.java:2577)
at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.createJpsPolicyObject(JpsDBDataManager.java:2486)
at oracle.security.jps.internal.policystore.AbstractJpsDataManager.createObject(AbstractJpsDataManager.java:248)
at oracle.security.jps.internal.common.rdbms.util.JpsDbBootstrapImpl.createSystemPolicy(JpsDbBootstrapImpl.java:959)
at oracle.security.jps.internal.common.rdbms.util.JpsDbBootstrapImpl.createJpsPolicyStoreInLdap(JpsDbBootstrapImpl.java:450)
... 9 more
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (<PREFIX>__OPSS.IDX_JPS_RDN_PDN) violated

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1113)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:603)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:234)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:55)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1006)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1316)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:5010)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:5136)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1519)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:892)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:964)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:633)
at org.eclipse.persistence.internal.databaseaccess.ParameterizedSQLBatchWritingMechanism.executeBatch(ParameterizedSQLBatchWritingMechanism.java:149)
at org.eclipse.persistence.internal.databaseaccess.ParameterizedSQLBatchWritingMechanism.executeBatchedStatements(ParameterizedSQLBatchWritingMechanism.java:134)
at org.eclipse.persistence.internal.databaseaccess.ParameterizedSQLBatchWritingMechanism.appendCall(ParameterizedSQLBatchWritingMechanism.java:82)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:605)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:560)
at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2056)
at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:306)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:242)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:228)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.insertObject(DatasourceCallQueryMechanism.java:377)
at org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:165)
at org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:180)
at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.insertObjectForWrite(DatabaseQueryMechanism.java:489)
at org.eclipse.persistence.queries.InsertObjectQuery.executeCommit(InsertObjectQuery.java:80)
at org.eclipse.persistence.queries.InsertObjectQuery.executeCommitWithChangeSet(InsertObjectQuery.java:90)
at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.executeWriteWithChangeSet(DatabaseQueryMechanism.java:301)
at org.eclipse.persistence.queries.WriteObjectQuery.executeDatabaseQuery(WriteObjectQuery.java:58)
at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:904)
at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:803)
at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWorkObjectLevelModifyQuery(ObjectLevelModifyQuery.java:108)
at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWork(ObjectLevelModifyQuery.java:85)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2896)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1857)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1839)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1790)
at org.eclipse.persistence.internal.sessions.CommitManager.commitNewObjectsForClassWithChangeSet(CommitManager.java:227)
at org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsForClassWithChangeSet(CommitManager.java:194)
at org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsWithChangeSet(CommitManager.java:139)
at org.eclipse.persistence.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet(AbstractSession.java:4264)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1441)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithPreBuiltChangeSet(UnitOfWorkImpl.java:1587)
at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.writeChanges(RepeatableWriteUnitOfWork.java:455)
at org.eclipse.persistence.internal.jpa.EntityManagerImpl.flush(EntityManagerImpl.java:874)
at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.createEntry(JpsDBDataManager.java:2563)
... 13 more

Exception in thread "main" java.lang.RuntimeException: oracle.security.jps.service.policystore.PolicyObjectAlreadyExistsException: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (<PREFIX>__OPSS.IDX_JPS_RDN_PDN) violated

oracle.security.jps.internal.api.common.JpsPolicyStoreLdapNodeCreationException: oracle.security.jps.service.policystore.PolicyObjectAlreadyExistsException: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (<PREFIX>__OPSS.IDX_JPS_RDN_PDN) violated

at oracle.security.jps.internal.common.rdbms.util.JpsDbBootstrapImpl.createJpsPolicyStoreInLdap(JpsDbBootstrapImpl.java:460)
at oracle.security.jps.internal.config.ldap.LdapPolicyStoreServiceConfigurator.addServiceStoreBase(LdapPolicyStoreServiceConfigurator.java:251)
at oracle.security.jps.internal.config.ldap.LdapPolicyStoreServiceConfigurator.migrateData(LdapPolicyStoreServiceConfigurator.java:213)
at oracle.security.jps.internal.config.ldap.LdapPolicyStoreServiceConfigurator.migrateData(LdapPolicyStoreServiceConfigurator.java:201)
at oracle.security.jps.internal.config.ldap.LdapPolicyStoreServiceConfigurator.migrateData(LdapPolicyStoreServiceConfigurator.java:197)
at oracle.security.jps.internal.tools.configuration.ldap.LdapServiceEnabler.runConfiguration(LdapServiceEnabler.java:603)
at oracle.security.jps.internal.tools.configuration.ldap.LdapServiceEnabler.configurePolicyStoreService(LdapServiceEnabler.java:313)
at oracle.security.jps.internal.tools.configuration.ldap.LdapServiceEnabler.configureSecurityServices(LdapServiceEnabler.java:245)
at oracle.security.jps.internal.tools.configuration.ldap.LdapServiceEnabler.runLSE(LdapServiceEnabler.java:233)
at oracle.security.jps.internal.tools.configuration.ldap.LdapServiceEnabler.main(LdapServiceEnabler.java:161)
Caused by: oracle.security.jps.service.policystore.PolicyObjectAlreadyExistsException: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (<PREFIX>__OPSS.IDX_JPS_RDN_PDN) violated

at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.processJPAException(JpsDBDataManager.java:2654)
at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.createEntry(JpsDBDataManager.java:2577)
at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.createJpsPolicyObject(JpsDBDataManager.java:2486)
at oracle.security.jps.internal.policystore.AbstractJpsDataManager.createObject(AbstractJpsDataManager.java:248)
at oracle.security.jps.internal.common.rdbms.util.JpsDbBootstrapImpl.createSystemPolicy(JpsDbBootstrapImpl.java:959)
at oracle.security.jps.internal.common.rdbms.util.JpsDbBootstrapImpl.createJpsPolicyStoreInLdap(JpsDbBootstrapImpl.java:450)
... 9 more
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (<PREFIX>__OPSS.IDX_JPS_RDN_PDN) violated

at oracle.security.jps.internal.tools.configuration.ldap.LdapServiceEnabler.throwExceptionWithStackTrace(LdapServiceEnabler.java:174)
at oracle.security.jps.internal.tools.configuration.ldap.LdapServiceEnabler.main(LdapServiceEnabler.java:166)

Cause

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

In this Document

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

OPSS :12.2.1 .2 - Moving DEV To TEST Environment seeing OPSS data import failed OPSS data import failed , Unable to seed the schema , Check clone logs for more details, OPSS paste configuration failed, Error in configuring OPSS. (Doc ID 2660659.1)

Applies to:

Symptoms

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!