Publishing failed with ORA-01460: unimplemented or unreasonable conversion requested
(Doc ID 1509054.1)
Last updated on JUNE 12, 2023
Applies to:
Oracle WebCenter Sites - Version 11.1.1.6.0 and laterInformation in this document applies to any platform.
Symptoms
Publishing failed when inserting data into FW_PubDataStore and FW_MsgBus tables. For example:
[ERROR] [http-8080-6] [fatwire.logging.cs.db] Exception executing prepared statement: INSERT INTO FW_PubDataStore (ID,RESKEY,BDATA,BDATASIZE,ENCODING,TYPE,PUBSESSION,PUBGROUP) VALUES (?,?,?,?,?,?,?,?)
ID = 1352308452008
RESKEY = MANIFEST:3_PREMIUM_
BDATA = /tomcat/temp/fwcs-tmp/temp11/dcs3524142716591894335.tmp
BDATASIZE = 17751
ENCODING = UTF-8
TYPE = MANIFEST
PUBSESSION = 1352308451821
PUBGROUP = 3_PREMIUM_
java.sql.SQLException: ORA-01460: unimplemented or unreasonable conversion requested
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1093)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2047)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2709)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at COM.FutureTense.Servlet.JDBCTable.executeUpdate_trans_logic(JDBCTable.java:1367)
at COM.FutureTense.Servlet.JDBCTable.access$000(JDBCTable.java:68)
at COM.FutureTense.Servlet.JDBCTable$1.execute(JDBCTable.java:1319)
at com.fatwire.cs.core.db.NestedTransactionBlock.execute(NestedTransactionBlock.java:180)
at COM.FutureTense.Servlet.JDBCTable.executeUpdate_trans(JDBCTable.java:1324)
at COM.FutureTense.Servlet.JDBCTable.executeUpdate(JDBCTable.java:1211)
at COM.FutureTense.Servlet.JDBCTable.AddRow(JDBCTable.java:943)
at COM.FutureTense.Common.ftDBTable.insertRow(ftDBTable.java:1271)
at COM.FutureTense.CatalogManager.CatalogEngine._addRowsToTable(CatalogEngine.java:1031)
at COM.FutureTense.CatalogManager.CatalogEngine.access$200(CatalogEngine.java:43)
at COM.FutureTense.CatalogManager.CatalogEngine$2.execute(CatalogEngine.java:965)
at com.fatwire.cs.core.db.NestedTransactionBlock.execute(NestedTransactionBlock.java:180)
at COM.FutureTense.CatalogManager.CatalogEngine.addRowsToTable_trans(CatalogEngine.java:974)
at COM.FutureTense.CatalogManager.CatalogEngine.addRowsToTable(CatalogEngine.java:857)
at COM.FutureTense.Common.CatalogManager.execute(CatalogManager.java:759)
at COM.FutureTense.Common.ContentServer.runManager(ContentServer.java:3338)
at COM.FutureTense.Common.CS.CatalogManager(CS.java:1501)
at COM.FutureTense.Common.CS.CatalogManager(CS.java:1456)
at com.openmarket.basic.common.BaseTable.callCatalogManager(BaseTable.java:97)
at com.fatwire.datastore.BasicDataStoreTable.insert(BasicDataStoreTable.java:132)
at com.fatwire.datastore.BasicDataStore.put(BasicDataStore.java:55)
at com.fatwire.realtime.PubDataPackager.execute(PubDataPackager.java:91)
at com.fatwire.realtime.PubMain._standardPublish(PubMain.java:324)
at com.fatwire.realtime.PubMain.execute(PubMain.java:109)
at org.apache.jsp.jsp.cs_005fdeployed.OpenMarket.Xcelerate.PrologActions.Publish.AdvPub.PublishApprovedAssets_jsp._jspService(PublishApprovedAssets_jsp.java:98)
...
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 |
Cause |
Solution |