Site Plan issues after upgrading from 11.1.1.6.0 to 11.1.1.8.0 (Doc ID 1581492.1)

Last updated on JUNE 28, 2022

Applies to:

Symptoms

After upgrading to 11.1.1.8.0 , The site plan got corrupted. It is not possible to expand it nor to place pages.

The following error is shown in the UI when placing a page:
Unable to load /cs/ContentServer?pagename=fatwire%2Fui%2Fcontroller%2Fcontroller&elementName=UI%2FActions%2FTree%2FPlacePagestatus:500

And this is shown in the logs when placing a page in the SitePlan:

[2013-08-30 10:37:16,973 UTC] [ERROR] [.kernel.Default (self-tuning)'] [fatwire.logging.cs.request] Exception including resource /jsp/cs_deployed/UI/Actions/Tree/PlacePageAction.jsp
com.fatwire.cs.ui.framework.UIException: org.codehaus.jackson.JsonParseException: Unexpected character ('u' (code 117)): expected a valid value (number, String, array, object, 'true', 'false' or 'null')
at [Source: java.io.StringReader@59a1caea; line: 1, column: 30]
       at jsp_servlet._jsp._cs_deployed._ui._actions._tree.__placepageaction._jspService(__placepageaction.java:178)
       at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
       at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
       at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
       at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
       at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:184)
       at weblogic.servlet.internal.RequestDispatcherImpl.invokeServlet(RequestDispatcherImpl.java:526)
       at weblogic.servlet.internal.RequestDispatcherImpl.include(RequestDispatcherImpl.java:447)
       at COM.FutureTense.Servlet.ServletRequest.include(ServletRequest.java:1411)
       at COM.FutureTense.Servlet.FRequestObj.include(FRequestObj.java:1428)
       at COM.FutureTense.Servlet.JSPServices.runJSP(JSPServices.java:111)
       at COM.FutureTense.Platform.FileSystem.FILESYSTEMJSPManager.runJSP(FILESYSTEMJSPManager.java:463)
       at COM.FutureTense.Servlet.JSPServices.runJSPObject(JSPServices.java:50)
       at COM.FutureTense.Platform.FileSystem.FILESYSTEMJSPManager$JSPDataFile.run(FILESYSTEMJSPManager.java:190)
       at COM.FutureTense.Common.ContentServer.jspExecute(ContentServer.java:3027)
       at COM.FutureTense.Common.ContentServer.evalTemplate(ContentServer.java:2621)
       at COM.FutureTense.Common.ContentServer.processElement(ContentServer.java:1999)
       at COM.FutureTense.Common.CS.CallElement(CS.java:1603)
       at com.fatwire.cs.ui.framework.UIController.execute(UIController.java:133)
       at jsp_servlet._jsp._cs_deployed._fatwire._ui._controller.__controller._jspService(__controller.java:89)
       at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)

The following error is shown in the logs when trying to expand the Site Plan:

[2013-08-30 10:34:53,970 UTC] [ERROR] [.kernel.Default (self-tuning)'] [fatwire.logging.cs.db] SQLException executing query: SELECT nid as mynid FROM SitePlanTree WHERE oid = Variables.assetid
java.sql.SQLSyntaxErrorException: ORA-00904: "VARIABLES"."ASSETID": invalid identifier

       at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
       at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
       at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
       at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
       at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
       at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
       at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
       at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:873)
       at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
       at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
       at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4692)
       at oracle.jdbc.driver.OracleStatement.doScrollStmtExecuteQuery(OracleStatement.java:4825)
       at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1913)
       at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1871)
       at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:318)
       at weblogic.jdbc.wrapper.Statement.execute(Statement.java:485)
       at COM.FutureTense.Servlet.JDBCConn.ExecuteQuery_trans(JDBCConn.java:995)
       at COM.FutureTense.Servlet.JDBCConn.ExecuteQuery(JDBCConn.java:623)
       at COM.FutureTense.Common.ftDBTable.doSQL(ftDBTable.java:2199)
       at COM.FutureTense.CatalogManager.CatalogEngine.runSQL(CatalogEngine.java:2733)
       at COM.FutureTense.CatalogManager.CatalogEngine._queryAndCache(CatalogEngine.java:4944)
       at COM.FutureTense.CatalogManager.CatalogEngine.access$800(CatalogEngine.java:45)
       at COM.FutureTense.CatalogManager.CatalogEngine$8.execute(CatalogEngine.java:4925)
       at com.fatwire.cs.core.db.NestedTransactionBlock.execute(NestedTransactionBlock.java:189)
       ......

Cause

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