WebCenter Portal Application Re-Deployment Raises ORA-00001 When OPSS is Configured In Database (Doc ID 1414333.1)

Last updated on APRIL 06, 2015

Applies to:

Oracle WebCenter Portal - Version 11.1.1.5.0 to 11.1.1.5.0 [Release 11g]
Information in this document applies to any platform.
Checked for relevance on 06-Apr-2015

Symptoms

The WebCenter WebLogic domain has been configured for DB policy storage . If an application is deployed and re-deployed, there are ORA-0001 error raised in the managed server log file.:

Error Code: 1
Call: INSERT INTO JPS_DN (ENTRYID, RDN, PARENTDN) VALUES (?, ?, ?) bind => [29808, cn=administrator, cn=jpsrootnode,cn=jpscontext,cn=slpwcsdomain,cn=testdeployapp_application1\#v 2.0,cn=roles,]
Query:
InsertObjectQuery(EntryId=29808:rdn=cn=administrator:pdn=cn=jpsrootnode,cn=jp scontext,cn=slpwcsdomain,cn=testdeployapp_application1\#v2.0,cn=roles,: JpsStore Entry={[EntryId = 29808:Attribute RowId = 218944
dn = cn=Administrator,cn=Roles,cn=TestDeployApp_application1\#V2.0,cn=slpwcsdomain ,cn=JPSContext,cn=jpsrootnode, EntryId = 29808:Attribute RowId = 218945 displayname = Webcenter Administrator, EntryId = 29808:Attribute RowId = 218946
objectclass = top, EntryId = 29808:Attribute RowId = 218947 objectclass = orclrole, EntryId = 29808:Attribute RowId = 218948 description = Webcenter Administrator Role, EntryId = 29808:Attribute RowId = 218949
orcljaznjavaclass = oracle.security.jps.service.policystore.ApplicationRole, EntryId = 29808:Attribute RowId = 218950 orclguid = BF82D630169011E1BF875921FEC7F1DE, EntryId = 29808:Attribute RowId = 218951
orclApplicationCommonName = TestDeployApp_application1#V2.0, EntryId = 29808:Attribute RowId = 218952 cn = Administrator]})
[EL Warning]: 2011-11-24 20:37:54.3--UnitOfWork(1181406396)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.1.3.v20110304-r9073): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (SLPOFM_OPSS.IDX_JPS_RDN_PDN) violated

Changes

 OPSS configured in the database.

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