My Oracle Support Banner

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 NOVEMBER 02, 2022

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 = <AssetID>
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

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.