Unique Constraint Violation Errors with WLP 10.3.2 During Propagation Commit Phase
(Doc ID 1329698.1)
Last updated on MARCH 07, 2025
Applies to:
Oracle WebLogic Portal - Version 10.3.2 to 10.3.2 [Release AS10gR3]Information in this document applies to any platform.
Symptoms
When running the propagation tool through command line (ant script) the following errors might appear for very rare use cases during the commit phase:
1) Several messages logged of type:
<Add election:.......T700819851278837408562.PageMember:T700819851278837408562.PortletInst] cannot be processed because the items parent does not exist.>
2) Unique constraint violation errors logged as below:
Caused By: javax.ejb.EJBException: nested exception is: javax.ejb.EJBException: SQL Error while performing create operation on page bookGroups: SQL [insert into PF_BOOK_GROUP ( BOOK_GROUP_ID, PARENT_BOOK_ID, ALIGNMENT, MENU_POSITION, IS_DEFAULT, CHILD_BOOK_ID, PAGE_INSTANCE_ID, DESKTOP_INSTANCE_ID) values (?,?,?,?,?,?,?,?)] bookGroup [
BookGroup:
bookGroupId: 34709
DesktopInstanceId: 6002
ParentBookInstanceId: 10047
alignment: 0
position: 4
isDefault: false
PageInstanceId: null
BookInstanceId: 10048] database error code [1] SQL state [23000].; nested exception is: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (WEBLOGIC.AK1_BOOK_GROUP) violated
Changes
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |