Wednesday, August 28, 2013

Concurrent Processing - Concurrent Reports Failing With Errors REP-0004,REP-0082 and REP-0104 : R12

Concurrent Processing - 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

SOLUTION

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.


IMP-NOTE : 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"


++++++++++++++++++++++
ID 844976.1
+++++++++++++++++++++++++++++
REP-0082 Error Encountered While Running Reports (Doc ID 1139515.1)
CAUSE
The custom directories added in the "REPORTS_PATH" environment variable didn't have access permissions for the "oracle"user. As a result, the Reports Server was not able to access them.
SOLUTION
To implement the solution, please perform the following steps :
  1. Add 755 permissions on those custom directories for "oracle" user.
  2. Restart the Reports Server.
  3. Now run the report using the "rwclient.sh" command or the "rwservlet" URL and it will run properly.
++++++++++++++++++++++
"REP-0082: Error Executing SCA Utility" and "REP-0110: Unable to Open File While Running Reports" (Doc ID 286546.1)

CAUSE

Changes to REPORTS_PATH were done in reports.sh.

SOLUTION

1. Test by providing the report name with the entire directory path.

2. Once successful:
On Unix:
---------
Check the REPORTS_PATH in reports.sh to include all directories containing Reports rdf , rep, jsp files.
3. Restart Reports server and OC4J_BI_Forms.
4. Run reports.

No comments:

Post a Comment