Portal Administration Console Throws BatchUpdateException When Adding a New Property to a Base Type with Two or More Inherited Types (Doc ID 980072.1)

Last updated on JULY 17, 2017

Applies to:

Oracle WebLogic Portal - Version 9.2.0 to 9.2.2 [Release Weblogic Platform]
Information in this document applies to any platform.

Symptoms

Content Management System of Portal Administration Console throws BatchUpdateException with the following error stack trace, while adding a new property to a base content type, which has two or more inherited types of it.

<Error> <ContentManagement> <000000> <com.bea.content.RepositoryException: java.sql.BatchUpdateException:
ORA-00001: unique constraint (WL_SALES_92_INT.PK_CM_PROP_CHOICE) violated
at com.bea.content.internal.server.common.dbaction.Batcher.processWithRetries(Batcher.java:123)
at com.bea.content.internal.server.common.dbaction.Batcher.add(Batcher.java:57)
at com.bea.content.repo.internal.server.dao.PropertyChoiceDao.insert(PropertyChoiceDao.java:128)
at com.bea.content.repo.internal.server.logic.TypeOpsLogic.propagateInheritedDefinitionChanges(TypeOpsLogic.java:1360)
at com.bea.content.repo.internal.server.logic.TypeOpsLogic.update(TypeOpsLogic.java:252)
Truncated. see log file for complete stacktrace
java.sql.BatchUpdateException: ORA-00001: unique constraint
(WL_SALES_92_INT.PK_CM_PROP_CHOICE) violated
at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
.......

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