My Oracle Support Banner

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

Last updated on MARCH 12, 2021

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 25-Feb-2019 ****

Symptoms

Using the database for jobRepository as part of the High Availability (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:

[date/time] [reports] [INCIDENT_ERROR]
[REP-12899] [oracle.reports.server] [tid: 15] [ecid:<ECID>] 
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

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
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.