My Oracle Support Banner

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

Last updated on FEBRUARY 01, 2022

Applies to:

Oracle WebCenter Portal - Version to [Release 11g]
Information in this document applies to any platform.


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,]
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 =, 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


 OPSS configured in the database.


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.