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 |