Showing posts with label REP-57054. Show all posts
Showing posts with label REP-57054. Show all posts

Thursday, May 8, 2014

Oracle Reports REP-0069: REP-57054: Error

When any concurrent requests with the execution method Oracle Reports are submitted, temp files are created under the path of 

$INST_TOP/logs/ora/10.1.2/reports/cache

These files are not purged with the "Purge Concurrent Request and/or Manager Data" program.These files can be deleted manually.

Sometimes, concurrent programs fail with following error message

"REP-0069: Internal error
REP-57054: In-process job terminated:Finished successfully but output is voided"

As workaround , setting cachesize parameter to value bigger than 0 can be used. But this workaround disables Cache cleanup functionality which is deletion of temp report file after Concurrent request completed successfully.So manual cleanup of cache will be needed.

According to Metalink Note : 1237834.1 permanent fix is as follow,

1. Apply Patch 14374587

2. Add the following property names and values into $INST_TOP/ora/10.1.2/reports/conf/rwbuilder.conf

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

With patch and setting these properties , accumulation of temp files are prevented.

3. But Autoconfig will overwrite above these changes when executed.To prevent this ,

a. Create custom directory under $FND_TOP/admin/template
    mkdir $FND_TOP/admin/template/custom

b. Copy $FND_TOP/admin/template/rwbuilder_conf_1012.tmp to this new directory
    cp $FND_TOP/admin/template/rwbuilder_conf_1012.tmp $FND_TOP/admin/template/custom

c. Add same entries into rwbuilder_conf_1012.tmp as above

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

Wednesday, February 19, 2014

REP-0004,REP-0069 and REP-57054 errors while APXAPRVL program running

I would like to give brief information about REP-57054 , REP-0069, REP-0004 error which occur while invoice validation  -  APXAPRVL concurrent program working .

Error:
REP-0004: Warning: Unable to open user preference file.
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:


Cause of  reports.log file under $APPLCSF/$APPLLOG reached 2GB size limit is the reason of this error.

For solution,

1.Stop concurrent managers
2.Truncate "reports.log" file
3.Restart concurrent managers
4.Observe the results after submitting related concurrent program

I have taken this solution from metalink . But i did not stop managers . Directly truncate reports.log by ">" command has solved my problem.