WebCenter Portal SQL Integrity Constraint Error While Importing PAR (Doc ID 3049848.1)

Last updated on SEPTEMBER 25, 2024

Applies to:

Symptoms

• The customer encountered an integrity constraint error while importing a PAR file into WebCenter Portal.
• The error message indicated a unique constraint violation for a page that wasn't present in the PAR file.
• This issue prevented the successful import of the PAR file into the WebCenter Portal.

Error:
[TIMESTAMP] [MServer_Name] [NOTIFICATION] [WCS-12045] [oracle.webcenter.lifecycle.operation.ImportOperation] [host: <HOSTNAME>] [nwaddr: <IP_ADDRESS>] [tid: 26] [userId: <USERNAME>] [ecid: <ECID>] [APP: webcenter] [partition-name: DOMAIN] [tenant-name: GLOBAL] Operation aborted because of an exception thrown by subunit (oracle.webcenter.lifecycle.data.PersistenceUnit)[[
oracle.webcenter.lifecycle.LifecycleException: An internal error occurred while importing portal data. Refer to the WebCenter Portal Server log for more information.
at oracle.webcenter.lifecycle.data.PersistenceUnit.doImport(PersistenceUnit.java:382)
at oracle.webcenter.lifecycle.operation.ImportOperation.doImport(ImportOperation.java:151)
at oracle.webcenter.lifecycle.LifecycleService.doImport(LifecycleService.java:2903)
at oracle.webcenter.lifecycle.LifecycleService.importPortals(LifecycleService.java:7055)
at oracle.webcenter.lifecycle.mxbean.ImportInstance.doImportInternal(ImportInstance.java:260)
at oracle.webcenter.lifecycle.mxbean.ImportInstance.doImport(ImportInstance.java:212)
at sun.reflect.GeneratedMethodAccessor3439.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at oracle.webcenter.core.lifecycle.state.StatefulInvocationHandler.invoke(StatefulInvocationHandler.java:81)
at oracle.webcenter.core.lifecycle.state.TimeoutInvocationHandler.invoke(TimeoutInvocationHandler.java:147)
at com.sun.proxy.$Proxy510.doImport(Unknown Source)
at oracle.webcenter.lifecycle.mxbean.ImportInstanceProxy$1.call(ImportInstanceProxy.java:79)
at oracle.webcenter.lifecycle.mxbean.ImportInstanceProxy$1.call(ImportInstanceProxy.java:75)
at oracle.webcenter.portal.context.impl.PortalRequestExecutorImpl.execute(PortalRequestExecutorImpl.java:47)
at oracle.webcenter.lifecycle.mxbean.ImportInstanceProxy.doImport(ImportInstanceProxy.java:74)
at sun.reflect.GeneratedMethodAccessor3439.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at oracle.as.jmx.framework.standardmbeans.spi.OracleStandardEmitterMBean.doInvoke(OracleStandardEmitterMBean.java:918)
at oracle.adf.mbean.share.AdfMBeanInterceptor.internalInvoke(AdfMBeanInterceptor.java:103)
at oracle.as.jmx.framework.generic.spi.interceptors.AbstractMBeanInterceptor.doInvoke(AbstractMBeanInterceptor.java:252)
at oracle.as.jmx.framework.generic.spi.security.AbstractMBeanSecurityInterceptor.internalInvoke(AbstractMBeanSecurityInterceptor.java:192)
at oracle.as.jmx.framework.generic.spi.interceptors.AbstractMBeanInterceptor.doInvoke(AbstractMBeanInterceptor.java:252)
at oracle.security.jps.ee.jmx.JpsJmxInterceptor$2.run(JpsJmxInterceptor.java:423)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:314)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:650)
at oracle.security.jps.ee.jmx.JpsJmxInterceptor.internalInvoke(JpsJmxInterceptor.java:442)
at oracle.as.jmx.framework.generic.spi.interceptors.AbstractMBeanInterceptor.doInvoke(AbstractMBeanInterceptor.java:252)
at oracle.as.jmx.framework.generic.spi.interceptors.ContextClassLoaderMBeanInterceptor.internalInvoke(ContextClassLoaderMBeanInterceptor.java:100)
at oracle.as.jmx.framework.generic.spi.interceptors.AbstractMBeanInterceptor.doInvoke(AbstractMBeanInterceptor.java:252)
at oracle.as.jmx.framework.generic.spi.interceptors.MBeanRestartInterceptor.internalInvoke(MBeanRestartInterceptor.java:116)
at oracle.as.jmx.framework.generic.spi.interceptors.AbstractMBeanInterceptor.doInvoke(AbstractMBeanInterceptor.java:252)
at oracle.as.jmx.framework.standardmbeans.spi.OracleStandardEmitterMBean.invoke(OracleStandardEmitterMBean.java:834)
at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:819)
at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:801)
at <USERNAME>.management.jmx.mbeanserver.WLSMBeanServerInterceptorBase$21.run(WLSMBeanServerInterceptorBase.java:589)
at java.security.AccessController.doPrivileged(Native Method)
at <USERNAME>.management.jmx.mbeanserver.WLSMBeanServerInterceptorBase.invoke(WLSMBeanServerInterceptorBase.java:587)
at <USERNAME>.management.mbeanservers.internal.JMXContextInterceptor.invoke(JMXContextInterceptor.java:249)
at <USERNAME>.management.jmx.mbeanserver.WLSMBeanServerInterceptorBase$21.run(WLSMBeanServerInterceptorBase.java:589)
at java.security.AccessController.doPrivileged(Native Method)
at <USERNAME>.management.jmx.mbeanserver.WLSMBeanServerInterceptorBase.invoke(WLSMBeanServerInterceptorBase.java:587)
at <USERNAME>.management.mbeanservers.internal.SecurityInterceptor.invoke(SecurityInterceptor.java:439)
at <USERNAME>.management.jmx.mbeanserver.WLSMBeanServerInterceptorBase$21.run(WLSMBeanServerInterceptorBase.java:589)
at java.security.AccessController.doPrivileged(Native Method)
at <USERNAME>.management.jmx.mbeanserver.WLSMBeanServerInterceptorBase.invoke(WLSMBeanServerInterceptorBase.java:587)
at <USERNAME>.management.mbeanservers.internal.MBeanCICInterceptor.access$401(MBeanCICInterceptor.java:38)
at <USERNAME>.management.mbeanservers.internal.MBeanCICInterceptor$4.call(MBeanCICInterceptor.java:299)
at <USERNAME>.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:287)
at <USERNAME>.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:272)
at <USERNAME>.management.mbeanservers.internal.MBeanCICInterceptor.invoke(MBeanCICInterceptor.java:295)
at <USERNAME>.management.jmx.mbeanserver.WLSMBeanServerInterceptorBase$21.run(WLSMBeanServerInterceptorBase.java:589)
at java.security.AccessController.doPrivileged(Native Method)
at <USERNAME>.management.jmx.mbeanserver.WLSMBeanServerInterceptorBase.invoke(WLSMBeanServerInterceptorBase.java:587)
at <USERNAME>.management.mbeanservers.internal.PartitionJMXInterceptor.invoke(PartitionJMXInterceptor.java:435)
at <USERNAME>.management.jmx.mbeanserver.WLSMBeanServerInterceptorBase$21.run(WLSMBeanServerInterceptorBase.java:589)
at java.security.AccessController.doPrivileged(Native Method)
at <USERNAME>.management.jmx.mbeanserver.WLSMBeanServerInterceptorBase.invoke(WLSMBeanServerInterceptorBase.java:587)
at <USERNAME>.management.mbeanservers.internal.CallerPartitionContextInterceptor.invoke(CallerPartitionContextInterceptor.java:217)
at <USERNAME>.management.jmx.mbeanserver.WLSMBeanServer.invoke(WLSMBeanServer.java:327)
at <USERNAME>.management.mbeanservers.internal.JMXConnectorSubjectForwarder$11$1.run(JMXConnectorSubjectForwarder.java:655)
at java.security.AccessController.doPrivileged(Native Method)
at <USERNAME>.management.mbeanservers.internal.JMXConnectorSubjectForwarder$11.run(JMXConnectorSubjectForwarder.java:653)
at <USERNAME>.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:386)
at <USERNAME>.management.mbeanservers.internal.JMXConnectorSubjectForwarder.invoke(JMXConnectorSubjectForwarder.java:646)
at javax.management.remote.rmi.RMIConnectionImpl.doOperation(RMIConnectionImpl.java:1468)
at javax.management.remote.rmi.RMIConnectionImpl.access$300(RMIConnectionImpl.java:76)
at javax.management.remote.rmi.RMIConnectionImpl$PrivilegedOperation.run(RMIConnectionImpl.java:1309)
at java.security.AccessController.doPrivileged(Native Method)
at javax.management.remote.rmi.RMIConnectionImpl.doPrivilegedOperation(RMIConnectionImpl.java:1408)
at javax.management.remote.rmi.RMIConnectionImpl.invoke(RMIConnectionImpl.java:829)
at javax.management.remote.rmi.RMIConnectionImpl_WLSkel.invoke(Unknown Source)
at <USERNAME>.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:685)
at <USERNAME>.rmi.internal.BasicServerRef$3.run(BasicServerRef.java:564)
at <USERNAME>.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:386)
at <USERNAME>.security.service.SecurityManager.runAs(SecurityManager.java:163)
at <USERNAME>.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:561)
at <USERNAME>.rmi.internal.wls.WLSExecuteRequest.run(WLSExecuteRequest.java:138)
at <USERNAME>.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:352)
at <USERNAME>.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:337)
at <USERNAME>.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:57)
at <USERNAME>.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41)
at <USERNAME>.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:655)
at <USERNAME>.work.ExecuteThread.execute(ExecuteThread.java:420)
at <USERNAME>.work.ExecuteThread.run(ExecuteThread.java:360)
Caused by: oracle.webcenter.lifecycle.LifecycleException: An internal error occurred while importing portal data. Refer to the WebCenter Portal Server log for more information.
at oracle.webcenter.lifecycle.data.PersistenceUnit.doPersistenceImport(PersistenceUnit.java:503)
at oracle.webcenter.lifecycle.data.PersistenceUnit.doImport(PersistenceUnit.java:376)
... 86 more
Caused by: oracle.webcenter.portal.transaction.TransactionException: An error occurred while committing a transaction.
at oracle.webcenter.portal.persistence.transaction.TransactionManagerImpl.commit(TransactionManagerImpl.java:510)
at oracle.webcenter.portal.persistence.transaction.TransactionManagerImpl.commitIfAllowed(TransactionManagerImpl.java:467)
at oracle.webcenter.portal.persistence.transaction.TransactionManagerImpl.commitTransaction(TransactionManagerImpl.java:326)
at oracle.webcenter.portal.persistence.transaction.TransactionManagerImpl$Proxy$_$$_WeldClientProxy.commitTransaction(Unknown Source)
at oracle.webcenter.lifecycle.data.PersistenceUnit$2.run(PersistenceUnit.java:476)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:258)
at oracle.security.jps.internal.jaas.AccActionExecutor.execute(AccActionExecutor.java:61)
at oracle.security.jps.internal.jaas.AbstractSubjectSecurity$ActionExecutorWrapper.execute(AbstractSubjectSecurity.java:268)
at oracle.security.jps.internal.jaas.CascadeActionExecutor$SubjectPrivilegedAction.run(CascadeActionExecutor.java:67)
at <USERNAME>.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:344)
at <USERNAME>.security.service.SecurityManager.runAs(SecurityManager.java:137)
at <USERNAME>.security.Security.runAs(Security.java:42)
at oracle.security.jps.wls.jaas.WlsActionExecutor.execute(WlsActionExecutor.java:46)
at oracle.security.jps.internal.jaas.CascadeActionExecutor.execute(CascadeActionExecutor.java:49)
at oracle.security.jps.internal.jaas.AbstractSubjectSecurity$ActionExecutorWrapper.execute(AbstractSubjectSecurity.java:268)
at oracle.security.jps.internal.jaas.AbstractSubjectSecurity.executeAs(AbstractSubjectSecurity.java:227)
at oracle.webcenter.lifecycle.data.PersistenceUnit.doPersistenceImport(PersistenceUnit.java:428)
... 87 more
Caused by: javax.persistence.RollbackException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.7.v20230512-ce26847): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (WCCLIENT_WEBCENTER.IX_UNIQUE_PORTA_NAMESPACE_NAME) violated

Error Code: 1
Call: INSERT INTO WC_PORTAL_ENTITY (ID, AUX_DATE_1, AUX_DATE_10, AUX_DATE_2, AUX_DATE_3, AUX_DATE_4, AUX_DATE_5, AUX_DATE_6, AUX_DATE_7, AUX_DATE_8, AUX_DATE_9, AUX_INDEXED_NUMBER_1, AUX_INDEXED_NUMBER_2, AUX_INDEXED_STRING_1, AUX_INDEXED_STRING_2, AUX_INDEXED_STRING_3, AUX_INDEXED_STRING_4, AUX_INDEXED_STRING_5, AUX_NUMBER_1, AUX_NUMBER_10, AUX_NUMBER_11, AUX_NUMBER_12, AUX_NUMBER_13, AUX_NUMBER_14, AUX_NUMBER_15, AUX_NUMBER_2, AUX_NUMBER_3, AUX_NUMBER_4, AUX_NUMBER_5, AUX_NUMBER_6, AUX_NUMBER_7, AUX_NUMBER_8, AUX_NUMBER_9, AUX_STRING_1, AUX_STRING_10, AUX_STRING_11, AUX_STRING_12, AUX_STRING_13, AUX_STRING_14, AUX_STRING_15, AUX_STRING_16, AUX_STRING_17, AUX_STRING_18, AUX_STRING_19, AUX_STRING_2, AUX_STRING_20, AUX_STRING_21, AUX_STRING_22, AUX_STRING_23, AUX_STRING_24, AUX_STRING_25, AUX_STRING_26, AUX_STRING_27, AUX_STRING_28, AUX_STRING_29, AUX_STRING_3, AUX_STRING_30, AUX_STRING_31, AUX_STRING_32, AUX_STRING_33, AUX_STRING_34, AUX_STRING_35, AUX_STRING_4, AUX_STRING_5, AUX_STRING_6, AUX_STRING_7, AUX_STRING_8, AUX_STRING_9, CREATED, CREATOR, DESCRIPTION, DOCUMENT_REF, IS_INITIALIZED, IS_SECURED, IS_SEEDED, MODIFIED, MODIFIER, NAME, NAMESPACE, SECURITY_ID, SHORT_ID, TYPE, VERSION, VERSION_ID, PORTAL_ID, SECURITY_ENTITY_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
bind => [86 parameters bound]
Query: InsertObjectQuery(null [namespace=root/children/<myPageName>/page/<My Page Name>/pageView, id=<PAGE_ID>, type=oracle.webcenter.portal.persistence.PageViewResource, version=1])
at org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:159)
at oracle.webcenter.portal.persistence.transaction.TransactionManagerImpl.commit(TransactionManagerImpl.java:485)
... 104 more
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.7.v20230512-ce26847): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (WCCLIENT_WEBCENTER.IX_UNIQUE_PORTA_NAMESPACE_NAME) violated

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.