Thursday, December 5, 2013

Intermittent Oracle Reports REP-0069: REP-57054

Error in concurrent request logfile :

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

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

In short, cacheSize other than zero in $INST_TOP/ora/10.1.2/reports/conf/rwbuilder.conf is a workaround.
The workaround will cause the cache to grow and it will require manual clean up.

The permanent fix is the application of Patch 11669923.

1.  Download and review the readme before applying Patch 11669923 or more recent Patch 14374587.  Follow the patch readme for any prerequisite and/or post-installation steps.

Note 1: Patch 14374587 Readme states:
"
# This  fix is merged with previous MLR 11669923.
# Please ignore any conflict message for patch 11669923"

As per Doc ID 437878.1, patch 11669923 supersedes patch 8602992; therefore, any conflict with patch 8602992 can also be ignored.


2.  Ensure / set the cacheSize parameter to a value of "0" within the file $INST_TOP/ora/10.1.2/reports/conf/rwbuilder.conf as follows:

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  
in this file under the section
ie:




value="%s_logs_dir%/ora/10.1.2/reports/cache"/>


Note 2: The above two actions prevents the accumulation of new temporary files from being created & retained; however, any temp files created before the fix will need to be deleted manually.


d. Now run autoconfig so that $INST_TOP/ora/10.1.2/reports/conf/rwbuilder.conf is generated with new content.

Otherwise, the temp file will grow within the directory $INST_TOP/logs/ora/10.1.2/reports/cache as documented in Note 859255.1 "Reports Cache Directory in Oracle E-Business R12 is Growing Rapidly"

3.  In order to prevent Autoconfig from making changes introduced by Patch 11669923, follow Note 1322704.1 "Patch 11669923 Post Patch Instructions Would Get Overridden By Autoconfig" or apply Techstack (TXK) one-off Patch 11776182 "Add New Property NOVOIDEDOUTPUTERROR In RWBuilder Template File".

4 comments:

Nitzz said...

I had the same issue. I resolved it by handling the division by zero in Formula columns of RDF.

Inkisar said...

Need to increase Cache size as if new report file is going to increase the overall Cache size then same error will appear.

Ashley Rosa said...

Are you having connectivity issues in your Binance account? What could be done to end this error instantly? If you have no solutions related to this error, you need not worry at all and instead of pondering about the situation you can directly contact with the professionals. Dial Binance phone number which is always active and users can always consult the team of specialists who are always there to guide you. The team loves to support you till the time you don’t get the process clearly.

Ashley Rosa said...

Do you want to create the Blockchain account? Are you having trouble in sign-up in Blockchain account? If yes, take assistance from the team who is there to guide you. You can have conversation with the team who is there to assist you. Talk to the team who is ready to guide you in no time. Get a chance to talk to the leading team member over Blockchain customer care number which is available to cater guidance. The team is always functional to help you in every possible way for better results. Unable to execute the process of Binance 2fa reset.

More info visit here:

Blockchain customer care
Crypto customer support
Binance customer support number