My Oracle Support Banner

Unable to Save Page Asset that has an Asset Attribute Default Value Set (Doc ID 2813795.1)

Last updated on NOVEMBER 05, 2023

Applies to:

Oracle WebCenter Sites - Version 12.2.1.4.0 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.1.4.0 version, WebCenter Sites

When attempting to pub page ,
the following error occurs.

ERROR
-----------------------
 [wcsites_server1] [ERROR] [] [oracle.wcsites.db] [tid: 110] [userId: ] [ecid: 505a9d25-71a4-4d75-9039-ad6a1339214d-0004b7f5,0] [APP: sites] [partition-name: DOMAIN] [tenant-name: GLOBAL] Exception executing prepared statement: INSERT INTO AssetPublication (id,pubid,assettype,assetid) VALUES (?,?,?,?)[[
id = 1565691015533
pubid = 1597049602195
assettype = Page
assetid = 1565688945322 java.sql.SQLIntegrityConstraintViolationException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Cannot be uniquely indexed 'I_1806990940_Asset' In the object 'DEV_WCSITES.AssetPublication' Insert duplicate index key data rows in. The duplicate index key value is (1597049602195, 1565688945322)。
at weblogic.jdbc.sqlserverbase.ddco.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddco.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddco.a(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddr.v(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddq.a(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddr.c(Unknown Source)
at weblogic.jdbc.sqlserver.dda4.m(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddev.e(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddev.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.dddv.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddev.x(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddev.z(Unknown Source)
at weblogic.jdbc.sqlserverbase.dddv.executeUpdate(Unknown Source)
at weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:170)
at COM.FutureTense.Servlet.JDBCTable.executeUpdate_trans_logic(JDBCTable.java:1419)
at COM.FutureTense.Servlet.JDBCTable.access$000(JDBCTable.java:76)
at COM.FutureTense.Servlet.JDBCTable$1.execute(JDBCTable.java:1356)
at com.fatwire.cs.core.db.NestedTransactionBlock.execute(NestedTransactionBlock.java:189)
at COM.FutureTense.Servlet.JDBCTable.executeUpdate_trans(JDBCTable.java:1361)
at COM.FutureTense.Servlet.JDBCTable.executeUpdate(JDBCTable.java:1241)
at COM.FutureTense.Servlet.JDBCTable.AddRow(JDBCTable.java:973)
at COM.FutureTense.Common.ftDBTable.insertRow(ftDBTable.java:1303)
at COM.FutureTense.CatalogManager.CatalogEngine._replaceRow(CatalogEngine.java:1327)
at COM.FutureTense.CatalogManager.CatalogEngine.access$300(CatalogEngine.java:56)
at COM.FutureTense.CatalogManager.CatalogEngine$3.execute(CatalogEngine.java:1224)
at com.fatwire.cs.core.db.NestedTransactionBlock.execute(NestedTransactionBlock.java:189)
at COM.FutureTense.CatalogManager.CatalogEngine.replaceRow_trans(CatalogEngine.java:1233)
at COM.FutureTense.CatalogManager.CatalogEngine.replaceRow(CatalogEngine.java:1085)
at COM.FutureTense.Common.CatalogManager.execute(CatalogManager.java:2052)
at COM.FutureTense.Common.ContentServer.runManager(ContentServer.java:3970)
at COM.FutureTense.Common.CS.CatalogManager(CS.java:1514)
at COM.FutureTense.Common.CS.CatalogManager(CS.java:1464)
at com.openmarket.framework.objects.ContentCatalog.ReplaceRow(ContentCatalog.java:369)
at com.openmarket.framework.objects.AbstractContent.Save(AbstractContent.java:584)
at com.openmarket.xcelerate.asset.Asset.AddToAssetPublication(Asset.java:5963)
at com.openmarket.gator.page.Page.AddToAssetPublication(Page.java:263)
at com.openmarket.xcelerate.asset.Asset.UpdateAssetPublication(Asset.java:6069)
at com.openmarket.gator.page.Page.UpdateAssetPublication(Page.java:272)
at com.openmarket.xcelerate.asset.BulkAsset.SaveAllNoLocks(BulkAsset.java:379)
at com.openmarket.assetframework.complexasset.ComplexAsset.superSaveListNoLocks(ComplexAsset.java:2445)
at com.openmarket.assetframework.complexasset.AssetManager.saveListNoLocks(AssetManager.java:1817)
at com.openmarket.assetframework.common.BulkTransactionalAssetManager.saveAllNoPubLock(BulkTransactionalAssetManager.java:305)
at com.openmarket.assetframework.complexasset.ComplexAsset.SaveAllNoPubLock(ComplexAsset.java:2499)
at sun.reflect.GeneratedMethodAccessor1220.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.openmarket.xcelerate.asset.Asset.callSaveAllNoPubLock(Asset.java:5092)
at com.openmarket.xcelerate.asset.Asset.SaveAll_logic(Asset.java:5325)
at com.openmarket.xcelerate.asset.Asset$4.execute(Asset.java:5250)
at com.fatwire.cs.core.db.NestedTransactionBlock.execute(NestedTransactionBlock.java:189)
at com.openmarket.xcelerate.asset.Asset.SaveAll_trans(Asset.java:5273)
at com.openmarket.xcelerate.asset.Asset.SaveAll(Asset.java:5223)
at com.openmarket.assetframework.complexasset.ComplexAsset.superSaveAll(ComplexAsset.java:2562)
at com.openmarket.assetframework.complexasset.AssetManager.saveAll(AssetManager.java:1841)
at com.openmarket.assetframework.common.BulkTransactionalAssetManager.save(BulkTransactionalAssetManager.java:442)
at com.openmarket.assetframework.complexasset.ComplexAsset.Save(ComplexAsset.java:1149)
at com.openmarket.xcelerate.asset.Asset.Save(Asset.java:3798)
at com.openmarket.xcelerate.commands.AssetDispatcher.Save(AssetDispatcher.java:273)
at sun.reflect.GeneratedMethodAccessor1253.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.openmarket.framework.commands.Dispatcher.Execute(Dispatcher.java:145)
at COM.FutureTense.XML.Template.DynTag.execute(DynTag.java:269)
at COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:144)
at COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:120)
at COM.FutureTense.XML.Template.IfChild.execute(BlockTag.java:398)
at COM.FutureTense.XML.Template.IFTag.execute(BlockTag.java:497)
at COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:144)
at COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:120)
at COM.FutureTense.XML.Template.IfChild.execute(BlockTag.java:398)
at COM.FutureTense.XML.Template.IFTag.execute(BlockTag.java:497)
at COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:144)
at COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:120)
at COM.FutureTense.XML.Template.IfChild.execute(BlockTag.java:398)
at COM.FutureTense.XML.Template.IFTag.execute(BlockTag.java:497)
at COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:144)
at COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:120)
at COM.FutureTense.XML.Template.Root.execute(BlockTag.java:366)
at COM.FutureTense.XML.Template.XMLEval.run(XMLEval.java:377)
at COM.FutureTense.Common.ContentServer.evalTheXML(ContentServer.java:3818)
at COM.FutureTense.Common.ContentServer.evalTemplate(ContentServer.java:3034)
at COM.FutureTense.Common.ContentServer.processElement(ContentServer.java:2422)
at COM.FutureTense.Common.CS.CallElement(CS.java:1614)
at com.divine.ics.jsp.CallElement.doEndTag(CallElement.java:84)
at com.openmarket.framework.jsp.Base.doEndTag(Base.java:145)
at jsp_servlet._jsp._cs_deployed._ui._actions.__advanceduihtml._jspService(__advanceduihtml.java:809)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:35)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:295)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:260)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:137)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:353)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at org.apache.logging.log4j.web.Log4jServletFilter.doFilter(Log4jServletFilter.java:64)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at weblogic.servlet.internal.RequestDispatcherImpl.invokeServlet(RequestDispatcherImpl.java:637)
at weblogic.servlet.internal.RequestDispatcherImpl.include(RequestDispatcherImpl.java:508)
at COM.FutureTense.Servlet.ServletRequest.include(ServletRequest.java:1450)
at COM.FutureTense.Servlet.FRequestObj.include(FRequestObj.java:1449)
at COM.FutureTense.Servlet.JSPServices.runJSP(JSPServices.java:111)
at COM.FutureTense.Platform.FileSystem.FILESYSTEMJSPManager.runJSP(FILESYSTEMJSPManager.java:451)
at COM.FutureTense.Servlet.JSPServices.runJSPObject(JSPServices.java:50)
at COM.FutureTense.Platform.FileSystem.FILESYSTEMJSPManager$JSPDataFile.run(FILESYSTEMJSPManager.java:196)
at COM.FutureTense.Common.ContentServer.jspExecute(ContentServer.java:3542)
at COM.FutureTense.Common.ContentServer.evalTemplate(ContentServer.java:3120)
at COM.FutureTense.Common.ContentServer.processElement(ContentServer.java:2422)
at COM.FutureTense.Common.CS.CallElement(CS.java:1614)
at com.fatwire.cs.ui.framework.UIController.execute(UIController.java:168)
at jsp_servlet._jsp._cs_deployed._fatwire._ui._controller.__controller._jspService(__controller.java:99)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:35)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:295)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:260)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:137)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:353)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at org.apache.logging.log4j.web.Log4jServletFilter.doFilter(Log4jServletFilter.java:64)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at weblogic.servlet.internal.RequestDispatcherImpl.invokeServlet(RequestDispatcherImpl.java:637)
at weblogic.servlet.internal.RequestDispatcherImpl.include(RequestDispatcherImpl.java:508)
at COM.FutureTense.Servlet.ServletRequest.include(ServletRequest.java:1450)
at COM.FutureTense.Servlet.FRequestObj.include(FRequestObj.java:1449)
at COM.FutureTense.Servlet.JSPServices.runJSP(JSPServices.java:111)
at COM.FutureTense.Platform.FileSystem.FILESYSTEMJSPManager.runJSP(FILESYSTEMJSPManager.java:451)
at COM.FutureTense.Servlet.JSPServices.runJSPObject(JSPServices.java:50)
at COM.FutureTense.Platform.FileSystem.FILESYSTEMJSPManager$JSPDataFile.run(FILESYSTEMJSPManager.java:196)
at COM.FutureTense.Common.ContentServer.jspExecute(ContentServer.java:3542)
at COM.FutureTense.Common.ContentServer.evalTemplate(ContentServer.java:3120)
at COM.FutureTense.Common.ContentServer.processElement(ContentServer.java:2422)
at COM.FutureTense.Common.CS.CallElement(CS.java:1614)
at com.openmarket.xcelerate.jsp.controller.CallElement.doEndTag(CallElement.java:55)
at com.openmarket.framework.jsp.Base.doEndTag(Base.java:145)
at jsp_servlet._jsp._cs_deployed._openmarket._xcelerate._uiframework.__applicationpage._jsp__tag4(__applicationpage.java:303)
at jsp_servlet._jsp._cs_deployed._openmarket._xcelerate._uiframework.__applicationpage._jsp__tag3(__applicationpage.java:261)
at jsp_servlet._jsp._cs_deployed._openmarket._xcelerate._uiframework.__applicationpage._jspService(__applicationpage.java:150)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:35)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:295)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:260)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:137)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:353)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at org.apache.logging.log4j.web.Log4jServletFilter.doFilter(Log4jServletFilter.java:64)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at weblogic.servlet.internal.RequestDispatcherImpl.invokeServlet(RequestDispatcherImpl.java:637)
at weblogic.servlet.internal.RequestDispatcherImpl.include(RequestDispatcherImpl.java:508)
at COM.FutureTense.Servlet.ServletRequest.include(ServletRequest.java:1450)
at COM.FutureTense.Servlet.FRequestObj.include(FRequestObj.java:1449)
at COM.FutureTense.Servlet.JSPServices.runJSP(JSPServices.java:111)
at COM.FutureTense.Platform.FileSystem.FILESYSTEMJSPManager.runJSP(FILESYSTEMJSPManager.java:451)
at COM.FutureTense.Servlet.JSPServices.runJSPObject(JSPServices.java:50)
at COM.FutureTense.Platform.FileSystem.FILESYSTEMJSPManager$JSPDataFile.run(FILESYSTEMJSPManager.java:196)
at COM.FutureTense.Common.ContentServer.jspExecute(ContentServer.java:3542)
at COM.FutureTense.Common.ContentServer.evalTemplate(ContentServer.java:3120)
at COM.FutureTense.Common.ContentServer.generatePage(ContentServer.java:1994)
at COM.FutureTense.Common.ContentServer.evalPage(ContentServer.java:1435)
at COM.FutureTense.Common.ContentServer.execute(ContentServer.java:533)
at COM.FutureTense.Servlet.FTServlet.execute(FTServlet.java:120)
at COM.FutureTense.Servlet.FTServlet.doPost(FTServlet.java:60)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:295)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:260)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:137)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:353)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at oracle.wcsites.eloquaintegration.EloquaAuthenticationFilter.doFilter(EloquaAuthenticationFilter.java:64)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at COM.FutureTense.Servlet.URLRewriteFilter.doFilter(URLRewriteFilter.java:98)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at com.fatwire.auth.RequestAuthenticationFilter.doFilter(RequestAuthenticationFilter.java:256)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at com.fatwire.wem.sso.cas.filter.CASFilter.doFilter(CASFilter.java:312)
at com.fatwire.wem.sso.SSOFilter.doFilter(SSOFilter.java:51)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at com.fatwire.cs.ui.framework.UIFilter.doFilter(UIFilter.java:105)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at COM.FutureTense.Security.Common.ContentSecurityFilter.doFilter(ContentSecurityFilter.java:112)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at org.apache.logging.log4j.web.Log4jServletFilter.doFilter(Log4jServletFilter.java:71)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at oracle.security.jps.ee.http.JpsAbsFilter$3.run(JpsAbsFilter.java:175)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:650)
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:112)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilterInternal(JpsAbsFilter.java:293)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:150)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:94)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:248)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at oracle.jrf.servlet.ExtensibleGlobalFilter.doFilter(ExtensibleGlobalFilter.java:92)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3797)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3763)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:344)
at weblogic.security.service.SecurityManager.runAsForUserCode(SecurityManager.java:197)
at weblogic.servlet.provider.WlsSecurityProvider.runAsForUserCode(WlsSecurityProvider.java:203)
at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:71)
at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2451)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2299)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2277)
at weblogic.servlet.internal.ServletRequestImpl.runInternal(ServletRequestImpl.java:1710)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1670)
at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:272)
at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:352)
at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:337)
at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:57)
at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41)
at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:655)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:420)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:360)



Changes

 None

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


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