ORA-12899: Value Too Large For Column "RW_JOBS"."CACHEKEY" (Doc ID 1286971.1)

Last updated on JULY 26, 2016

Applies to:

Oracle Reports Developer - Version 11.1.1.3.0 and later
Information in this document applies to any platform.
Checked for relevance on 23-May-2013

Symptoms

Using the database for jobRepository as part of the HA setup of Reports.

Although most of the reports are running successfully, there is a report that cannot be executed. Oracle Reports creates a hash which is too large for the database to handle and throws up the following error in rwserver_diagnostic.log:

[2011-01-20T11:52:25.069-08:00] [reports] [INCIDENT_ERROR]
[REP-12899] [oracle.reports.server] [tid: 15] [ecid:0000IqWSkRD7MAWjLx6UOA1DDq^g000003,0] 
REP-12899 : java.sql.SQLException: ORA-12899: value too large for column "<SCHEMA>"."RW_JOBS"."CACHEKEY" (actual: 520, maximum: 500)[[

oracle.reports.RWException: IDL:oracle/reports/RWException:1.0
at oracle.reports.utility.Utility.newRWException(Utility.java:1046)
at oracle.reports.utility.DBConnection.handleSQLException(DBConnection.java:240)
at oracle.reports.server.BLOBHelper.updateJob(BLOBHelper.java:272)
at oracle.reports.server.JobStoreDB.writePersistFile(JobStoreDB.java:236)
at oracle.reports.server.JobManager.moveJob(JobManager.java:1598)
at oracle.reports.server.JobManager.updateJobStatus(JobManager.java:2801)
at oracle.reports.server.EngineCommImpl.updateEngineJobStatus(EngineCommImpl.java:154)
at oracle.reports.server.EngineCommPOA._invoke(EngineCommPOA.java:94)
at com.sun.corba.se.impl.protocol.CorbaServerRequestDispatcherImpl.dispatchToServant(CorbaServerRequestDispatcherImpl.java:637)
at com.sun.corba.se.impl.protocol.CorbaServerRequestDispatcherImpl.dispatch(CorbaServerRequestDispatcherImpl.java:189)
at com.sun.corba.se.impl.protocol.CorbaMessageMediatorImpl.handleRequestRequest(CorbaMessageMediatorImpl.java:1682)
at com.sun.corba.se.impl.protocol.CorbaMessageMediatorImpl.handleRequest(CorbaMessageMediatorImpl.java:1540)
at com.sun.corba.se.impl.protocol.CorbaMessageMediatorImpl.handleInput(CorbaMessageMediatorImpl.java:922)
at com.sun.corba.se.impl.protocol.giopmsgheaders.RequestMessage_1_2.callback(RequestMessage_1_2.java:181)
at com.sun.corba.se.impl.protocol.CorbaMessageMediatorImpl.handleRequest(CorbaMessageMediatorImpl.java:694)
at com.sun.corba.se.impl.transport.SocketOrChannelConnectionImpl.dispatch(Socket ....

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