REP-56093: Cached Output For Job <###> Is No Longer Valid Running Large Report
REP-56093: Cached Output For Job <###> Is No Longer Valid Running Large Report
Titleimage
Posted by Patrick Hamou on 2017:09:20 00:29:46
APPLIES TO: Oracle Reports Developer
Oracle Reports Developer - Version 9.0.2.1 to 11.1.2.0.0 [Release 9i to 11g]
Information in this document applies to any platform.
SYMPTOMS
Running a report with large data output, fails with error after what seems to be a long time period. When limiting the data output to a smaller amount of data, the error does not occur.
The following error comes up:
REP-56093: Cached output for job 878 is no longer valid
CAUSE: WLS Reports, Reports Server, Cachesize
Property name Cachesize in the
- <Midtier>$ORACLE_HOME/reports/conf/<reportsserver>.conf for 10g Reports Server or
- ORACLE_INSTANCE/config/ReportsServerComponent/<repservername>/rwserver.conf for standalone Reports Server version 11.1.1.2 (and later) or
- DOMAIN_HOME/config/fmwconfig/servers/WLS_REPORTS/applications/reports_11.1.2/configuration/rwserver.conf for in-process Reports Server version 11.1.2
is too small to handle the amount of data being returned.
"Finished successfully but output is voided" message indicates the Job_ID on the
final server existed but was removed from the cache due to either cacheSize or
maxCacheFileNumber.
The fact that this only occurs on report output that exceeds cachesize shows us
that the cachesize is too small for the report output and the output has been removed from cache.
SOLUTION: WLS_REPORTS, cacheSize
To implement the solution, please execute the following steps:
1. Make a backup copy of the <reportsserver>.conf / rwserver.conf file
2. Change the following line in this file to a number larger than your largest report output:
<property name="cacheSize" value="50"/>Value is in megabytes.
3. Be certain that the value does not exceed the amount of space on the filesystem or directory for the specified cacheDir. Check the following property name to see if it has been changed from the default directory. Default directory is D:\<Midtier>$ORACLE_HOME\reports\cache for 10g.
<property name="cacheDir" value="your cache directory"/>
If this property has "!--" at the beginning, and "--" at the end, it is already commented:
<!--property name="cacheDir" value="your cache directory"/-->
4. Bounce REPORTS SERVER and OC4J_BI_Forms instance (10g) / WLS_REPORTS (11g).
Posted by Patrick Hamou on 2017:09:20 00:29:46