Error "java.lang.NoSuchFieldException: editorid" for PageAttribute after upgrading from WebCenter Sites 11.1.1.6.x to 11.1.1.8.0 (Doc ID 2017434.1)

Last updated on JULY 07, 2017

Applies to:

Oracle WebCenter Sites - Version 11.1.1.8.0 to 11.1.1.8.0 [Release FatWire]
Information in this document applies to any platform.

Symptoms

When inspecting a Page asset, seeing "Missing translation key: locale=',en_US'dvin/AT/Common/StatusCode-'" in the Status field along with the following error in sites.log:

[2015-06-01 16:38:41,720 CDT] [ERROR] [.kernel.Default (self-tuning)'] [fatwire.logging.cs.framework] Exception reading from a list for PageAttribute
java.lang.NoSuchFieldException: editorid
    at COM.FutureTense.Common.Query.getValue(Query.java:251)
    at com.openmarket.framework.objects.FieldList.Gather(FieldList.java:138)
    at com.openmarket.framework.objects.AbstractContent.Gather(AbstractContent.java:151)
    at com.openmarket.framework.objects.AbstractObject.Read(AbstractObject.java:528)
    at com.openmarket.xcelerate.asset.Asset.Read(Asset.java:3353)
    at com.openmarket.assetframework.complexasset.ComplexAsset.superread(ComplexAsset.java:1112)
    at com.openmarket.assetframework.complexasset.AssetManager.read(AssetManager.java:374)
    at com.openmarket.assetframework.common.BulkTransactionalAssetManager.read(BulkTransactionalAssetManager.java:528)
    at com.openmarket.assetframework.complexasset.ComplexAsset.Read(ComplexAsset.java:1095)
    at com.openmarket.assetframework.complexasset.ComplexAsset.Load(ComplexAsset.java:855)

Also, if CSDT is being used to export Page assets, the following error might occur:

[2015-06-02 23:26:53,319 CDT] [ERROR] [.kernel.Default (self-tuning)'] [fatwire.logging.cs.db] SQLException in prepared execute on table PageAttribute: SELECT id,name,attributetype,editorid,status,createdby,createddate,updatedby,updateddate,description,startdate,enddate,subtype,filename,path,template,urlexternaldoc,externaldoctype,urlexternaldocxml,fw_uid FROM PageAttribute WHERE id = ?
id = 1343751038018
java.sql.SQLSyntaxErrorException: ORA-00904: "EDITORID": 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.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
    at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:884)
    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.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:10514)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3591)
    at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3637)
    at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1495)
    at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:135)
    at COM.FutureTense.Servlet.JDBCTable.executeQuery_trans_logic(JDBCTable.java:1632)
    at COM.FutureTense.Servlet.JDBCTable.executeQuery_trans(JDBCTable.java:1590)
    at COM.FutureTense.Servlet.JDBCTable.executeQuery(JDBCTable.java:1430)
    at COM.FutureTense.Servlet.JDBCTable.SelectRow(JDBCTable.java:1025)
    at COM.FutureTense.Common.ftDBTable.gather(ftDBTable.java:1223)
    at COM.FutureTense.CatalogManager.CatalogEngine.updateTable_trans(CatalogEngine.java:1868)
    at COM.FutureTense.CatalogManager.CatalogEngine.updateTable(CatalogEngine.java:1729)
    at COM.FutureTense.Common.CatalogManager.execute(CatalogManager.java:786)
    at COM.FutureTense.Common.ContentServer.runManager(ContentServer.java:3442)
    at COM.FutureTense.Common.CS.CatalogManager(CS.java:1503)
    at COM.FutureTense.Common.CS.CatalogManager(CS.java:1457)
    at com.fatwire.realtime.util.Util.loadAssetData(Util.java:408)
    at com.fatwire.realtime.idmapping.IdMappingFacilitator.getUidFor(IdMappingFacilitator.java:519)
    at com.fatwire.realtime.idmapping.IdMapKeeper.getUidFor(IdMapKeeper.java:107)
    at com.fatwire.realtime.packager.FSDataStore.getKey(FSDataStore.java:670)
    at com.fatwire.realtime.packager.FSDataStore.getKey(FSDataStore.java:642)
    at com.fatwire.realtime.packager.CSDTUtil._shouldExport(CSDTUtil.java:220)
    at com.fatwire.realtime.packager.CSDTUtil._export(CSDTUtil.java:156)
    at com.fatwire.realtime.packager.CSDTUtil.Export(CSDTUtil.java:77)
    at com.fatwire.csdt.service.impl.ExportService._export(ExportService.java:139)
    at com.fatwire.csdt.service.impl.ExportService.execute(ExportService.java:61)
    at jsp_servlet._jsp._cs_deployed._openmarket._xcelerate._prologactions._publish._csdt.__csdtservice._jspService(__csdtservice.java:223)

Changes

The environment was recently upgraded from WebCenter Sites 11.1.1.6.x to 11.1.1.8.0.

Note that as per our 11.1.1.8.0 upgrade guide - https://docs.oracle.com/cd/E29542_01/doc.1111/e35831/cs_beforeupgrade.htm#WBCSG189 :

1.6.3 Changes to Database Tables
If upgrade is performed from WebCenter Sites 11gR1 (11.1.1.6.x), then in the PageAttribute table, the editorid column is removed.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms