REP-0004: Warning: Una…

Applies to:

Oracle Application Object Library - Version 12.0.0 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.
Checked for relevance on 25-SEP-2012

Symptoms

When attempting to run any concurrent requests of the type Oracle Reports (rdf) , the following error is encountered in the concurrent request log file:

REP-0004: Warning: Unable to open user preference file.
REP-0082: Error executing SCA utility.
REP-0104: Unable to delete file ''.
scaba 5
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-159:

 

Other Symptoms

In 12.1.1  all the reports are failing with following errors:

American_America.UTF8

'.,'

stat_low = 9
stat_high = 0
emsg:was terminated by signal 9
Enter Password: 

+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
Program was terminated by signal 9
Concurrent Manager encountered an error while running Oracle*Report for your concurrent request 123456.

 

Changes

There has been no change in the environment.

Cause

Reports.log located under $APPLCSF/$APPLLOG has reached the maximum file size limit of 2GB.

Solution

To implement the solution, please execute the following steps:

1. Stop the concurrent managers using adcmctl.sh.

2. Truncate the reports.log file in log directory (under $APPLCSF/$APPLLOG).

3. Restart the concurrent managers.

4. Submit Concurrent request of type RDF from Oracle Applications and ensure it completes normal.

Truncation of file "reports.log" is a regular maintenance work of Application DBA. Make sure that reports log file size should not increase its maximum limit of 2 GB. There is no purge concurrent program to truncate file "reports.log". This maintenance needs to be done manually and regularly depending on number of concurrent program which uses "reports.log". You can safely truncate "reports.log".

Information Center, Diagnostics, & Community