OPSS - Unable set security Store getting unique constraint errors (Doc ID 2049671.1)

Last updated on JANUARY 17, 2017

Applies to:

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

Symptoms

Having issues creating the DB security store during OIM 11.1.2.3.0 install/configure.

ols/configureSecurityStore.py -d /u01/Oracle/Middleware/user_projects/domains/JEA_OIM -c IAM -p OIM4dev -m create -v

CLASSPATH=/u01/Oracle/Middleware/patch_wls1036/profiles/default/sys_manifest_classpath/weblogic_patch.jar:/u01/Oracle/Middleware/patch_ocp371/profiles/default/sys_manifest_classpath/weblogic_patch.jar:/u02/jdk1.7.0_80/lib/tools.jar:/u01/Oracle/Middleware/wlserver_10.3/server/lib/weblogic_sp.jar:/u01/Oracle/Middleware/wlserver_10.3/server/lib/weblogic.jar:/u01/Oracle/Middleware/modules/features/weblogic.server.modules_10.3.6.0.jar:/u01/Oracle/Middleware/wlserver_10.3/server/lib/webservices.jar:/u01/Oracle/Middleware/modules/org.apache.ant_1.7.1/lib/ant-all.jar:/u01/Oracle/Middleware/modules/net.sf.antcontrib_1.1.0.0_1-0b2/lib/ant-contrib.jar::/u01/Oracle/Middleware/oracle_common/modules/oracle.jrf_11.1.1/jrf-wlstman.jar:/u01/Oracle/Middleware/oracle_common/common/wlst/lib/adfscripting.jar:/u01/Oracle/Middleware/oracle_common/common/wlst/lib/adf-share-mbeans-wlst.jar:/u01/Oracle/Middleware/oracle_common/common/wlst/lib/mdswlst.jar:/u01/Oracle/Middleware/oracle_common/common/wlst/resources/auditwlst.jar:/u01/Oracle/Middleware/oracle_common/common/wlst/resources/igfwlsthelp.jar:/u01/Oracle/Middleware/oracle_common/common/wlst/resources/jps-wlst.jar:/u01/Oracle/Middleware/oracle_common/common/wlst/resources/jps-wls-trustprovider.jar:/u01/Oracle/Middleware/oracle_common/common/wlst/resources/jrf-wlst.jar:/u01/Oracle/Middleware/oracle_common/common/wlst/resources/oamap_help.jar:/u01/Oracle/Middleware/oracle_common/common/wlst/resources/oamAuthnProvider.jar:/u01/Oracle/Middleware/oracle_common/common/wlst/resources/ossoiap_help.jar:/u01/Oracle/Middleware/oracle_common/common/wlst/resources/ossoiap.jar:/u01/Oracle/Middleware/oracle_common/common/wlst/resources/ovdwlsthelp.jar:/u01/Oracle/Middleware/oracle_common/common/wlst/resources/sslconfigwlst.jar:/u01/Oracle/Middleware/oracle_common/common/wlst/resources/wsm-wlst.jar:/u01/Oracle/Middleware/utils/config/10.3/config-launch.jar::/u01/Oracle/Middleware/wlserver_10.3/common/derby/lib/derbynet.jar:/u01/Oracle/Middleware/wlserver_10.3/common/derby/lib/derbyclient.jar:/u01/Oracle/Middleware/wlserver_10.3/common/derby/lib/derbytools.jar::

Initializing WebLogic Scripting Tool (WLST) ...

Welcome to WebLogic Server Administration Scripting Shell

Type help() for help on available commands

Info: Domain directory is: /u01/Oracle/Middleware/user_projects/domains/JEA_OIM
Info: Server Type is: DB_ORACLE
Info: JPS root is: cn=jpsroot
Info: Data source is: opss-DBDS
Info: Join flag is: false
Info: IDM flag: IDM
Info: Farm name: IAM
Info: Read domain configure file: /u01/Oracle/Middleware/user_projects/domains/JEA_OIM/config/config.xml
Info: Get target data source.
Info: Read data source file: /u01/Oracle/Middleware/user_projects/domains/JEA_OIM/config/jdbc/opss-jdbc.xml
Info: Data source list: [None]
Info: DB user name: DEV1_OPSS
Info: DB JDBC driver: oracle.jdbc.OracleDriver
Info: DB JDBC URL: jdbc:oracle:thin:@10.61.6.70:1521/OIMD
Info: JNDI name of data source: jdbc/OPSSDBDS
Connected:oracle.jdbc.driver.T4CConnection@3a97e1bc
Disconnect:oracle.jdbc.driver.T4CConnection@3a97e1bc
Info: Read domain: /u01/Oracle/Middleware/user_projects/domains/JEA_OIM
Info: Farm name: IAM
Info: jps-config.xml file path: /u01/Oracle/Middleware/user_projects/domains/JEA_OIM/config/fmwconfig/jps-config.xml
Info: Copy file from /u01/Oracle/Middleware/user_projects/domains/JEA_OIM/config/fmwconfig/jps-config.xml Info: Copy file to /u01/Oracle/Middleware/user_projects/domains/JEA_OIM/config/fmwconfig/jps-config-bak.xml
Info: Copy file from /u01/Oracle/Middleware/user_projects/domains/JEA_OIM/config/fmwconfig/jps-config-jse.xml Info: Copy file to /u01/Oracle/Middleware/user_projects/domains/JEA_OIM/config/fmwconfig/jps-config-jse-bak.xml
Info: Execute command: java -Xms512M -Xmx512M oracle.security.jps.internal.tools.configuration.ldap.LdapServiceEnabler -command setSecurityServices -servertype DB_ORACLE -domain IAM -admin DEV1_OPSS -password 'OIM4dev' -jpsroot cn=jpsroot -migration true -seedSchemaAndDIT true -jdbcurl 'jdbc:oracle:thin:@10.61.6.70:1521/OIMD' -jdbcdriver oracle.jdbc.OracleDriver -path /u01/Oracle/Middleware/user_projects/domains/JEA_OIM/config/fmwconfig/jps-config.xml
[oracle.security.jps.internal.config.db.DbCredStoreServiceConfigurator] checkServiceSetup - done
Aug 24, 2015 3:44:11 PM oracle.security.jps.internal.config.ldap.LdapCredStoreServiceConfigurator schemaCompatibleHandler
INFO: Credential store schema upgrade not required. Store Schema version 11.1.1.9.0 is compatible to the seed schema version 11.1.1.9.0
[oracle.security.jps.internal.config.db.DbCredStoreServiceConfigurator] checkServiceSchema - Store schema has been seeded completely
[oracle.security.jps.internal.config.db.DbCredStoreServiceConfigurator] updateServiceConfiguration - done
[oracle.security.jps.internal.config.db.DbCredStoreServiceConfigurator] seedSchemaAndCreateDIT - failed oracle.security.jps.service.policystore.PolicyObjectAlreadyExistsException: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.BatchUpdateException: ORA-00001: unique constraint (DEV1_OPSS.IDX_JPS_RDN_PDN) violated

Error Code: 1
Query: InsertObjectQuery(EntryId = 5006:Attribute RowId = 6004
objectclass = orclContainer)
Exception in thread "main" java.lang.RuntimeException: oracle.security.jps.service.policystore.PolicyObjectAlreadyExistsException: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.BatchUpdateException: ORA-00001: unique constraint (DEV1_OPSS.IDX_JPS_RDN_PDN) violated
..................

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms