Publishing failed with ORA-01460: unimplemented or unreasonable conversion requested (Doc ID 1509054.1)

Last updated on JUNE 29, 2017

Applies to:

Oracle WebCenter Sites - Version 11.1.1.6.0 and later
Information in this document applies to any platform.
***Checked for relevance on 08-May-2014***

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

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