Oracle EBS Concurrent Reports Failing With Errors REP-0004,REP-0082 and REP-0104
Cause
Reports.log located under $APPLCSF/$APPLLOG has reached the maximum file size limit of 2GB.
To implement the solution, please execute the following steps:
1. Stop the concurrent managers using adcmctl.sh.
2. Remove 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".
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 '<Name.rdf>'.
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.
Cause
Reports.log located under $APPLCSF/$APPLLOG has reached the maximum file size limit of 2GB.
To implement the solution, please execute the following steps:
1. Stop the concurrent managers using adcmctl.sh.
2. Remove 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".
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 '<Name.rdf>'.
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.