Upgrade From Content Server 7.6.2 To WebCenter Sites11GR1 BP1 Failed Due To Failure To Import AssetPublication.html File (Doc ID 1565566.1)

Last updated on OCTOBER 01, 2019

Applies to:

Symptoms

Upgrade from Content Server 7.6.2 to WebCenter Sites 11GR1 BP1 failed with this error in the futuretense.txt log file:

[ERROR] [http-8080-5] [fatwire.logging.cs.db] SQLException executing query: insert into AssetPublication (id,pubid,assettype,assetid) select id,pubid,assettype,assetid from <table>
java.sql.SQLException: Cannot insert duplicate key row in object 'dbo.AssetPublication' with unique index '<indexid>'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:723)
at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:1160)
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at COM.FutureTense.Servlet.JDBCConn.ExecuteQuery_trans(JDBCConn.java:983)
at COM.FutureTense.Servlet.JDBCConn$1.execute(JDBCConn.java:594)
at com.fatwire.cs.core.db.NestedTransactionBlock.execute(NestedTransactionBlock.java:180)
at COM.FutureTense.Servlet.JDBCConn.ExecuteQuery(JDBCConn.java:599)
at COM.FutureTense.Common.ftDBTable.doSQL(ftDBTable.java:2190)
at COM.FutureTense.Common.ftDBTable.doSQL(ftDBTable.java:2177)
at COM.FutureTense.CatalogManager.MirrorEngine.commitTables_trans_logic(MirrorEngine.java:3960)
at COM.FutureTense.CatalogManager.MirrorEngine$1.execute(MirrorEngine.java:3634)
at com.fatwire.cs.core.db.NestedTransactionBlock.execute(NestedTransactionBlock.java:180)
at COM.FutureTense.CatalogManager.MirrorEngine.commitTables_trans(MirrorEngine.java:3639)
at COM.FutureTense.CatalogManager.MirrorEngine.commitTables(MirrorEngine.java:3118)
at COM.FutureTense.Common.CatalogManager.execute(CatalogManager.java:2024)
at COM.FutureTense.Common.ContentServer.runManager(ContentServer.java:3351)
at COM.FutureTense.Common.CS.CatalogManager(CS.java:1503)
at COM.FutureTense.Common.CS.CatalogManager(CS.java:1457)
at COM.FutureTense.Apps.Install.command.ImportCatalog.doIt(ImportCatalog.java:565)
at COM.FutureTense.Apps.Install.command.ImportCatalog.importCatalogDirectory(ImportCatalog.java:729)
at COM.FutureTense.Apps.Install.command.ImportCatalog.doImport(ImportCatalog.java:271)
at COM.FutureTense.Apps.Install.command.ImportCatalog.exec(ImportCatalog.java:189)
at COM.FutureTense.Apps.Install.command.Command.execute(Command.java:130)
at COM.FutureTense.Apps.Install.server.InstallManager.invokeCommand(InstallManager.java:479)
at COM.FutureTense.Apps.Install.server.InstallManager.execute(InstallManager.java:104)
at COM.FutureTense.Apps.Install.server.InstallServer.evalPage(InstallServer.java:123)
at COM.FutureTense.Common.ContentServer.execute(ContentServer.java:454)
at COM.FutureTense.Servlet.FTServlet.execute(FTServlet.java:129)
at COM.FutureTense.Servlet.FTServlet.doPost(FTServlet.java:61)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.fatwire.auth.RequestAuthenticationFilter.doFilter(RequestAuthenticationFilter.java:192)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.fatwire.wem.sso.cas.filter.CASFilter.doFilter(CASFilter.java:695)
at com.fatwire.wem.sso.SSOFilter.doFilter(SSOFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:662)
[ERROR] [http-8080-5] [fatwire.logging.cs.install] ImportCatalogsendCommitToServer: Error commiting the table. Error number=-611
[ERROR] [http-8080-5] [fatwire.logging.cs.install] ImportCatalog importCatalogFile: error importing the file. [path to installation files]/WebCenterSites_11.1.1.6_bp1/WCS_Sites_11.1.1.6_bp1/Sites/FirstSiteII/Core/Populate/AssetPublication.html
[ERROR] [http-8080-5] [fatwire.logging.cs.install] ImportCatalog Importing file= [path to installation files]/WebCenterSites_11.1.1.6_bp1/WCS_Sites_11.1.1.6_bp1/Sites/FirstSiteII/Core/Populate/AssetPublication.html fail due to error -611

Changes

Cause

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