REP-54002: file : Cache item is no longer valid

We have observed many requests of couple of concurrent prorgams in our R12 instance go into error with below kind of message:

Enter Password:
MSG-01001: Entering AfterPForm
MSG-01001: Starting to retrive former request parameter by request ID
MSG-01001: Exiting AfterPForm
MSG-01010: :S_BATCH_COUNT = 0
REP-0069: Internal error
REP-57054: In-process job terminated:Executed successfully but there were some errors when distribute the output
REP-50159: Executed successfully but there were some errors when distribute the output
REP-54002: file : Cache item is no longer valid

Below ACTION PLAN was followed to correct the situation:

STEP 1:

Stop application services

STEP 2:

Apply patch 14374587 APPS6:REP-57054 REP-50159 REP-54002 ERROR WHEN RUNNING REPORT IN BATCH

STEP 3:

Edit the Rwbuilder.conf file, per patch 14374587 README:

$INST_TOP/ora/10.1.2/reports/conf/rwbuilder.conf

* Set the following values

<property name="cacheSize" value="0"/> 
<property name="noVoidedOutputError" value="yes"/>

NOTE: On All Apps Nodes

STEP 4:

* Manually remove all files from cache directory found in file rwbuilder.conf

Location :$LOG_HOMEs/ora/10.1.2/reports/cache

NOTE: On All Apps Nodes

STEP 5:

a) Create a custom directory under $FND_TOP/admin/template

     mkdir $FND_TOP/admin/template/custom

b) Copy the file $FND_TOP/admin/template/rwbuilder_conf_1012.tmp to this custom directory.

c) Add the following property names and values under the <cache class=”oracle.reports.cache.RWCache”> section:

<property name="cacheSize" value="0"/>
<property name="noVoidedOutputError" value="yes"/>

Example:

<cache class="oracle.reports.cache.RWCache">
<property name="cacheSize" value="0"/>
<property name="noVoidedOutputError" value="yes"/>
<property name="cacheDir"
value="%s_logs_dir%/ora/10.1.2/reports/cache"/>
<!--property name="maxCacheFileNumber" value="max number of cache files"/-->
<!--property name="ignoreParameters" value="parameter names to be
ignored in constructing cache key, separated by comma ','"/-->
</cache>

NOTE: On Any one Apps Node if you have shared APPL_TOP

Reference:

Metalink Doc : Intermittent Oracle Reports REP-0069: REP-57054: Error (Doc ID 1237834.1)

Author
Recent Posts

Brijesh Gogia

I’m an experienced Cloud/Oracle Applications/DBA Architect with more than 15 years of full-time DBA/Architect experience. I have gained wide knowledge on Oracle and Non-Oracle software stack running on-prem and on Cloud and have worked on several big projects for multi-national companies. I enjoy working with leading-edge technology and have a passion for Cloud architecture, automation, database performance, and stability. Thankfully my work allows me time for researching new technologies (and to write about them).

REP-54002: file : Cache item is no longer valid

Related posts: